A JSON to Excel converter turns JSON data into a spreadsheet you can open in Microsoft Excel, Google Sheets or LibreOffice. Paste a JSON array or object and this JSON to Excel converter shows it as a table straight away, with one row for each record and one column for each field. Press Download to save a real .xlsx file. Numbers stay numbers and true or false stays TRUE or FALSE, so you can sort, filter and add up the data as soon as it opens.
How to use the JSON to Excel converter
- Paste your JSON into the box. An array of objects, a single object or JSON Lines (one object per line) all work.
- Check the preview. The first 10 rows appear as a table, with the number of rows and columns above it.
- Choose the options. Flatten nested objects into columns, and put the field names in the first row, are both on by default.
- Press Download Excel file to save data.xlsx.
If the JSON has a mistake, the tool says roughly where it is, so you can fix it before converting.
What JSON is
JSON, short for JavaScript Object Notation, is an open standard format that uses human-readable text to store and send data as name–value pairs and arrays. It was derived from JavaScript, but many programming languages can write and read it, and it's widely used by web applications to exchange data with servers. JSON files use the extension .json. Its structure maps neatly onto a table when the data is a list of similar records, which is exactly what this converter is for.
How JSON becomes rows and columns
- An array of objects becomes one row per object. Every field name found in any object becomes a column, in the order it first appears.
- An object holding one list, such as {"data": [...]}, uses that list, so API responses work without editing.
- Any other object becomes a single row.
- Nested objects are flattened into dot-path columns: {"address": {"city": "Pune"}} becomes a column called address.city.
- Arrays of plain values, such as ["Excel", "SQL"], are joined into one cell as Excel; SQL.
- Arrays of objects inside a record are kept as compact JSON text in one cell.
- Missing fields and null become empty cells.
Worked example
Paste this JSON:
[{"name": "Asha", "age": 31, "city": "Pune"}, {"name": "Ravi", "age": 28, "city": "Delhi"}]
The preview shows 2 rows and 3 columns: name, age and city. In the downloaded file, row 1 holds the headings, Asha is in cell A2 and 31 is in cell B2 as a real number, so a formula like =AVERAGE(B2:B3) gives 29.5 straight away.
Numbers, text and dates
The converter keeps each value's JSON type. A JSON number becomes an Excel number and true or false becomes TRUE or FALSE. A string always stays text, even when it looks like a number, which protects values such as ZIP codes and phone numbers: "00123" keeps its leading zeros. Text that starts with an equals sign is stored as text too, never run as a formula. Dates in JSON are just strings, so they arrive as text; use Excel's DATEVALUE or Text to Columns if you need real dates.
Microsoft gives Excel's number precision as 15 digits, so a very long number such as an 18-digit ID loses its last digits in any spreadsheet. If your IDs are that long, store them as strings in the JSON so they stay exact.
Excel's limits
Microsoft lists these limits for a worksheet, and the converter checks them before making the file:
| Limit | Maximum |
|---|---|
| Rows on a worksheet | 1,048,576 |
| Columns on a worksheet | 16,384 |
| Characters in one cell | 32,767 |
| Number precision | 15 digits |
The header row counts as one of the rows. If deep nesting creates too many columns, turn off flattening so nested objects stay as JSON text in one cell.
The Excel file
The download is a standard .xlsx workbook with one sheet called Data. Column widths are set from the longest value in each column, up to a sensible maximum, so the data is readable when it opens. Excel, Google Sheets, LibreOffice Calc and Apple Numbers can all open it.
Your privacy
The JSON is read and the spreadsheet is built by your own browser. Nothing is uploaded, so you can safely convert customer lists, exports from internal systems or API responses that contain private data.
JSON Lines and API responses
Many logging tools and data exports write JSON Lines: one complete JSON object on each line, with no surrounding brackets. When the whole text isn't a single JSON value, the converter tries reading it line by line, so these files work as they are. API responses often wrap the records in an outer object, for example with a count and a results list. If that object holds exactly one list of records, the converter uses the list, so you don't have to cut the wrapper away by hand. If it holds several lists, the whole object becomes one row instead, and you can paste just the list you need.
Common mistakes
- Single quotes. JSON needs double quotes around names and text.
- A trailing comma after the last item makes the JSON invalid.
- Long IDs saved as numbers. Excel keeps 15 digits, so store long IDs as strings.
- Expecting real dates. JSON dates are text until you convert them in Excel.
What next
Use this often? Add JSON to Exce to your Home screen.
Frequently asked questions
How does the JSON to Excel converter work?
It reads your JSON in the browser, turns each record into a row and each field into a column, and saves a real .xlsx file you can open in Excel.
Are numbers kept as numbers?
Yes. JSON numbers become Excel numbers and true or false become TRUE or FALSE. Strings always stay text, so leading zeros are kept.
What happens to nested JSON?
With flattening on, nested objects become dot-path columns such as address.city. Lists of plain values are joined in one cell with semicolons.
How many rows can I convert?
Up to Excel's limit of 1,048,576 rows on a sheet, including the header row, and up to 5 million characters of JSON.
Is my JSON uploaded?
No. The conversion happens in your browser and nothing is sent to a server.
Was this tool helpful?
What went wrong?
We only receive the reason you pick, never what you typed into the tool.
Thanks for your feedback.