Convert XLS to NDJSON

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

XLS files can contain 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:

• Compatibility with older versions of Excel and other spreadsheet software
• Ability to 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 are gradually being replaced by the more modern XLSX format.

NDJSON (Newline Delimited JSON) is a convenient format for storing or streaming structured data that may be processed one record at a time. Each line in an NDJSON file is a valid JSON object, separated by a newline character.

This format is particularly useful for handling large datasets, as it allows for easy parsing and processing of data line by line without loading the entire file into memory.

Key Features

• Each line is a self-contained JSON object
• Simple to read and write sequentially
• Ideal for streaming and logging applications
• Supports partial processing of large datasets

NDJSON is commonly used in data pipelines, log processing, and scenarios where you need to append new data to existing files without modifying the entire structure.