Excel to JSON
Turn a sheet of an XLSX, XLS or ODS workbook into JSON. By default the first row becomes the keys and every following row becomes an object, or you can export plain arrays of rows. Export one sheet or every sheet into one JSON object keyed by sheet name.
Frequently asked questions
How are the keys chosen?
In the objects format, the cells of the first row become the keys. Empty header cells become column1, column2 and so on by position, and repeated headers get a suffix such as name_2 so no value is lost.
Which value types appear in the JSON?
Numbers stay numbers, booleans become true or false, dates become ISO strings such as 2025-03-14, error cells become their error text such as #DIV/0! and empty cells become null. With displayed values turned on, every cell becomes the text Excel shows instead.
Can I convert all sheets at once?
Yes. Tick the option for all sheets and the JSON file holds one object whose keys are the sheet names and whose values are the rows of each sheet.
What does the arrays format look like?
Each row becomes an array of cell values, and the first row is kept as an ordinary row. This is useful when the sheet has no header row or when column order matters more than names.
Are formulas included?
No. Each formula cell is exported as its last calculated value, the value stored in the file when it was last saved.
What are the limits?
Files up to 10 MB with at most 25 MB of uncompressed content, up to 100 sheets, 50,000 rows per sheet and 1,000,000 cells in total.