Home › Excel tools › JSON to Excel
Runs in your browserConvert JSON to Excel
An API response or an export needs to go to someone who works in Excel. This writes a real workbook rather than a CSV that Excel then mangles, flattens nested objects into dotted columns, and keeps anything that would be damaged by conversion as text.
Your file stays on this computer. There’s no upload button here, because there’s nowhere to send it. This tool runs inside the page you opened — like a calculator on a web page, it keeps working once it has loaded. How this works, and how to check it →
How to use it
- Choose your .json or .ndjson file.
- Decide whether numbers should be written so Excel can add them up.
- Click Convert and download the .xlsx.
Questions
Is my file uploaded anywhere?
No. The whole tool is inside this page, so the work happens on your computer. There is no server to send it to. If you'd rather check than take our word for it: use the tool once, on a sample file, with the settings you want. Then turn off your wi-fi and do exactly the same thing again in that tab, without reloading. It still works, because everything it needs is already here.
How are nested objects handled?
A user object containing a name becomes a user.name column. A list of values is written into its own cell as text, because lists with different numbers of items won't fit into columns. Nothing is dropped.
Why not just convert to CSV and open that?
Because Excel re-interprets a CSV as it opens it, which is how leading zeros vanish and long numbers turn into scientific notation. Writing the workbook directly means the values arrive as intended.
Does it accept newline-delimited JSON?
Yes. If the file isn't valid as a single document, each line is parsed as its own object, which is what most data warehouses and bulk export APIs produce.