DataMimiDataMimi

Convert JSON to Excel

Any JSON as a spreadsheet: the rows found wherever they sit, nested fields as their own columns.

Want it to work exactly your way?

Keep this tool in your Mini-Apps to run it again in one click, or describe the job and AI builds an app of your own.

✦ Make your own app

How to use Convert JSON to Excel

  1. 1Select your file, or drop it on the page
  2. 2Run it — nothing to set up
  3. 3Download converted.xlsx

Your file is opened in an isolated sandbox with no internet access, processed and deleted with it. It is read the way people's spreadsheets really are — headers that are not on row 1, merged cells, totals pasted at the bottom, dates in two formats — and everything that is changed is listed back to you.

Questions

How do I convert JSON to Excel?

Upload the .json file and download the .xlsx. Each object becomes a row and each key a column.

What about nested JSON?

Nested objects become dotted columns such as customer.name and customer.city. A list inside a field is kept as JSON text in its cell, so nothing is lost.

My rows are inside a key like "data" or "results" — does that work?

Yes. The converter looks for the largest list of records anywhere in the file, so API responses work as they are.

Does it read JSON Lines?

Yes. A file with one JSON object per line is read the same way.

More Excel tools

See all