Convert XLS to NDJSON

XLS files are Excel files that use the Binary Interchange File Format (BIFF). This was the default format for Excel versions 97-2003.

XLS files can have multiple sheets, and each sheet can contain multiple rows and columns of data. They support various data types, including text, numbers, dates, and formulas.

Key features of XLS files include:

• Works with older versions of Excel and other spreadsheet software
• Can store formatting information, charts, and macros
• Smaller file size compared to newer formats like XLSX
• Limited to 65,536 rows and 256 columns per sheet

While XLS files are still widely used, they're gradually being replaced by the more modern XLSX format.

NDJSON (Newline Delimited JSON) is a handy format for storing or streaming structured data that you can process one record at a time. Each line in an NDJSON file is a valid JSON object, with a newline character separating them.

This format works great for handling large datasets. You can easily parse and process data line by line without loading the entire file into memory.

Key Features

• Each line is a complete JSON object
• Easy to read and write sequentially
• Great for streaming and logging
• Allows partial processing of large datasets

NDJSON is popular in data pipelines, log processing, and situations where you need to add new data to existing files without changing the whole structure.