Convert XLSX to NDJSON

XLSX files are Excel files that use the Office Open XML format, which Microsoft introduced with Excel 2007.

Like XLS files, XLSX files can have multiple sheets, and each sheet can contain multiple rows and columns of data. They offer several advantages over the older XLS format.

Key features of XLSX files include:

• Better compression, resulting in smaller file sizes
• Enhanced security features, including password protection and digital signatures
• Better recovery from file corruption
• Support for more rows (1,048,576) and columns (16,384) per sheet
• Works with a wide range of applications and programming languages

XLSX files are based on XML and ZIP technologies, making them easier for third-party software to read and write.

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.