JSON to Excel Converter
Turn JSON into a clean Excel spreadsheet (.xlsx) with a header row, filters and one sheet per list.
How to convert JSON to Excel
- Paste JSON, or upload a .json file.
- Press Convert to Excel.
- Check the preview and download the .xlsx file.
- A list of objects becomes rows, with the keys as column headers.
{"users": [...], "orders": [...]}becomes one sheet per list.- Numbers and true/false stay real values, so Excel can sum and filter them.
- Going the other way? Use Excel to JSON.
JSON to Excel: frequently asked questions
How do I convert JSON to Excel?
Paste your JSON or upload a .json file and press Convert to Excel. Check the preview and download the .xlsx file, which opens in Excel, Google Sheets and LibreOffice.
What JSON shapes work?
A list of objects becomes rows with the keys as columns. An object of lists, like {"users": [...], "orders": [...]}, becomes one sheet per list. A single object becomes one row, and a list of lists is copied as a grid.
What happens to nested objects?
With flattening on, {"address": {"city": "Pune"}} becomes a column called address.city. Lists of simple values are joined with commas, and anything more complex is kept as JSON text in the cell.
Are numbers kept as numbers?
Yes. Numbers and true/false values are written as real Excel values, so you can sum, sort and filter them straight away.