JSON to Excel Converter
Paste JSON or choose a file and download an Excel workbook. The conversion happens in your browser.
- Runs in your browser
- No sign-up
- No watermark
This tool turns JSON into an .xlsx workbook. An array of objects becomes one sheet with a header row, and nested objects are flattened into dotted column names such as address.city. If the top level is an object whose values are all arrays, each key becomes its own sheet. Numbers and true or false values are written as real Excel numbers and booleans, while strings are always kept as text, so dates in ISO format and codes such as 007 are not changed.
Limits: files up to 30 MB, 200,000 rows and 500 columns per sheet, and 20 sheets. Anything beyond that is left out and the tool says so. Cells longer than 32,767 characters are cut, which is an Excel limit. Numbers are read by the browser as standard double precision, so integers beyond 15 digits can lose precision before they reach the sheet. Arrays inside a record can be joined, kept as JSON text or spread over numbered columns. Nothing is uploaded.
How to use JSON to Excel
- Choose a JSON file, or paste the JSON into the box.
- Choose how arrays inside a record should be written.
- Check the preview of the first rows and the sheet list.
- Select Download to save the .xlsx file.
Frequently asked questions
Is my JSON uploaded anywhere?
No. The workbook is built in your browser and never sent to a server.
Which JSON shapes work?
An array of objects (one sheet), an array of arrays (rows as they are), an array of plain values (one column), or an object whose values are all arrays (one sheet per key). Any other object becomes a single row.
Are numbers and dates kept correctly?
JSON numbers become Excel numbers and true or false become Excel booleans. Strings stay as text even if they look like numbers or dates, so ISO dates such as 2026-01-31 are not converted to Excel dates.
How is nested data handled?
Objects inside objects become dotted columns such as company.name. Arrays are joined with a semicolon when they hold simple values, kept as JSON text, or spread over numbered columns, depending on the option you choose.
What are the limits?
Files up to 30 MB, 200,000 rows and 500 columns per sheet, and 20 sheets. Excess data is left out and you are told. Cells longer than 32,767 characters are cut.
Why do records with different keys have blank cells?
The sheet has one column for every key found in any record, in order of first appearance. A record without that key gets an empty cell.
Does it keep formatting, formulas or JSON key order exactly?
No formulas or cell styles are written, apart from a bold, frozen header row if you keep that option on. Columns follow the order keys first appear in your data.