Skip to content
Devtoolry
Sign InJoin for Free

JSON to Excel

Convert JSON to a real Excel .xlsx file online: nested objects become columns, each array can become its own sheet and the header row is frozen. No upload.

Runs in your browser · Nothing uploaded · No sign-up

Something not working, or missing a feature? Send feedback

About the JSON to Excel

The JSON to Excel Converter turns a JSON array into a real .xlsx workbook, not a CSV, so numbers stay numbers and the header row is bold, frozen and filterable. Nested objects become columns such as address.city, and an object of arrays becomes one sheet per array. The file is built in your browser and never uploaded.

Conversion happens in your browser, so your files and records stay private.

How to use the JSON to Excel

  1. Paste JSON or open a .json file: an array of objects, or an object whose values are arrays.
  2. Keep "Flatten nested objects" on to turn nested fields into columns.
  3. Check the preview of each sheet.
  4. Name the file and download the .xlsx.

Excel limits the converter checks

LimitValue
Rows per sheet1,048,576
Columns per sheet16,384 (A to XFD)
Characters per cell32,767
Number precision15 digits
Sheet name length31 characters, without [ ] : * ? / \

Sources: Microsoft: Excel specifications and limits

Common mistakes

  • Objects with different keys. Columns are the union of all keys, in order of first appearance. Rows without a key get an empty cell instead of shifting the other values.
  • Very long text. An Excel cell holds at most 32,767 characters. The converter names the row and column that are too long instead of writing a broken file.

Works well with the JSON to Excel

Frequently asked questions

How is nested JSON converted?

Nested objects become dotted column names: {"address": {"city": "London"}} gives a column address.city. Arrays inside a row are written as JSON text in one cell, so no data is lost.

Can I get several sheets?

Yes. An object such as {"customers": [...], "orders": [...]} becomes a workbook with a customers sheet and an orders sheet.

Why are some numbers written as text?

Excel keeps only 15 significant digits. Long IDs such as 9007199254740993 would be rounded, so they are stored as text to keep every digit.

Does it work with Google Sheets and LibreOffice?

Yes. The file is a standard Office Open XML workbook, which Excel, Google Sheets, LibreOffice Calc and Numbers all open.

Related tools