JSON to Excel converter
Turn JSON into a real .xlsx workbook as you type. Nothing is uploaded, and the result can be previewed as a table, copied or downloaded.
Loading the converter… It runs locally in your browser.
How to convert JSON to Excel
- Paste your JSON into the input panel, drop a file onto it, or press “Open file”.
- Pick how arrays should be handled. Nested objects are flattened into dot-path columns automatically.
- Check the result: switch the output to “Table” view to see it as a grid.
- Press “Copy” or “Download .xlsx”. The conversion runs on your device, so large files never leave it.
Nested JSON is flattened into dot-path columns before it goes into the sheet, and column widths are sized to the content, so the workbook opens ready to filter.
About JSON
JavaScript Object Notation (RFC 8259): nested objects and arrays with strings, numbers, booleans and null. The default payload format of web APIs.
About Excel
Microsoft Excel workbooks (.xlsx, and legacy .xls). TableForge also reads OpenDocument .ods and data copied straight out of a spreadsheet.
How a JSON tree becomes table columns
A table is flat: every row has the same columns. JSON is a tree. To fit one into the other, each leaf value gets a column named after its path from the top of the record, joined with dots. Toggle the options and watch the header change.
{
"id": 7,
"name": "Mae Jemison",
"address": {
"city": "Houston",
"geo": {
"lat": 29.76
}
},
"missions": [
"STS-47",
"Endeavour"
]
}| Column | Value |
|---|---|
| id | 7 |
| name | Mae Jemison |
| address.city | Houston |
| address.geo.lat | 29.76 |
| missions.0 | STS-47 |
| missions.1 | Endeavour |
“Column per item” keeps every value searchable but widens the table when arrays are long. “Joined text” keeps one column and suits tags. “JSON text” is lossless, so you can parse it back later.
Questions people ask
Is my JSON data uploaded anywhere?
No. The JSON to Excel conversion runs entirely in your browser with JavaScript. The page works offline once it has loaded, and TableForge never receives your data.
How large a file can I convert?
The limit is your device's memory. Files of tens of megabytes (hundreds of thousands of rows) convert fine on a typical laptop. The preview shows the first 200 rows, but the download always contains every row.
How are nested JSON objects converted into columns?
Each value gets a column named after its path, joined with dots, for example address.city. Arrays can become one column per item (tags.0, tags.1), a single joined column (a; b), or JSON text. Records that lack a key simply leave that cell empty.
Can I convert Excel back to JSON?
Yes, use the Excel to JSON converter at tableforge.io/excel-to-json, or the universal converter on the home page.
Will Excel strip my leading zeros?
Not in this file. Only plain numbers without leading zeros are stored as numeric cells. Everything else (ZIP codes, phone numbers, IDs like 00123) is written as text, so Excel shows it exactly as it was.