How to use the JSON to Excel tool
- Add JSONPaste JSON into the box, or drop or open a .json file.
- Pick the dataThe tool finds the lists of records in your JSON. If there are several, choose which one becomes the table.
- Adjust columnsChoose how nested names are written and how lists inside records are shown.
- DownloadCheck the preview, then download an Excel (XLSX) or CSV file.
Features
- Finds your dataWorks with a top-level array, with records wrapped in an object like {"data": [...]}, and with JSON Lines.
- Nested objects become columns{"address": {"city": "Pune"}} becomes a column named address.city.
- Every key keptRecords with different fields are combined; missing values are left empty.
- Numbers stay numbersNumeric values are written as numbers, so you can calculate with them in Excel.
- PrivateAPI responses with customer data or tokens never leave your device.
From API response to spreadsheet
JSON is how most web services and apps exchange data, but it is hard to read, filter or total. Excel is the opposite. This converter turns one into the other in seconds.
- Exporting orders, users or products from an API or admin panel
- Analyzing logs and analytics exports in Excel or Google Sheets
- Sharing data from developers with colleagues who don’t read JSON
- Checking a JSON file for missing or inconsistent fields
How JSON is turned into rows and columns
| JSON | In the spreadsheet |
|---|---|
| Array of objects | One row per object, one column per key |
| Nested object | Columns such as address.city |
List of values ["a","b"] | One cell: a, b |
| List of objects inside a record | JSON text in one cell, or choose that list as the table to get one row per item |
| true / false / null | TRUE / FALSE / empty |
Problems you may run into
- “Invalid JSON”. The most common causes are a trailing comma after the last item, single quotes where double quotes are required, and text copied with “smart” curly quotes. Run the data through our JSON Formatter to see exactly where the error is.
- Everything lands in one row. Your data is probably a single object, not a list. Look for the array inside it, often under a key such as
data,itemsorresults, and convert that part. - Long numbers change. Excel keeps 15 digits of precision, so very long IDs can be rounded. Store such values as text in the source, in quotes, to keep every digit.
- Dates show as text. JSON has no date type. Dates arrive as text such as
2026-03-15T10:30:00Z. In Excel, use Data → Text to Columns or the DATEVALUE function to turn them into real dates. - Records have different fields. That is fine. Every field becomes a column, and a cell is left empty where a record does not have that field.
Related tools
Check or tidy your JSON first with the JSON Formatter. Already have a CSV? Use CSV to Excel.
Frequently asked questions
How do I convert JSON to Excel?+
Paste the JSON or open a .json file, check the preview and click “Download Excel”.
What JSON structure is supported?+
An array of objects works best. Records wrapped in an object (like {"results": [...]}), objects of objects and JSON Lines files are also recognized.
What happens to nested objects?+
They are flattened into columns with names like address.city. You can choose a different separator.
Can I get CSV instead?+
Yes. Click “Download CSV” for a UTF-8 CSV file that opens correctly in Excel.
Is my JSON uploaded?+
No. The conversion runs entirely in your browser.