Flatten Nested JSON for CSV and Excel

This guide explains how to use the nested-data settings in JSON to CSV. It is not a separate converter screen. Data.Page uses the same conversion engine, but the choices you make for nested objects and arrays determine whether the CSV is useful in Excel, Google Sheets, or BI tools.

Example nested JSON

{
  "order_id": 1001,
  "customer": {
    "name": "Alice",
    "country": "AU"
  },
  "items": [
    { "sku": "A-1", "qty": 2 },
    { "sku": "B-7", "qty": 1 }
  ]
}

Simple child fields can become columns such as customer.name and customer.country. Repeated arrays such as items usually need a different table shape because one order can contain multiple item rows.

Flattening choices

Same-row columns: works for simple child objects and short one-to-one data.
Header/detail output: works better when each parent record has many child rows.
Concatenated values: can be useful for short lists such as tags or labels.
Matrix-style columns: can help when child values need to become separate spreadsheet columns.

How to use this in Data.Page

Open JSON to CSV.
Upload or paste your JSON.
Open the settings panel with the cog icon.
Choose the nested-data option that matches your source.
Download the resulting CSV and check whether parent/child relationships are still clear.

When not to flatten everything

Some data should stay relational. If one customer has many orders and each order has many items, a single flat row can become hard to trust. Separate CSV files for customers, orders, and items are usually cleaner than one very wide spreadsheet.

Related guides

If the best table shape is not obvious, contact us with a small sample and the report you want to produce.

}

Contact