Convert Excel to JSON
A spreadsheet as an array of JSON objects keyed by its header, or as JSON Lines.
Want it to work exactly your way?
Keep this tool in your Mini-Apps to run it again in one click, or describe the job and AI builds an app of your own.
How to use Convert Excel to JSON
- 1Select your file, or drop it on the page
- 2Choose how, then run it
- 3Download converted.json
Your file is opened in an isolated sandbox with no internet access, processed and deleted with it. It is read the way people's spreadsheets really are — headers that are not on row 1, merged cells, totals pasted at the bottom, dates in two formats — and everything that is changed is listed back to you.
Questions
How do I convert Excel to JSON?
Upload the .xlsx and download the .json: one object per row, keyed by the header row.
What if the header is not on row 1?
The header is found even below a title or a logo, and totals rows are left out, the same as in every DataMimi tool.
How are dates and empty cells written?
Dates as ISO dates (2024-03-01), numbers as numbers, and empty cells as null.
My workbook has several sheets — which one is used?
The largest table. The summary says which sheet it came from.