JSON to Excel Converter

Turn a JSON list of objects into an Excel (.xlsx) file, with nested objects flattened into columns and numbers stored as real numbers.

Processed on your device. Files are not uploaded

How to convert JSON to Excel

  1. Paste your JSON

    A list of objects, such as an API response.

  2. Shape the sheet

    Name the sheet and choose whether to flatten nested objects into columns like address.city.

  3. Download the workbook

    Press the download button to get an .xlsx file.

    Numbers are stored as real numbers, and codes with leading zeros stay as text.

Worked example

This is what JSON to Excel Converter gives for its own sample values. Open the tool above and change anything to try your own.

JSON

[
  { "name": "Ann", "city": "Paris", "age": 31 },
  { "name": "Bob", "city": "Rome", "age": 27 }
]
Flatten nested objects into columns
Yes
Sheet name
Data

Result

Rows
2
Columns
3
namecityage
AnnParis31
BobRome27

About JSON to Excel Converter

Turn a JSON list of objects into a spreadsheet, such as the response from an API. Every key becomes a column, nested objects can be flattened into columns like address.city, and numbers are stored as real numbers so they sum and sort. Codes with leading zeros stay as text.

FAQs

What JSON shape works?

A list of objects is best, such as [{"a": 1}, {"a": 2}]. A list of lists and a single object also work.

What happens to nested lists?

They are written into the cell as JSON text.

Can I read the Excel file back?

Yes. Use Excel to JSON Converter.

Related tools