Convert Excel to JSON

1. 1Choose the workbook.
2. 2Pick the sheet to convert if there is more than one.
3. 3Leave “First row is a header” ticked to use the column names as keys. Untick “Pretty-print” for a smaller file.
4. 4Click Convert to JSON and download the file.

A sheet with a header row, converted to an array of objects.

Order  | Date       | Total | Paid
A-1001 | 15/01/2024 | 24.9  | TRUE
A-1002 | 16/01/2024 | 49    | FALSE

[
  { "Order": "A-1001", "Date": "2024-01-15", "Total": 24.9, "Paid": true },
  { "Order": "A-1002", "Date": "2024-01-16", "Total": 49, "Paid": false }
]

01Loading spreadsheet data into an app

Product lists, prices, store locations and translations are often maintained in a spreadsheet by people who don't write code. JSON is what web apps, APIs and document databases load.

02Content and configuration

Let editors update a sheet, then export it to JSON for a website build, a mobile app or a test suite.

03Feeding scripts and APIs

Turn a sheet into a request body or a fixture file without writing a parser for Excel.

• Numbers stay numbers, and TRUE/FALSE become true/false.
• Dates become ISO 8601 strings: 2024-01-15, or 2024-01-15T13:45:00 when the cell has a time. No time zone is added; the value matches what the cell shows.
• Formulas are exported as the value last calculated and saved in the file. They are not recalculated.
• Empty cells become null, so every object has the same keys. Completely empty rows are skipped.
• Header names are trimmed. Empty headers become column1, column2 and so on, and duplicates get a suffix (name, name_2) so no value overwrites another.

.xlsx and .xlsm (Excel 2007 and later), the older .xls format (Excel 97-2003, limited to 65,536 rows and 256 columns per sheet), and .ods from LibreOffice and OpenOffice. Password-protected workbooks cannot be read; save an unprotected copy first.