JSON file ya API response ko Excel sheet me badle, nested list alag sheet me
Processed in your browser. Nothing is uploaded. Checked against sources on 17 Oct 2026.JSON file Excel me seedhe nahi khulti, aur nested data ek hi cell me fas jaata hai. File daaliye ya JSON paste kijiye: har list apni sheet ban jaati hai, andar ke object address.city jaise column ban jaate hain, aur number number hi rehte hain. 15 digit se lambe ID text me rakhe jaate hain taki Excel unhe badal na de. Kuch bhi upload nahi hota.
Drop your files or click to choose them.
Adjust the options and check the preview.
Download the result. Nothing was uploaded.
JSON is how APIs, apps and exports hand over data, but it is a tree and a spreadsheet is a grid. This page decides the grid for you, the way a person would.
| In the JSON | In the workbook |
|---|---|
| A list of objects | One sheet, one row per object, one column per key |
| A nested object, "address": {"city": ...} | A column named address.city |
| A list of plain values, ["red", "blue"] | One cell: red, blue |
| A list of objects inside a row, "items": [...] | Its own sheet; each row says which parent row it belongs to |
| An object holding several lists | One sheet per list, other keys on an Info sheet |
Keys missing from some objects simply leave their cell empty, and the columns are the union of all keys in the order they first appear. If you prefer one flat sheet, nested lists can stay as JSON text in their cell instead.
The rest of the article, and all 6 questions about JSON to Excel Converter, are on the JSON to Excel Converter page.
Drop the .json file on JSON to Excel Converter, or paste the JSON into the box. A preview shows the sheets and their first rows straight away. Press Download and an .xlsx workbook saves, ready for Excel, Google Sheets or Numbers, with numbers you can sum and filter.
Nested objects become dotted columns, so address.city sits beside name. Lists of objects inside a row, such as the items of an order, get a sheet of their own, and each item row carries the row number of its order, so the two sheets can be matched with a filter or a lookup.
Yes. Choose Nested lists as JSON text, and each nested list stays in its parent's cell as JSON instead of getting its own sheet. Plain lists of values, such as tags, are always one cell with the values separated by commas.
Yes. A file with one JSON object per line (.jsonl or .ndjson) becomes one sheet with a row per line. An API response like {"data": [...], "meta": {...}} gets a sheet for the data list and an Info sheet for the other fields.
Rates and rules change; check the source before you rely on a figure.
Still stuck? Ask about JSON to Excel Converter and anybody who knows can answer. No account needed.
On the related tools: Convert Any File – Photos, documents, spreadsheets, archives: drop it and see what is possible · Markdown File to HTML – Turn a .md file into the HTML behind it.