DOCUMENT & SPREADSHEET FLAGSHIP
JSON To Excel
At a glance
JSON to Excel — Turn a JSON array of objects into a downloadable Excel workbook, flattening nested objects into dot-notation columns.
Free for the core workflow, no account required. Files are processed in the browser for these workflows and are not intentionally uploaded by the tool.
About JSON to Excel
Turn a JSON array of objects into a downloadable Excel workbook, flattening nested objects into dot-notation columns.
An API returns JSON. A manager wants Excel. The distance between those two sentences is the whole job of this tool, and the only hard part is shape: JSON is a tree, and a spreadsheet is a grid, so something has to decide how branches become columns. This tool flattens the tree. Object keys become column headers, nested objects expand with dot notation, and an array of objects becomes rows, which covers the shape most real data already has: a list of records with the same fields. Worked example — two customer records with a nested address. The input is an array of two objects: the first has name Ava Chen, city Lahore, an address object with street 12 Garden Rd and zip 54000, and orders 3; the second has name Marco Ruiz, city Multan, an address object with street 8 Bazaar St and zip 60000, and orders 5. The workbook has one sheet with five columns: name, city, address.street, address.zip, orders. The first row reads Ava Chen, Lahore, 12 Garden Rd, 54000, 3, and the second reads Marco Ruiz, Multan, 8 Bazaar St, 60000, 5. The orders column holds 3 and 5, which sum to 8, and the zip column holds 54000 and 60000, which are kept as numbers because the JSON stored them as numbers. The dot in address.street is the trace of the flattening: it tells you that street lived one level down in the original object. Table — how each JSON shape lands in the workbook: an array of flat objects becomes one sheet with one row per object; an object whose values are arrays becomes one sheet per key, each named after that key; a nested object becomes dot-notation columns such as address.city; an array value inside an object becomes a single cell holding the array as JSON text; a single object becomes a one-row workbook; a value of true or false becomes a TRUE or FALSE cell; a null becomes an empty cell. Before / after — before: a JSON array that only a developer can read, with braces, quotes, and nesting; after: a five-column workbook that anyone can open, filter, and sort, with the same two customers and the same order total of 8. The shape that defeats this tool is the ragged one: objects with wildly different keys, arrays nested three levels deep, or a mix of objects and plain values in the same array. Those inputs still convert, but the result is a sparse grid with many empty cells, which is the spreadsheet telling you the data was never tabular. Normalise first, with a short script or by hand, and the workbook comes out clean. One office step usually leads to the next. The CSV to TSV converts comma-separated CSV data into a tab-separated file for databases, mainframe feeds, and command-line tools that prefer tabs; the TSV to CSV converts tab-separated values into a standard comma-separated CSV file, with quoting handled correctly on the way over. Finally, the CSV Column Extractor pulls one column out of a CSV file by its header name and returns a clean text list of its values. Sources: ECMA-404, The JSON Data Interchange Syntax (2017); MDN Web Docs, Working with JSON (accessed November 2026); Microsoft Support, Excel specifications and limits (accessed November 2026). Content last reviewed: November 2026. The tool flattens your JSON into a proper table: object keys become column headers, nested objects can be expanded with dot notation, and arrays of objects become rows. It handles the 90% case — a clean array of flat objects — perfectly.
Primary objective: Turn a JSON array or named arrays of objects into a downloadable Excel workbook.
Privacy assurance: Files are processed in the browser for these workflows and are not intentionally uploaded by the tool.
How to Use JSON to Excel
- Paste your JSON into the converter or drop the JSON file onto it.
- Check that the top level is an array of objects, or an object whose values are arrays; those two shapes convert cleanly.
- Review the preview columns and confirm nested objects appear as dot-notation headers such as address.city.
- Download the workbook and open it in Excel or Sheets.
- Spot-check one row against the original JSON, then filter or sort a column to confirm the values behave as real data.
Key Use Cases & Applications
- Converting an API response into an Excel file for a non-technical stakeholder.
- Turning analytics exports into a shareable report workbook.
- Preparing a JSON product feed for review by a merchandising team.
- Creating a one-row workbook from a configuration object as a snapshot.
Frequently Asked Questions
My JSON has arrays inside objects — what lands in the cell?
An array value is written into the cell as JSON text, for example "["red","blue"]", so the data is preserved but the cell is text rather than a list. Flatten arrays into separate columns first when you need to filter on their contents.
Why are some columns mostly empty?
Columns come from the union of all keys across every object, so an object that lacks a key leaves an empty cell in that column. A wide, sparse workbook is a sign that the objects have inconsistent shapes and should be normalised first.
Can I control the column order in the workbook?
Columns follow the order keys first appear in the JSON. To get a specific order, reorder the keys in the first object before converting, since the first object sets the column sequence.
What happens to true, false, and null values?
True and false become TRUE and FALSE cells that Excel recognises as booleans, while null becomes an empty cell. If an empty cell and a missing value mean different things in your data, replace nulls with an explicit label before converting.
By Shehzad Hussain — owner and editor of ExpTool, based in Multan, Pakistan. He builds and tests every tool on this site himself.
Last updated: 2026-11-04