Skip to content
toolsdocks

Convert JSON to Excel

Turn an API response or an export into a spreadsheet. This page opens the converter with XLSX output and nested JSON flattened; each object in the array becomes a row and each key a column.

Runs on your device

More options in the full CSV, Excel and JSON converter.

Loading tool…

How to convert JSON to Excel

  1. Choose a .json or .jsonl file (you can add several).
  2. Keep Output format on XLSX and Flatten nested JSON ticked (preselected here).
  3. Select Convert.
  4. Download the workbook, or all files as a ZIP.

Worked example

orders.json holding [{"name":"Ann","zip":"02134","qty":3,"address":{"city":"Oslo"},"tags":["a","b"]}] becomes orders.xlsx with the columns name, zip, qty, address.city, tags.0 and tags.1. qty is the number 3 and zip stays the text 02134.

Formats and limits

InputJSON, JSON Lines
OutputXLSX
LimitsUp to 100 MB.
EngineSheetJS Community Edition + Papa Parse; dot-path flattening for nested JSON

Limitations

  • Objects with very different keys give many sparse columns, in order of first appearance.
  • Everything goes on one sheet named Sheet1; JSON cannot be split across sheets here.
  • Invalid JSON stops the conversion with an error.
  • Up to 100 MB per file.

Questions

Which JSON shapes work?

An array of objects, JSON Lines with one object per line, an array of arrays whose first row is the header, or an object with one array of objects inside, such as {"data": [...]}, whose array is used.

What happens to nested objects and arrays?

They become columns named by their path: an address object with a city gives address.city, and a tags array gives tags.0 and tags.1. Untick Flatten nested JSON to keep them as JSON text in one cell.

Are numbers real numbers in Excel?

Plain numbers such as 3 or -1.5 become numeric cells. Values such as 02134 stay text so the zero is kept, and true and false are written as text. Tick Keep every value as text to write all cells as text.

Is my file uploaded?

No. The file is read and converted in your browser; nothing is uploaded.

Privacy

Runs on your device. Files and text are processed in this browser tab and are not uploaded.

This page opens the CSV, Excel and JSON converter ready for this task. See the privacy policy for how toolsdocks handles data.