Turn JSON into an Excel table, or an Excel sheet into JSON. Paste JSON from an API or a file, and each record becomes a row, with nested fields flattened into columns such as address.city.
How the conversion works
| JSON | Excel |
|---|---|
| An array of objects, [{{…}},{{…}}] | One row per object |
| Keys such as “name” | Column headers |
| Nested objects, “address”:{{“city”:…}} | Columns such as address.city |
| Simple lists, “tags”:[“a”,”b”] | One cell: a, b |
If the JSON is an object that contains an array, such as {"data":[…]}, the first array found is used.
Excel to JSON
The first row of the sheet becomes the field names, and every row below becomes one JSON object. Copy the result or download it as a .json file.
Load JSON in Excel with Power Query
For JSON you load regularly, such as from an API, use Data → Get Data → From File → From JSON, or From Web for a URL. Power Query can expand nested records and refresh the data later. See Power Query in Excel.
Are my files safe?
Yes. Your files are opened and converted inside your own browser. They are never uploaded to this site or anywhere else, which matters for salary sheets, bank statements and customer data. You can even disconnect from the internet after the page loads, and the tool still works.
Frequently asked questions
Why does it say the JSON isn’t valid?
JSON needs double quotes around keys and text, and no trailing commas. The error message shows where the problem is.
How deep can the nesting go?
Objects are flattened to any depth. Lists of objects are kept as JSON text in a single cell.
Is there a size limit?
No fixed limit; very large files depend on your computer.