How to convert JSON to Excel
- Choose a .json or .jsonl file (you can add several).
- Keep Output format on XLSX and Flatten nested JSON ticked (preselected here).
- Select Convert.
- Download the workbook, or all files as a ZIP.
Worked example
orders.json holding [{"name":"Ann","zip":"02134","qty":3,"address":{"city":"Oslo"},"tags":["a","b"]}] becomes orders.xlsx with the columns name, zip, qty, address.city, tags.0 and tags.1. qty is the number 3 and zip stays the text 02134.
Formats and limits
| Input | JSON, JSON Lines |
|---|---|
| Output | XLSX |
| Limits | Up to 100 MB. |
| Engine | SheetJS Community Edition + Papa Parse; dot-path flattening for nested JSON |
Limitations
- Objects with very different keys give many sparse columns, in order of first appearance.
- Everything goes on one sheet named Sheet1; JSON cannot be split across sheets here.
- Invalid JSON stops the conversion with an error.
- Up to 100 MB per file.
Questions
Which JSON shapes work?
An array of objects, JSON Lines with one object per line, an array of arrays whose first row is the header, or an object with one array of objects inside, such as {"data": [...]}, whose array is used.
What happens to nested objects and arrays?
They become columns named by their path: an address object with a city gives address.city, and a tags array gives tags.0 and tags.1. Untick Flatten nested JSON to keep them as JSON text in one cell.
Are numbers real numbers in Excel?
Plain numbers such as 3 or -1.5 become numeric cells. Values such as 02134 stay text so the zero is kept, and true and false are written as text. Tick Keep every value as text to write all cells as text.
Is my file uploaded?
No. The file is read and converted in your browser; nothing is uploaded.
Privacy
Runs on your device. Files and text are processed in this browser tab and are not uploaded.
This page opens the CSV, Excel and JSON converter ready for this task. See the privacy policy for how toolsdocks handles data.