JSON to Excel
Flatten any JSON payload into a readable spreadsheet.
Paste an API response or upload a .json file and get a worksheet with one row per record. Nested objects are flattened into dotted columns and arrays are either expanded into rows or joined into a single cell — your choice.
- Rating
- 4.8(2.0K)
- Monthly uses
- 288K
- Price
- Free
or drag it here
.json, .jsonl, .ndjson · processed locally, never uploaded
Files stay on your device
What it does well
- Handles JSON, JSON Lines and NDJSON in the same drop zone
- Deep flattening with configurable depth and separator
- Union of all keys across records, so sparse fields still get a column
How to use JSON to Excel
- 1
Paste your JSON into the editor or upload a file.
- 2
Point at the array to convert if your payload wraps it in a data or results key.
- 3
Decide how nested objects and arrays should be flattened.
- 4
Download the generated .xlsx.
Watch a walkthrough
Common problems and fixes
Unexpected token error when pasting.
The payload is JavaScript rather than strict JSON — usually trailing commas or unquoted keys. Enable “Lenient parse” to accept both.
Only one row is produced from a large file.
The file is JSON Lines but was parsed as a single JSON document. Choose the JSONL mode in the source dropdown.
Frequently asked questions
What people say
Exactly what I needed. JSON to Excel used to be a twenty-minute job with a macro I did not trust; now it takes one drag and one click.
Small thing, but the error messages actually tell you what to fix. JSON to Excel flagged a hidden character that had been breaking my lookups for weeks.
Our IT team blocked every other online tool because they upload files. This one does not, so json to excel finally got approved for use on real data.
More convert tools
Move data between XLSX, CSV, JSON, XML, HTML and PDF without losing formatting, encoding or number precision. Every conversion runs locally in your browser.
Browse Convert