JSON to Excel

Turn JSON records into an Excel workbook.

When to use it

Use it to look at data from an API, an export or a log file in Excel, sort it and filter it, without writing code.

How it works

  1. Choose your files, or drop them onto the box above. You can add several at once.
  2. Add a .json file holding an array of records. Nested objects become columns such as address.city; check the preview, then convert.
  3. Press the Convert to Excel button.
  4. Download the result, or add a next step without downloading.

Supported formats

Input
JSON
Output
XLSX
Files
One or several; each file is processed on its own

Several results can be downloaded one by one or together as a ZIP.

Where your file goes

This tool runs in your browser: the file is processed on your device and is not uploaded. The Network tab of your browser's developer tools shows this.

What is kept, and what is not

Every value keeps its type: numbers stay numbers, true/false stay booleans, text stays text — also text that starts with “=”, which is never turned into a formula. Lists are kept as JSON text unless you choose one column per element.

Limits

  • Up to 1,000,000 records and 16,384 columns. Nesting deeper than 20 levels is kept as JSON text in one cell.
  • Files up to 512 MB each.
  • The work happens in your device's memory, so a phone may fail on a file that a computer handles.

If something goes wrong

The file is reported as invalid JSON

The message names the line and column where reading stopped. A missing comma or quote is the usual reason; JSON Lines files (one object per line) need square brackets around them.

The page becomes slow with a very large file

Close other tabs, or use a computer instead of a phone.

My file is not accepted

Check the formats listed above. A damaged file, or one with the wrong extension, is refused with a message saying why.

Questions

How are nested objects shown?

As columns with dotted names: {"address":{"city":"Baku"}} gives a column address.city. Records without that field leave the cell empty.

My records sit inside a property such as "data"

Type its path in “Where the records are”, for example data or data.items.

Continue with the result

The result can go straight into another tool on this page, without downloading it and uploading it again:

Related tools