Excel to JSON

Excel is where much business data lives, and JSON is what code reads. This converter opens an .xlsx workbook in your browser and turns the sheet you pick into a JSON array, with no upload and no add-in.

The first row of the sheet is used as the header, and each row below it becomes an object with those names as keys. Empty or repeated header names are renamed so every key is unique. Numbers and booleans keep their types, while text stays text. Formula cells give the last result Excel saved, rich text becomes plain text, hyperlinks keep their display text and error cells keep codes such as #N/A. Dates become ISO 8601 strings, for example 2024-01-05 for a date and 2024-01-05T13:30:00 when there's a time, because JSON has no date type. Empty cells become empty strings and fully blank rows are skipped.

Turn the header option off to get each row as an array instead, which suits sheets without a header row. Old Excel 97-2003 .xls files and password-protected workbooks can't be read in the browser; re-save them as unprotected .xlsx files first.