Convert JSON to Excel. For the spreadsheet people, no upload
You have JSON from an API or a script, and someone who lives in spreadsheets needs to see it. This tool converts a JSON array of objects into a real Excel .xlsx file in your browser: each object becomes a row, each key a column. If your JSON is instead an object whose values are arrays, each of those becomes its own worksheet. Handy for exporting several related datasets to one workbook. It runs on SheetJS locally, so an API response full of business data is turned into a spreadsheet without being uploaded anywhere. The result opens directly in Excel, Google Sheets, and LibreOffice.
How it works
- Drop a .json file. An array of objects, or an object of arrays for multiple sheets.
- Keys become column headers; each object becomes a row.
- Download the .xlsx workbook.
Frequently asked questions
What JSON shape should I provide?
An array of objects is ideal. The typical shape of an API response, and becomes a single sheet with a column per key. An object whose values are arrays of objects becomes one sheet per key. A single object becomes a one-row sheet.
What happens to nested objects?
A spreadsheet cell is flat, so a nested object or array is written into its cell in a readable form rather than expanded into more columns. For deeply nested data, flatten it before converting if you want each field in its own column.
Is my JSON uploaded to make the Excel file?
No. The workbook is built by SheetJS in your browser, entirely in local memory. JSON that came from an internal API stays as private as it was on your disk.
Will the columns be in a predictable order?
Columns follow the key order of your objects. If different objects have different keys, the header row is the union of all keys, and rows missing a key get an empty cell, so nothing is dropped even with irregular data.