Convert JSON to Excel
Save a JSON list of objects as an Excel spreadsheet. Each key becomes a column, each object a row.
The tool could not be loaded. It needs JavaScript: please enable it or reload the page.
or drag them here
CSV, TXT, Excel (XLSX, XLS), OpenDocument (ODS) or JSON.
Values like 12.50 become numbers. Leading zeros (postcodes, IDs) stay text.
So that Excel displays special characters correctly.
Preview
No image chosen yet.
Frequently asked questions
Why does Excel show umlauts incorrectly?
Excel often reads CSV files without a marker in the wrong character set. Leave “Mark for Excel” switched on, then Excel recognises UTF-8 and shows ä, ö and ü correctly.
Are postcodes and numbers with leading zeros kept?
Yes. Values with a leading zero like 0041 or 00123 stay text. Only unambiguous numbers like 12.50 are taken as numbers, and this can be switched off.
More tools in this category
- Split a spreadsheet Split large CSV or Excel files.
- XML ↔ JSON Convert XML to JSON and back.
- Compare tables Compare two Excel or CSV files.
- Remove duplicates Delete duplicate rows in Excel or CSV.
- Average & median Mean, median, standard deviation, quartiles.
- YAML ↔ JSON Convert YAML to JSON and back.