Excel to JSON Converter

The converter offers four output formats: Array of Objects (each row becomes an object, ideal for APIs and databases), Column Arrays (columns as separate arrays, great for charting libraries), Key-Value Pairs (explicit key-value structure for configuration files), and Nested Sheets (all sheets in one object, useful for multi-sheet workbooks).

You can configure how empty cells are handled using three options: Set to null (empty cells become JSON null values), Set to empty string (empty cells become blank strings), or Skip (empty cells are omitted from the output entirely). Choose the option that best matches your target system requirements.

The converter supports all common Excel formats including .xlsx (Excel 2007 and later), .xls (Excel 97-2003), and .xlsm (macro-enabled workbooks). Simply drag and drop your file or click to browse, and the tool will automatically detect and parse the format.

Yes, the converter fully supports multi-sheet workbooks. You can select which sheet to convert from a dropdown menu. If you need all sheets in one JSON file, use the Nested Sheets output format, which creates an object with sheet names as keys and their data as values.

Dates can be formatted in two ways: ISO 8601 format (e.g., 2023-01-15T00:00:00.000Z) which is widely compatible with most programming languages and APIs, or Unix timestamp (seconds since January 1, 1970) which is useful for systems that work with epoch time.

You can toggle off the First row contains headers option. When disabled, the converter will generate automatic column names (Column1, Column2, etc.) instead of using the first row as property names. This is useful for spreadsheets that start directly with data.