JSON to Excel Converter
JSON to Excel Converter turns a JSON array of objects into a genuine .xlsx workbook. It reads every object, builds the header from the union of all keys, previews the result as a table, and produces a real Excel file in your browser that opens cleanly in Excel, Google Sheets, Numbers and LibreOffice.
Numeric values are written as numbers so Excel can total and chart them, while nested objects and arrays are kept as JSON in the cell so nothing is lost. Everything runs locally — your data is never uploaded.
How to use JSON to Excel Converter
- 1
Paste a JSON array
Provide an array of objects, such as an API response or a database export.
- 2
Check the preview
Each object becomes a row and each key becomes a column, live as you type.
- 3
Download .xlsx
Click Download to save a real Excel workbook containing every record.
How JSON maps to a spreadsheet
Each object in the array becomes one row. The columns are the union of every key found across all objects, in first-seen order, so records with slightly different shapes still produce a single, consistent table. Missing keys are left as empty cells.
Scalar values (strings, numbers, booleans) go straight into cells. Nested objects and arrays are serialised as JSON text in the cell, which keeps the data intact for reference even though spreadsheets are flat by nature.
A real Excel file, built in your browser
Rather than renaming a CSV, this tool assembles a proper Office Open XML (.xlsx) package — the same zipped XML format Excel itself writes — so the file opens without security warnings and numbers stay numeric.
Nothing is sent to a server. The workbook is generated entirely in your browser, which matters when the JSON contains customer, analytics or financial data.
Frequently asked questions
- What JSON shape does it expect?
- A JSON array of objects, for example [{"name":"Ada","age":36}]. A single object is also accepted and becomes one row.
- What happens to nested objects or arrays?
- They are written into the cell as JSON text, so the information is preserved even though the spreadsheet itself is flat.
- Is the output a real Excel file?
- Yes. It is a valid .xlsx workbook that Excel, Google Sheets, Numbers and LibreOffice all open without warnings.
Last updated: