Input
Ready
Lines: 0
Words: 0
Chars: 0
Size: 0 KB
Input statistics are available via the Stats button above this field.
Output
Lines: 0
Words: 0
Chars: 0
Size: 0 KB
Output statistics are available via the Stats button above this field.
Results are provided for informational purposes only and may contain errors. Please verify important information independently. Use of this tool is at your own risk.
What the JSON to Excel (XLSX) Converter does
The JSON to Excel Converter turns a JSON array of objects into a real .xlsx workbook. Each object becomes a row in a sheet named Data, and the keys become the column headers in row 1.
Nested objects are flattened into underscore-joined columns, so stock.warehouse becomes stock_warehouse. Numbers are stored as numeric cells and text as text, so the sheet is ready for formulas, filters and pivot tables.
When to use it
- Handing API results, database exports or log records to someone who works in spreadsheets, not code.
- Building a quick report from an e-commerce, CRM or analytics API without writing a script.
- Reviewing a large JSON array more comfortably in a sortable grid; for a plain-text version use the JSON to CSV Converter.
- Creating a spreadsheet of test data or seed records for a colleague who will edit it before it goes back into the system.
Worked example
Input
[
{"sku": "A-100", "name": "Desk lamp", "price": 24.9, "stock": {"warehouse": 12, "store": 3}},
{"sku": "B-200", "name": "Office chair", "price": 149, "stock": {"warehouse": 4, "store": 0}}
]Output
converted-output.xlsx · sheet "Data"
A B C D E
1 sku name price stock_warehouse stock_store
2 A-100 Desk lamp 24.9 12 3
3 B-200 Office chair 149 4 0Common questions about the JSON to Excel (XLSX) Converter
What if my JSON is a single object, not an array?
A single object becomes one row with its keys as columns. To get one row per item, pass an array, or point the converter at the array inside your response.
How are arrays inside a record handled?
Arrays of simple values are joined into one cell. Arrays of objects are flattened like other nested data, which can create many columns; consider converting that inner array on its own.
Is there a limit on rows?
The input can be up to 5 MB of JSON, which is usually tens of thousands of rows. Excel's own limit is 1,048,576 rows per sheet, far above that.