Convert Excel (XLSX) to JSON

How to convert Excel to JSON

Drop a workbook above. SheetJS reads it in your browser and lists the worksheets with their size. Pick a sheet, check the preview of its first rows and press Download to save it as a JSON file. For a workbook with several sheets, All sheets in one JSON writes a single file with one key per sheet name.

How rows become JSON

The first row of the sheet is the header. Every row below it becomes an object whose keys are the header cells, so a sheet with Name and Email columns gives [{"Name": "Ana", "Email": "ana@example.com"}, ...]. Numbers stay numbers and TRUE and FALSE become booleans. Empty cells become null, so every object has the same keys. Formula cells hold their calculated value, and dates are written as ISO 8601 date-time strings.

Tidy the sheet first

JSON keys come straight from the header row, so give every column a short, unique heading. Columns without a heading get generated names such as __EMPTY, and repeated headings get a numbered suffix. Remove title rows, notes and totals above or below the table, since they would become extra objects.

Uses for Excel to JSON

Load product lists, translations or test data into an app, seed a database, mock an API response, or feed a spreadsheet maintained by a non-developer into a build step. JSON is also easier to diff and review in version control than a binary workbook.

Before you start

Input: XLSX, XLS, XLSM, XLSB, and ODS. Output: JSON. The settings appear before anything runs, so you can check them first. Your original file is never changed.

A valid file can still hold the wrong data. Before you import the result, check the row count, field names, text encoding, dates, IDs and a few unusual rows.

Keep the original until you have opened and checked the result. The work happens in this browser tab, so the size you can handle depends on your device's memory, your browser and the file itself.

How to convert Excel (XLSX) to JSON

1. Drop an .xlsx, .xls or .ods file into the box above.
2. Pick a worksheet and check the preview.
3. Download that sheet as JSON, or every sheet in one JSON file.