Runs locally in your browser
JSON to Excel Converter
Create an XLSX workbook from JSON records, with a named worksheet and numeric or boolean cells. Preview your table before downloading.
Need delimited text for a data import? Export JSON to CSV.
2 rows · 3 columns. Preview shows the first 20 rows; download includes all rows.
| id | name | active |
|---|---|---|
| 1 | Alice | true |
| 2 | Bob | false |
How to convert JSON to Excel
- Paste JSON or import a .json file.
- Review the column names and table preview.
- Choose a worksheet name and download your .xlsx spreadsheet.
For example, [{"name":"Alice","active":true}] becomes a spreadsheet with name and active columns. Nested values remain JSON strings; this conversion does not flatten or reconstruct nested objects.
Export an inventory report as an XLSX workbook
Use this converter when you want to open API records as a workbook and review them in Excel. For example, export inventory with product codes as text, stock counts as numbers, and availability as booleans.
[
{"sku":"00124","stock":18,"available":true},
{"sku":"00125","stock":0,"available":false}
]Name the worksheet Inventory or keep the default Sheet1. The exported header row is bold and frozen. The sku values remain text, including their leading zeros; stock and available use numeric and boolean cell types.
When to choose XLSX instead of CSV
Choose XLSX for a workbook with a named sheet and typed cells. This tool exports one worksheet per file. Choose JSON to CSV when another application expects delimited text or you need to copy the output directly.
Nested objects are stored as JSON text in one cell. JSON date strings remain text; the exporter does not infer Excel dates from them. To read an existing workbook, use Excel to JSON.
Frequently asked questions
Which JSON structures are supported?
Paste one object or an array of objects. All top-level keys become columns, including keys that only occur in later rows. Missing values and null become blank cells.
What happens to nested data and formulas?
Nested objects and arrays become JSON text in a cell. Strings beginning with = remain text and are not converted into formulas. Numbers and booleans retain their types. Store long numeric identifiers as strings to avoid numeric precision loss.
What are the limits?
Up to 10,000 rows, 200 columns and 32,767 characters per cell. Imported JSON files must be smaller than 10 MB. Export uses the modern XLSX format.
Is my JSON uploaded?
No. Parsing and workbook creation run locally in your browser.