How to use the json to excel converter
- Paste JSON or open a .json file.
- Check the preview.
- Select Download .xlsx.
How JSON becomes columns
- Each object in the array becomes a row.
- Nested objects become columns with dotted names, such as
address.city. - Lists of simple values are joined with commas.
- An object whose values are arrays, like
{"users": [...], "orders": [...]}, becomes one sheet per array.
Examples
Columns a and b.c
Two sheets