How to convert JSON to Excel
- Add your .json file.
- Start the conversion — columns are detected automatically.
- Download your Excel .xlsx workbook.
JSON is the language of APIs and web apps: online shop exports, payment provider responses, form submissions, database backups. Developers love it, but it is unreadable for an accountant or sales manager who just wants to sort, filter or add up a column.
The tool reads a list of objects such as [{"customer": "Acme Inc.", "city": "Denver", "amount": 1200}, …] and builds a table: the first row holds the field names, then one row per object. If some objects have extra fields, a column is added for them. A file shaped like {"Customers": […], "Orders": […]} becomes a workbook with one sheet per list, and a list of lists is written row by row as it is.
The file must be valid JSON; if it is not, the error message tells you what is wrong. You can convert up to 50 files at once. Data is processed in memory and deleted after 30 minutes.
Frequently asked questions
Which JSON structure is supported?
A list of objects [ {…}, {…} ], an object whose values are all lists ({"Sheet1": […], "Sheet2": […]}) for several sheets, or a single object, which gives one row.
How are the columns made?
Every key found in the objects becomes a column, in order of appearance. A missing value just leaves the cell empty.
My file has several lists — what happens?
If the JSON is an object like {"Customers": […], "Sales": […]}, each list becomes its own sheet in the Excel workbook.
Can I go the other way, Excel to JSON?
Yes, the same tool also turns an Excel or CSV file into JSON — use the Excel to JSON page.
Is it free and private?
Yes, it is free, needs no account, and your files are deleted automatically after 30 minutes.