Save JSON or JSON Lines as an .xlsx with typed numbers and one sheet per list
Processed in your browser. Nothing is uploaded. Checked against sources on 17 Oct 2026.An .xlsx keeps what a CSV loses: numbers stay numbers, true and false stay booleans, and several tables live in one file. Drop a JSON array, an API response or a JSON Lines log, and each list becomes its own sheet, linked to its parent by row number. IDs longer than 15 digits are kept as text so Excel cannot round them. Nothing is uploaded.
Drop your files or click to choose them.
Adjust the options and check the preview.
Download the result. Nothing was uploaded.
JSON is how APIs, apps and exports hand over data, but it is a tree and a spreadsheet is a grid. This page decides the grid for you, the way a person would.
| In the JSON | In the workbook |
|---|---|
| A list of objects | One sheet, one row per object, one column per key |
| A nested object, "address": {"city": ...} | A column named address.city |
| A list of plain values, ["red", "blue"] | One cell: red, blue |
| A list of objects inside a row, "items": [...] | Its own sheet; each row says which parent row it belongs to |
| An object holding several lists | One sheet per list, other keys on an Info sheet |
Errors point at the line. Invalid JSON is reported with its line and column, such as a trailing comma at line 12, so you can fix it in any editor. JSON Lines, one object per line, is recognised by itself.
The rest of the article, and all 6 questions about JSON to Excel Converter, are on the JSON to Excel Converter page.
Drop the .json file on JSON to Excel Converter, or paste the JSON into the box. A preview shows the sheets and their first rows straight away. Press Download and an .xlsx workbook saves, ready for Excel, Google Sheets or Numbers, with numbers you can sum and filter.
Yes. Choose Nested lists as JSON text, and each nested list stays in its parent's cell as JSON instead of getting its own sheet. Plain lists of values, such as tags, are always one cell with the values separated by commas.
Excel keeps 15 significant digits, so a 19-digit ID such as 1234567890123456789 would be changed to 1234567890123456800 if stored as a number. Integers with 16 or more digits are written as text to keep every digit exactly as in the JSON.
Yes. A file with one JSON object per line (.jsonl or .ndjson) becomes one sheet with a row per line. An API response like {"data": [...], "meta": {...}} gets a sheet for the data list and an Info sheet for the other fields.
Rates and rules change; check the source before you rely on a figure.
Still stuck? Ask about JSON to Excel Converter and anybody who knows can answer. No account needed.
On the related tools: Convert Any File – Photos, documents, spreadsheets, archives: drop it and see what is possible · Markdown File to HTML – Turn a .md file into the HTML behind it.