Convert JSON to Excel

About Convert JSON to Excel

JSON is how APIs and scripts naturally return data, but a colleague, a client, or a report reviewer usually wants to see that data in a spreadsheet, not a raw JSON file they don't know how to open. Converting an API response or exported JSON array into Excel is a common last-mile step that's tedious to do manually for anything beyond a handful of rows.

This tool takes a JSON array of objects — the standard shape most APIs return, and what most database and script exports naturally produce — and converts it directly into a downloadable .xlsx workbook. Each object in the array becomes one row, and the union of all object keys becomes the column headers.

This expects a JSON array of flat objects, not deeply nested structures — a nested object or array as a field's value won't automatically flatten into separate columns. For that kind of data, flatten the structure into simple key-value pairs per row before converting, since Excel's grid format doesn't natively represent nested data.

How it works

1. Paste your JSON array. Paste an array of objects, e.g. from an API response.
2. Download as .xlsx. Click the download button to get a ready-to-open Excel file.
3. Open and review. Each object becomes a row, with object keys as column headers.