Convert XLSX to NDJSON

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

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

• Improved 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
• Compatibility with a wide range of applications and programming languages

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

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.