Nested JSON to Excel Converter

Nested objects become columns. Lists become one row per item, ready to sort, filter, and total. Or just ask, like “total by customer”.

  1. Paste your nested JSON
  2. Check the table, or ask it a question
  3. Export to Excel, Sheets, or CSV

Paste anywhere on this page, or drop a .json, .jsonl, or .csv file.

How Nested JSON Becomes a Spreadsheet

A spreadsheet is a flat grid, and JSON isn't. Take one record with a nested customer and two orders:

{
  "id": 101,
  "customer": { "name": "Ana Ruiz" },
  "orders": [
    { "sku": "TEA-01", "qty": 2 },
    { "sku": "MUG-04", "qty": 1 }
  ]
}

Nested objects become columns

Each field inside customer gets its own column, named by its path: Customer.Name. Objects inside objects keep extending the name (Customer.Address.City), so there's no depth limit.

Lists: one row per item

Each order gets its own row, and the customer's fields repeat on every row. This is the layout for pivot tables, filters, and totals like "units per SKU".

IdCustomer.NameOrders.SkuOrders.Qty
101Ana RuizTEA-012
101Ana RuizMUG-041

Lists of plain values, like "tags": ["billing", "priority"], always become one comma-separated cell. If a record has several lists, the longest becomes rows and the others stay as numbered columns, so rows never multiply.

Building this into your own product?

Call the same nested-JSON conversion from your own code with the developer API, using the same prepaid credits.

View the Developer API

Questions

How do I flatten nested JSON into a spreadsheet?

Paste or drop the JSON above, or try the example, and the table appears instantly. Nested objects become dot-notation columns, and lists of objects become one row per item. Then download Excel, copy it into Google Sheets, or download CSV: you get exactly the rows shown.

What happens to arrays inside my JSON?

Arrays of plain values become one comma-separated cell. Arrays of objects become one row per item, with the parent's fields repeated.

Can I convert nested JSON to CSV or Google Sheets?

Yes, right here: after the table appears, choose Copy for Google Sheets or Download CSV. Both are built in your browser with the same rows and columns as the preview. JSON to Google Sheets walks through pasting it into a sheet.

Is there a limit to how deeply nested the JSON can be?

No depth limit: customer.address.city becomes Customer.Address.City. When rows are used, only the longest list is split into rows. Other lists, and lists inside lists, stay as numbered columns.

Is my JSON stored?

No. The table, Google Sheets copy, CSV, and Excel file are all built in your browser, so your data never leaves your device. Need it inside your own app? The developer API does the same conversion.

API responses often come wrapped in extra layers; see our guide to converting API data to Excel. Working with JSON Lines? Read what NDJSON is.