JSON to Excel converter.
Paste JSON on the left, preview the table on the right, download a real .xlsx. Free, instant, and private — the workbook is built entirely in your browser, so nothing is uploaded anywhere.
How rows are made: an array of objects becomes one row per object with columns from the keys; nested objects and arrays are written into their cell as JSON text. Strings are written as explicit text cells, so Excel can't mangle IDs or dates.
Related: JSON to YAML converter → · All free tools →
Turn multi-gigabyte JSON into a spreadsheet
An API dump too big for a browser tab still fits in the jsonbolt desktop app — it parses the file at 3 GB/s. Drill to the array you actually need, export it as CSV, and Excel opens it directly.
Open the JSON
Drop a file onto jsonbolt — or copy JSON and press Win + J⌃ ⌥ J to open the clipboard instantly. (Opt-in: Settings → Launch.)
Select the array
Search or drill to the array of records you need — a subtree selection means you export just that branch, not the whole file.
Export as CSV
File → Export Selection Value As → CSV writes a file Excel opens directly. The first object's keys become the column headers.
Free for personal use — no signup. YAML, CSV, and XML export are built in.
How JSON becomes a spreadsheet
| JSON shape | Spreadsheet result |
|---|---|
| Array of objects | One row per object; columns from the keys, in order of first appearance |
| Array of arrays | The grid, exactly as given |
| Single object | A header row and one data row |
| Array of scalars | A single value column |
| Nested objects / arrays | JSON text inside the cell |
null or missing key | An empty cell |
| Numbers and booleans | Native Excel number and boolean cells |
How this converter handles the details
- It writes a real
.xlsx— an Open XML workbook built byte-by-byte in your browser, no plugins, no upload. - Strings are explicit text cells, so Excel's auto-conversion never fires:
"2024-01"stays text instead of becoming a date, and zero-padded IDs keep their zeros. (Spreadsheet users know this bug family well — it's why several human genes were literally renamed.) - Objects with different keys still line up — the column set is the union of all keys, and missing values become empty cells.
- Excel's hard limits apply: 1,048,576 rows and 32,767 characters per cell — longer cell text is truncated at the limit.
- Prefer CSV? The .csv download has the same grid with standard quoting — handy for tools that don't speak xlsx.
FAQ
How do I convert JSON to Excel?
Paste your JSON into the input pane at the top of this page. A table preview appears instantly — then download it as a real .xlsx workbook or a .csv file. The conversion runs locally in your browser; nothing is uploaded.
How do I open a JSON file in Excel directly?
Excel can import JSON through Power Query: Data → Get Data → From File → From JSON, then expand the record columns. It works, but takes several steps per file — for a one-off, converting here and downloading the .xlsx is faster.
How is my JSON turned into rows and columns?
An array of objects becomes one row per object, with columns from the keys in order of first appearance. An array of arrays becomes the grid as-is, a single object becomes one row, and nested objects or arrays are written into their cell as JSON text.
Will Excel mangle my values, like turning IDs into dates?
No. The .xlsx is written with strings as explicit text cells, so Excel never auto-converts them — "2024-01", "SEPT1", and zero-padded IDs stay exactly as they are. Numbers and booleans are written as native Excel types.
Is my JSON uploaded to a server?
No. The converter builds the .xlsx entirely in your browser. Your data never leaves your machine.
How do I get a spreadsheet out of a huge JSON file?
Browser tools hold everything in tab memory, which gets painful past a few hundred megabytes. The jsonbolt desktop app parses at 3 GB/s — open the file, select the array you need, then File → Export Selection Value As → CSV, which Excel opens directly.