Best structure
Use an array of similarly shaped objects with consistent keys.
JSON to Excel Converter
Convert a JSON array or object into one XLSX worksheet. See flat and nested JSON examples, null handling, invalid JSON fixes, and output limits.
How to use this tool
- Select one valid JSON file.
- Use a flat array of objects for the clearest table.
- Run the conversion.
- Download the XLSX workbook.
- Review nested values, nulls, arrays, and data types.
A flat array of objects maps naturally to worksheet rows and columns. Object keys become headers. Nested objects and arrays should be flattened first when separate columns are required.
Single object
One top-level object creates one worksheet row.
Nested JSON
Nested objects and arrays are not automatically normalized into linked tables.
Before and after example
Before
- [{"name":"Ana","score":92},{"name":"Luis","score":88}]
After
- Worksheet columns → name, score
- Rows → Ana | 92 and Luis | 88
Troubleshooting
JSON is invalid
Check quotes, commas, brackets, and trailing characters.
Nested values are unclear
Flatten nested keys before conversion.
Only one row appears
The source is one object rather than an array.
Columns vary by row
Standardize object keys before conversion.
Frequently asked questions
What structure works best?
A flat array of objects with consistent keys.
Can it create related sheets?
No. It creates one worksheet.
Are nested arrays flattened?
No.
Can invalid JSON be converted?
No. The source must be valid JSON.
What happens to null values?
They generally become blank cells.
Can one object be converted?
Yes. It creates one row.
Related spreadsheet tools
- CSV to Excel Converter — Convert one CSV table into XLSX.
- Merge CSV Files — Combine multiple table exports.
- Merge Excel Files — Combine spreadsheet workbooks.