JSON to Excel
Convert JSON to an Excel .xlsx file. Use a top-level array or pick a nested array, flatten objects into columns, expand arrays into rows, and keep big integer IDs exact.
Loading JSON to Excel…
About the JSON to Excel
JSON to Excel turns JSON records into a worksheet. Paste JSON or open a .json file, then choose the array to convert: the top-level array, or any array nested inside an object such as data.items.
Nested objects can be flattened into columns like address.city or kept as JSON text. Nested arrays can stay as JSON text or one array can be expanded into one row per element. Records with different shapes are combined into one set of columns, missing keys stay blank, and very large integers are written as text so no digits are lost.
How to use
- Paste JSON or open a .json file.
- Choose the array of records to convert.
- Choose how nested objects and arrays are handled.
- Review the preview, columns and any key collisions.
- Enter a worksheet name and click Download XLSX.
Key features
- Top-level or nested arrays of objects, rows or values.
- Flatten objects with dot paths or keep them as JSON text.
- Keep arrays as JSON text or expand one array into rows.
- Union of keys across records; missing keys left blank.
- Lossless parsing: big integer IDs are kept digit for digit.
- Key collisions reported and renamed, never overwritten.
Best practices
- Pick the innermost array that holds one record per row.
- Expand only one nested array at a time to avoid row explosions.
- Keep IDs as text in downstream tools too.
Benefits
- Readable spreadsheets from API responses.
- No silent precision loss for 64-bit IDs.
- Private: JSON never leaves your device.
Frequently asked questions
What happens to 19-digit IDs?
They are parsed without rounding and written as text cells, because Excel numbers only hold 15 significant digits.
What is a key collision?
When flattening produces a column name that already exists — for example a nested a → b and a literal key “a.b”. The second column is renamed (a.b (2)) and both values are kept.
Can JSON text create formulas in the workbook?
No. Strings such as =1+1 are written as literal text.
Is my data uploaded?
No. Files and pasted data are processed only in your browser. Nothing is uploaded or stored, and the tool keeps working offline once the page has loaded.