JSON to Excel
Turn JSON records into an Excel workbook.
When to use it
Use it to look at data from an API, an export or a log file in Excel, sort it and filter it, without writing code.
How it works
- Choose your files, or drop them onto the box above. You can add several at once.
- Add a .json file holding an array of records. Nested objects become columns such as address.city; check the preview, then convert.
- Press the Convert to Excel button.
- Download the result, or add a next step without downloading.
Supported formats
- Input
- JSON
- Output
- XLSX
- Files
- One or several; each file is processed on its own
Several results can be downloaded one by one or together as a ZIP.
Where your file goes
This tool runs in your browser: the file is processed on your device and is not uploaded. The Network tab of your browser's developer tools shows this.
What is kept, and what is not
Every value keeps its type: numbers stay numbers, true/false stay booleans, text stays text — also text that starts with “=”, which is never turned into a formula. Lists are kept as JSON text unless you choose one column per element.
Limits
- Up to 1,000,000 records and 16,384 columns. Nesting deeper than 20 levels is kept as JSON text in one cell.
- Files up to 512 MB each.
- The work happens in your device's memory, so a phone may fail on a file that a computer handles.
If something goes wrong
The file is reported as invalid JSON
The message names the line and column where reading stopped. A missing comma or quote is the usual reason; JSON Lines files (one object per line) need square brackets around them.
The page becomes slow with a very large file
Close other tabs, or use a computer instead of a phone.
My file is not accepted
Check the formats listed above. A damaged file, or one with the wrong extension, is refused with a message saying why.
Questions
How are nested objects shown?
As columns with dotted names: {"address":{"city":"Baku"}} gives a column address.city. Records without that field leave the cell empty.
My records sit inside a property such as "data"
Type its path in “Where the records are”, for example data or data.items.
Continue with the result
The result can go straight into another tool on this page, without downloading it and uploading it again: