JSON to Excel

Convert JSON arrays to an Excel sheet.

No upload

Loading tool…

Processing happens on your device using your browser's CPU/GPU. Results are kept only in this tab's memory and are wiped when you click “Clear” or close the page.

About JSON to Excel

JSON to Excel takes an API response or a exported JSON array and lays it out as a spreadsheet that non-developers can actually read. Nested objects are flattened into dotted column names and simple lists are joined into one cell, so you get a single tidy table. Paste the JSON or load a .json file; the conversion happens in your browser and nothing is sent to a server.

How to use JSON to Excel

  1. Paste your JSON into the box, or load a .json file from the drop area above it.
  2. Choose Excel (.xlsx) or CSV as the output format.
  3. Click Convert and check the preview table that appears under the button.
  4. Download the spreadsheet from the results panel.

What people use it for

  • Giving a manager a readable table of API results without writing a script
  • Turning an exported list of orders or users into a sheet for filtering
  • Checking a JSON payload column by column while debugging an integration
  • Handing survey or form-tool JSON to a colleague who only works in Excel

Good to know

Works best on an array of objects. If you paste a wrapper object, the first array property inside it is used. Nested objects become columns like address.city, and lists of simple values are joined with commas; anything deeper is written as JSON text in the cell. Invalid JSON is reported with the position of the error so you can fix it.

Frequently asked questions

My JSON is an object with a data array inside. Will it work?
Yes. The tool looks for the first array property in the object and converts that, which covers most API responses shaped like {status, data: [...]}.
What happens to nested fields?
They are flattened into dotted column headings, so a customer object with a city becomes a customer.city column rather than being dropped.
Do all records need the same fields?
No. Every key seen across the records becomes a column, and rows that lack a key simply get an empty cell there.
Can I get CSV instead of XLSX?
Yes, switch the Output setting to CSV. The CSV is written with a UTF-8 BOM so Excel opens non-English text correctly.