Real Excel files
Creates a genuine .xlsx workbook that opens in Excel, Google Sheets, LibreOffice and Numbers, not a renamed CSV.
JSON to Excel (.xlsx) Converter
Download a real Excel workbook from a JSON array, with a bold, frozen header row.
Input
1
Result
// Output will appear here…
Original (left)
1
Modified (right)
1
Differences
// Diff results will appear here…
About this tool
How the JSON to Excel works
Convert JSON to an Excel .xlsx workbook in your browser. Objects become rows, keys become columns, and each top-level array can become its own sheet.
How to use the JSON to Excel
- Paste a JSON array of objects, or an object containing arrays.
- Choose whether nested objects are flattened into columns.
- Press Download to save the .xlsx workbook.
JSON to Excel example
[{"id":1,"name":"Aarav","city":"Pune"},{"id":2,"name":"Sara","city":"Dublin"}]customers.xlsx — sheet "Sheet1"
| id | name | city |
| 1 | Aarav | Pune |
| 2 | Sara | Dublin |
(bold header row, frozen while scrolling)When to use it
- Sending API data to colleagues who work in Excel.
- Creating reports from exported JSON.
- Opening log or analytics exports in a spreadsheet.
Tip: Name your arrays well: in {"customers": [...], "orders": [...]} the keys become the sheet names.
One sheet per array
A JSON object with several arrays (for example customers and orders) becomes a workbook with one sheet each.
Typed cells
Numbers and booleans are stored as Excel numbers and TRUE/FALSE, so formulas and sorting work immediately.
Readable layout
Bold header row, frozen while you scroll, and column widths sized to the content.
FAQ
Common questions
How are nested objects handled?
By default they are flattened into columns such as address.city. Untick "Flatten nested objects" to keep them as JSON text in one cell.
Is there a row limit?
Excel allows 1,048,576 rows per sheet. The preview shows the first 200 rows; the download contains everything.
Can I paste instead of downloading?
Yes. Copy output gives tab-separated text that pastes straight into Excel or Google Sheets.
Is my data uploaded to make the file?
No. The workbook is built in your browser.
Keep going