JSON to XLSX converter
To convert JSON to XLSX, drop your JSON file in the box below. It converts straight away; press Download to save the XLSX. It all happens in your browser, so your file stays on your device.
Convert to
Converted on this device, never uploaded
What changes
| JSON to XLSX | What happens |
|---|---|
| Shape | An array of objects (or one object, or an array of arrays) |
| Nested objects | Flattened into dotted columns, like address.city |
| Values | Numbers and true/false stay values; strings stay text, ISO dates become dates |
| Header | The column names in bold, frozen at the top |
| Arrays inside a record | Kept as JSON text in one cell |
How to convert JSON to XLSX
- Add your JSON. Drop the file in the box, or click to choose it. It becomes XLSX straight away.
- Check the result. Look at the preview. The delimiter and value types are set for you; change them if needed.
- Download. Press Download to save the XLSX.
Why XLSX
Open JSON data in Excel as a proper workbook: each object becomes a row and each key a column.
Questions
They become dotted columns: {"address": {"city": "Lisbon"}} gives a column address.city.
No. A JSON string stays text in the workbook, so every zero is kept.
Yes. A file with one JSON object per line is read as a list.
No. The conversion happens right in your browser, so your file stays on your device. There is no account to make, either.