How to use the JSON to Excel converter
- Drop a .json file or paste JSON.
- Click Convert.
- Open the downloaded .xlsx in Excel or Google Sheets.
What to know
- An array of objects becomes one row per object.
- Nested objects become dotted column names such as supplier.country.
- Arrays inside a record are kept as JSON text in one cell.
Questions
My JSON comes from an API. Will it work?
Usually yes. If the response is an object with a list inside, such as {"results": [...]}, the list is found and converted.