About this tool
JSON to Excel writes an object array into a real XLSX workbook rather than merely changing an extension. Each array item becomes a row. Nested object paths and array indexes are flattened into column names joined with `>`, then written to a worksheet named Sheet1.
The preview shows at most 20 rows while export processes the complete array. Columns are collected across all records and missing fields remain blank. Empty objects and arrays are kept as JSON text so their presence is not silently lost.
How to use it
Prepare a non-empty array
The root should be an array of objects. Wrap a single object in an array; JSONC and JSON5 syntax are also accepted.
Review the flattened preview
Check path columns such as customer>address>city and look for unexpected columns introduced by inconsistent records.
Generate and download XLSX
Export all records to Sheet1, then verify dates, long integers, and line breaks in the destination spreadsheet.
Supported range and limits
- Output
- An XLSX workbook with a single sheet
- Input requirement
- An array of objects at the top level, one element per row
- vs CSV
- XLSX keeps cell types, avoids encoding problems with non-Latin text, and has no delimiter-escaping pitfalls
- Nested fields
- Flattened into column names; for deep nesting, run JSON Flatten first
- Number precision
- Very long integers can display in scientific notation or lose trailing digits in Excel; export order numbers as text
- Formulas
- None are generated; every cell is a static value
When you would use it
Delivering operational data
Turn an API list of orders or users into a sortable workbook for people who work in spreadsheets.
Retaining nested paths
Unlike a simple CSV export, path columns retain where nested values came from and can be reconstructed by Excel to JSON.
Producing a report attachment you can send as-is
XLSX keeps cell types and has no encoding pitfalls, which makes it a better email attachment for business users than CSV.
What to know before you start
- Excel may infer dates and scientific notation. Order IDs, phone numbers, and long integers often need text column formatting.
- Arrays are expanded by index. Widely varying lengths create many sparse columns and are not a substitute for relational tables.
- Export creates one worksheet named Sheet1 and does not split object fields into separate sheets.
Related concepts
- XLSX
- The Office Open XML workbook format, capable of storing cell types, multiple sheets, and styles.
- path column
- A flattened column name that encodes nesting with a delimiter, such as profile>skills>0.