About the JSON to Excel Converter
Handing JSON data to someone who lives in Excel means a spreadsheet, not a CSV that might open wrongly. This converter takes a JSON array of objects, builds the header from the union of keys in first-seen order, flattens nested objects into dotted column names, and writes a genuine .xlsx workbook. Numbers and booleans are stored with their types so the sheet sums and filters correctly; text cells are written as inline strings.
The workbook is generated by JavaScript in your browser, so an API response containing personal data is never transmitted. The right pane confirms the row and column count and lists the columns; click Download to save the file, which opens in Excel, LibreOffice, Numbers and Google Sheets.
A single object becomes one row and an object of objects becomes one row per entry, the same rules as JSON to CSV. For the reverse direction, Excel to JSON reads a workbook back into an array.
How to use
- Paste a JSON array of objects, or upload a .json file.
- Set a sheet name if you like.
- Click Download to save the .xlsx file.
Common questions
- What happens to nested objects?
- They are flattened into dotted column names such as address.city, so every value has a column.
- Are the cells typed?
- Yes. Numbers and booleans keep their types; strings stay text, including strings that look like numbers with leading zeros.
- Can it write several sheets?
- One sheet per conversion. Combine in Excel if you need more.
- Is anything uploaded?
- No. The workbook is built in your browser.