Free JSON to Excel Converter
Turn JSON data into a real Excel workbook you can open, sort and share. Paste your JSON, download a genuine .xlsx file with one worksheet, headers and rows, free, with nothing uploaded anywhere.
The .xlsx file is a real Excel workbook built in your browser — one worksheet named Data. Your input never leaves this device.
What this tool does
This tool converts JSON data into a genuine Microsoft Excel workbook file with the .xlsx extension, not a text file with a changed name. The downloaded file opens in Excel, with your data arranged as a worksheet of rows and columns.
Each object in a JSON array becomes one row, and the object keys become the column headers in the first row. A single JSON object becomes a single row under the same headers. The worksheet is plain: one sheet, values in cells, no charts and no extra sheets, so the result is easy to sort, filter, print and share.
The conversion runs entirely in your browser: nothing is uploaded, there is no sign-up, and your input never leaves your device.
How to use the JSON to Excel converter
Converting JSON to Excel takes a few simple steps. You do not need to install anything to create the file.
- Paste your JSON into the input area. An array of objects works best, because each object becomes one row in the worksheet.
- Check that the JSON is valid. If there is a mistake, the tool reports the problem so you can fix the input before converting.
- Start the conversion and download the .xlsx file to your device when it is ready.
- Open the downloaded file in Excel or any other spreadsheet program that opens .xlsx files.
- Sort or filter the data in your spreadsheet program as you wish.
Keep the outer square brackets of an array: they mark the data as a list of rows.
Worked example
Suppose you have a small list of two places, each with a nested address and a list of tags. The JSON below is the input.
[
{
"name": "Café Luna", "city": "Lisbon", "rating": 4.7, "open": true, "website": null,
"address": {"street": "Rua Nova 12", "postcode": "1100-123"}, "tags": ["café", "bakery"]
},
{
"name": "Café Mar", "city": "Porto", "rating": 4.2, "open": false, "website": null,
"address": {"street": "Rua das Flores 8", "postcode": "4050-262"}, "tags": ["dinner"]
}
]The downloaded workbook contains one worksheet. The nested address is flattened into separate columns, and the tags array appears as JSON text in a single cell.
name | city | rating | open | website | address.street | address.postcode | tags Café Luna | Lisbon | 4.7 | true | | Rua Nova 12 | 1100-123 | ["café", "bakery"] Café Mar | Porto | 4.2 | false | | Rua das Flores 8 | 4050-262 | ["dinner"]
Cells stay empty where a value is null or a key is missing, and the header row names every column.
Rules, flattening and edge cases
Headers come from the object keys. When objects in the same array use different keys, the worksheet includes a column for each key found, and objects without that key leave the cell empty. Key names are used exactly as written, including capital letters.
Nested objects are flattened into columns where practical, with the path shown in the header, such as address.street. Nested arrays and deeper structures that do not fit a column neatly are shown as JSON text in one cell, so no data is silently dropped. A single JSON object on its own becomes one row.
Dates stay exactly as they appear in the JSON, as text or numbers. The tool does not guess which strings are dates and does not reformat them, so a date written as 2026-11-18 stays as that text. Very large files may be slow to convert, because the whole workbook is built in your browser.
If one object repeats a key, only the last value is used. Invalid JSON is reported as an error, so fix the problem and try again.
Common mistakes
Most problems come from the input shape or from expecting the wrong kind of file.
- Renaming a .csv file to .xlsx and expecting a workbook. A renamed text file is still text, so use this converter instead.
- Expecting several sheets, charts or coloured formatting in the download. The file holds one plain worksheet. Add charts and formatting in Excel after opening it.
- Pasting JSON with trailing commas, single quotes or comments. Those are not valid JSON, so the conversion reports an error. Fix the source export first.
- Pasting several separate objects without wrapping them in an array. Objects without square brackets do not form a JSON array, so wrap them in brackets with commas between them.
- Expecting a nested array to become extra rows or sheets. Nested arrays stay in one cell as JSON text, or are flattened into columns, but never become separate sheets.
When to use Excel, and when to choose something else
Choose the Excel download when the receivers work in spreadsheets. A real workbook is easy to sort, filter, print and attach to an email, and it opens directly without an import step.
Choose CSV when the receiving system expects plain text, or when you need a small file any program can read. Choose a table view when you only want to look at the data once, without downloading a file.
Keep the original JSON when the data feeds code, an application programming interface, or another program. JSON preserves types and nesting exactly, while a worksheet flattens both. Convert to Excel for people, and keep JSON for systems.
Frequently asked questions
Is the downloaded file a real Excel file?
Yes. The download is a genuine .xlsx workbook with one worksheet, not a renamed text file. It opens in Excel and in other spreadsheet programs that support the .xlsx format.
How many worksheets does the file contain?
One. The converter creates a single plain worksheet with headers and rows. It does not create extra sheets, charts or formatted reports.
What happens to nested objects and arrays?
Nested objects are flattened into columns where practical, with headers such as address.street. Nested arrays and deeper structures appear as JSON text in a single cell, so the data is kept rather than dropped.
Are dates converted to Excel dates?
No. Dates stay as the text or numbers written in the JSON. The tool does not guess which strings are dates, so reformat date columns in your spreadsheet program if you need true Excel dates.
What if my JSON is a single object, not an array?
A single object becomes one row under headers taken from its keys. For several rows, wrap the objects in square brackets to form an array, with commas between the objects.
Is my data uploaded anywhere?
No. The conversion runs in your browser on your own device. Your input is never sent to a server, and there is no sign-up or account.
What if my JSON is invalid?
The tool reports the problem instead of creating a file. Fix the error in the JSON, for example a missing comma or bracket, and convert again.



