JSON to Excel Converter
Turn a JSON list of objects into an Excel (.xlsx) file, with nested objects flattened into columns and numbers stored as real numbers.
How to convert JSON to Excel
Paste your JSON
A list of objects, such as an API response.
Shape the sheet
Name the sheet and choose whether to flatten nested objects into columns like address.city.
Download the workbook
Press the download button to get an .xlsx file.
Numbers are stored as real numbers, and codes with leading zeros stay as text.
Worked example
This is what JSON to Excel Converter gives for its own sample values. Open the tool above and change anything to try your own.
JSON
[
{ "name": "Ann", "city": "Paris", "age": 31 },
{ "name": "Bob", "city": "Rome", "age": 27 }
]- Flatten nested objects into columns
- Yes
- Sheet name
- Data
Result
- Rows
- 2
- Columns
- 3
| name | city | age |
|---|---|---|
| Ann | Paris | 31 |
| Bob | Rome | 27 |
About JSON to Excel Converter
Turn a JSON list of objects into a spreadsheet, such as the response from an API. Every key becomes a column, nested objects can be flattened into columns like address.city, and numbers are stored as real numbers so they sum and sort. Codes with leading zeros stay as text.
FAQs
What JSON shape works?
A list of objects is best, such as [{"a": 1}, {"a": 2}]. A list of lists and a single object also work.
What happens to nested lists?
They are written into the cell as JSON text.
Can I read the Excel file back?
Yes. Use Excel to JSON Converter.