A preview of each sheet appears here.
How to use
01
Add your JSON
Paste JSON or JSON Lines, drop or upload a .json file, or press Load URL. Try sample loads orders and customers, two lists that become two sheets.
02
Set the workbook options
Pick the format, flattening, array handling and sheet name. Keep One sheet per top-level list ticked for several lists, or type an Array path such as data.items to use one nested list.
03
Preview and download
Check each sheet in the preview on the right, then press Download. The file is built in your browser and saved straight to your device.
Why JSON to Excel Converter
- Creates a real .xlsx workbook, not a CSV, with typed numbers and booleans.
- One sheet per list, filter buttons on the header row and fitted column widths.
- Flattens nested objects and lets you choose how arrays appear in cells.
- Runs in your browser, so the data never leaves your device.
How JSON maps to rows, columns and sheets
The converter follows a few fixed rules, shown here with the sample data on this page.
| JSON | In the workbook |
|---|---|
| {"orders": [...], "customers": [...]} | Two sheets, named orders and customers |
| One object in an array | One row |
| "total": 42.5 | A numeric cell in the total column |
| "paid": true | A TRUE boolean cell |
| "customer": {"name": "Alice"} | A customer.name column |
| "items": ["lamp", "bulb"] | lamp; bulb in one cell (default) |
| null or a missing key | An empty cell |
JSON to Excel or JSON to CSV?
Both give you rows and columns, but the files behave differently once you open them.
- Choose Excel when you want several sheets, typed numbers, header filters and fitted columns without extra steps.
- Choose CSV when another program will import the file, when you need a specific delimiter, or when the file must stay plain text for version control.
- CSV opened in Excel is guessed column by column, which can turn IDs like 00123 into 123 or long numbers into scientific notation. An .xlsx file stores each cell's type, so that does not happen.
Common questions
How do I convert JSON to an Excel file?
Paste the JSON or upload the file, check the preview, and press Download. You get an .xlsx workbook where each object is a row and each key is a column. No sign up, and the file is built in your browser.
How are nested JSON objects shown in Excel?
With Flatten nested objects ticked, each nested key gets its own column named with dots, such as customer.name and customer.country. Untick it to keep each nested object as JSON text in a single cell.
What happens to arrays when converting JSON to Excel?
The Arrays menu decides. Join values with ; writes ["lamp", "bulb"] as lamp; bulb in one cell. Keep as JSON text writes the array as written. One column per item spreads it over columns such as items.0 and items.1.
Can I put different JSON arrays on separate Excel sheets?
Yes. When the top level of your JSON is an object with two or more lists, and One sheet per top-level list is ticked, each list becomes a sheet named after its key. Untick the option, or type an Array path, to get a single sheet.
Does JSON to Excel keep numbers as numbers?
Yes. Numbers are written as numeric cells and true or false as boolean cells, so formulas, sorting and filters work straight away. Strings that look like numbers, such as "00123", stay text because they are strings in the JSON.
Which spreadsheet formats can I download?
Excel .xlsx, the older Excel 97-2003 .xls and OpenDocument .ods, which LibreOffice and Google Sheets open. For a plain text file, use the JSON to CSV Converter instead.
Is there a size limit for JSON to Excel?
Excel itself allows 1,048,576 rows per sheet and 32,767 characters per cell, and longer text is cut with a notice. In practice the limit is your browser's memory; tens of thousands of rows convert comfortably on a laptop.
Is my JSON uploaded when I create the Excel file?
No. The workbook is built by JavaScript in your browser tab and saved directly to your device. Only Load URL uses the site's server, to fetch a public address that browsers would otherwise block.
Can I open the downloaded file in Google Sheets?
Yes. Upload the .xlsx or .ods file to Google Drive and open it with Google Sheets, or use File, Import inside a sheet. Each sheet in the workbook becomes a tab.