Paste your JSON below — or upload a .json file. The Excel file is ready to download at once.
About converting JSON to Excel
You exported data from an app, a web shop or an API, and it came as JSON. Your team wants to sort, filter and add it up in Excel. This tool turns the JSON into a real Excel workbook (.xlsx): one row for each item in the list, one column for each field.
Paste the JSON or upload a .json file. The preview shows the table at once, and the Excel file is ready with one click.
Everything runs in your browser. Your data is never uploaded.
Features
- A real .xlsx file — opens in Excel, Google Sheets, Numbers and LibreOffice
- One row per item — every object in the list becomes a row
- Nested objects flattened — {"customer": {"name": "Ada"}} becomes a column customer.name
- Finds the list — rows inside an API answer like {"data": [...]} are found for you
- Types kept — JSON numbers are Excel numbers, true/false are TRUE/FALSE, strings stay text
- Every key becomes a column — even keys that only some items have
- Columns sized to fit and a sheet name you choose
- One click — the Excel file is rebuilt as you type; just press Download
How JSON fits into rows and columns
| JSON value | Excel cell |
|---|---|
"order": 1001 | the number 1001 |
"zip": "02134" | the text 02134 — a JSON string stays text, zeros and all |
"paid": true | TRUE |
"note": null | an empty cell |
"customer": {"name": "Ada", "city": "London"} | two columns: customer.name and customer.city |
"items": ["lamp", "desk"] | one cell: lamp, desk |
"lines": [{"sku": "A1"}, {"sku": "B2"}] | one cell with the list as JSON text |
The example in the box becomes this sheet:
| order | customer.name | customer.city | items | paid |
|---|---|---|---|---|
| 1001 | Ada Lovelace | London | lamp, desk | TRUE |
| 1002 | José Álvarez | Madrid | chair | FALSE |
Untick Flatten nested objects to keep each nested object in one cell as JSON text.
Where the rows come from
- A list of objects [{…}, {…}] — the normal case: one row each, the keys are the header row.
- An API answer {"status": "ok", "data": [{…}, {…}]} — the longest list of objects inside is used. The line under the box says which one.
- A list of lists [["name", "age"], ["Ada", 36]] — each inner list is one row, as it is.
- A list of plain values ["red", "green"] — one column.
- One object — one row.
Limits
- JSON numbers bigger than 9,007,199,254,740,991 lose their last digits when JSON is read in a browser. Store long IDs as strings ("id": "12345678901234567890") and they stay exact.
- Dates in JSON are strings, so they stay text in Excel. Sorting still works for ISO dates like 2026-11-02.
- An Excel sheet holds at most 1,048,576 rows and 32,767 characters per cell. A longer cell is cut, and the tool tells you.
Frequently asked questions
How do I open a JSON file in Excel?
Upload the .json file here (or paste its text) and click Download Excel file. Open the .xlsx in Excel — every item is a row and every field a column.
Can it handle nested JSON?
Yes. Nested objects become extra columns named with dots, like customer.address.city. Lists of plain values are joined with commas; lists of objects are kept as JSON text in one cell.
My JSON is an API response, not a list. Will it work?
Yes. The tool looks inside the object, finds the longest list of objects (for example "data" or "results") and makes the rows from it.
Can I convert Excel back to JSON?
Yes — switch to Excel → JSON at the top, or use Excel to JSON.
Is my data uploaded?
No. The JSON is read and the Excel file is made inside your browser. Nothing is sent to a server.
Related tools
- JSON to CSV — the same rows as a CSV file
- Excel to JSON — the other direction
- CSV to Excel — a CSV file to a real workbook
- JSON Formatter — check and tidy the JSON first
- Merge Excel Files — combine this workbook with others
How to use it
- Paste your JSON into the box — or click Upload a .json file, or drop the file on the box
- Keep Flatten nested objects on to get one column per nested field
- Check the preview and the line under the box (rows, columns, the list it used)
- Give the sheet a name if you like
- Click Download Excel file
