About the JSON to Excel Converter
JSON is great for programs but hard for people to read in bulk. Excel is the opposite. This converter turns a JSON array, such as the response of an API, into a real .xlsx workbook with one row per object and one column per key. Nested objects are flattened into columns named like address.city, lists of simple values are joined with commas and objects that do not share the same keys get blank cells where a value is missing. Drop a .json file or paste the text, check the preview and download the workbook. The conversion happens in your browser, so the data is never uploaded to a server.
Updated October 2026
How to use the JSON to Excel Converter
- 1Drop your .json file or paste the JSON into the box.
- 2Check the preview and the row and column counts.
- 3Read the message if the JSON is not a list of objects.
- 4Press Download Excel (.xlsx).
- 5Open the file in Excel, Numbers or Google Sheets.
Shaping your JSON first
The cleanest results come from a flat list where every object has the same keys. If your API returns an object with a list inside, such as results or items, the converter finds that list for you. If the data is deeply nested, consider extracting only the part you need with a JSONPath query before converting.
Remember that spreadsheets have limits of about one million rows and 16,000 columns. Objects with thousands of different keys will produce a very wide sheet.
Excel treats the first row as headers, so the tool writes your keys there in the order they first appear. Long text stays in a single cell, and cells that start with an equals sign are still written as plain values rather than formulas. Always glance at the preview before downloading to make sure the columns look the way you expect.
After the download
- Format number and date columns in Excel as needed.
- Freeze the top row and turn on filters.
- Check long text cells for cut-off display.
- Save a copy as CSV if you need to import into another tool.
- Keep the original JSON as the source of truth.
Related tools
The Excel to JSON Converter does the opposite job. For delimited text instead of a workbook try the JSON to CSV Converter, and to view or reshape the data first use the JSON Formatter and the JSON Path Tester. If you want a typed outline for your code, the JSON to TypeScript Converter helps.
Features
- Array of objects to rows and columns
- Nested objects flattened to dotted column names
- Lists joined with commas
- Objects with different keys handled
- Wrapped responses like {"data": [...]} unwrapped
- Preview before you download
- Private, no upload
Frequently asked questions
What JSON can I convert?
A list of objects, a list of lists, or an object that holds one list, like {"data": [...]}. A single object becomes a one-row sheet.
How is nested JSON handled?
Each nested key becomes its own column with the path as its name, for example address.city. Lists of objects are kept as JSON text in one cell.
What if objects have different keys?
The sheet gets a column for every key seen. Objects without a key leave that cell empty.
Why do I get an error?
Common causes are a missing comma, a trailing comma or text that is not JSON. The message shows what the parser found.
Can I open the file in Google Sheets?
Yes. The .xlsx file opens in Excel, LibreOffice, Numbers and Google Sheets.
Are numbers stored as numbers?
Cells hold the values as text from your JSON. Excel usually recognises numbers when it opens the file.
Is there a size limit?
No fixed limit, but very large files can be slow in a browser. For huge data sets use a script or a database export.