Free · runs in your browser · no upload · no quota
JSON to Excel Converter
Turn a JSON array of objects into a real Excel workbook. Each object becomes a row, each key a column with a bold header, and numbers stay numbers, so you can sort and sum them straight away.
Good to know
Nested objects become dotted columns.
{"address": {"city": "Novi Sad"}} gives a column named address.city, the same as in the JSON to CSV converter.
Lists of plain values share one cell.
"tags": ["red", "large"] becomes red; large, so each object stays on one row. Lists of objects are written into the cell as JSON text.
The header row is frozen and bold.
The first row stays in view while you scroll. Untick Header row to write the column names as an ordinary row, or to leave them out of an array of arrays.
One sheet per file.
Everything goes into a single sheet called Sheet1. For several sheets, convert each part separately.
How to convert JSON to Excel
- Add your JSON
Paste it into the left box, drop a file onto it, or click Open file and pick a .json file. - Check the table
The right box shows the rows and columns that will go into the sheet. Copying it pastes straight into Excel or Google Sheets as columns. - Download the .xlsx
Click Download to save an Excel workbook that opens in Excel, Google Sheets, Numbers and LibreOffice.
Example
[
{"name": "Ana", "age": 30, "address": {"city": "Novi Sad"}},
{"name": "Marko", "age": 41}
]name age address.city Ana 30 Novi Sad Marko 41
Frequently Asked Questions
-
What JSON can be turned into a spreadsheet?An array of objects gives one row per object. A single object gives one row, and an object holding one array of objects, like
{"items": [...]}, is converted from that array. An array of arrays is written as it is, row by row. -
Are numbers kept as numbers?Yes. JSON numbers become numeric cells and true/false become Excel booleans, so formulas, sorting and sums work. Text that only looks like a number, such as
"007", stays text. -
How big can the JSON be?As big as your browser can hold in memory — tens of thousands of rows are fine. Excel itself stops at 1,048,576 rows per sheet.
-
Is my data uploaded?No. The workbook is built in your browser and nothing is sent to a server.
More browser tools
Working with files rather than text? Our file converters handle CSV to XLSX, XLSX to CSV and 500+ other formats.