Convert XLS to JSONLines

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.

JSON Lines, also known as JSONL, is a convenient format for storing structured data that may be processed one record at a time.

Each line in a JSON Lines file is a valid JSON object, typically representing a single record. The lines are separated by newline characters, making it easy to read and write sequentially.

This format is particularly useful for logging, streaming, and other scenarios where you want to process data line by line without having to parse an entire JSON array.