How to flatten nested json to csv with dot-notation columns
- Step 1Drop the nested JSON file in — JSON arrays, NDJSON, and single objects are all accepted; auto-detect picks the right parser.
- Step 2Leave 'flatten nested objects' on — Recursive flattening produces dot-notation headers across every nested level.
- Step 3Pick how arrays should render — Pipe or comma joins are friendlier to Excel; JSON-literal preserves structure for downstream code.
- Step 4Download the CSV — Open it in Excel, Sheets, or load it into BigQuery / Snowflake.
Frequently asked questions
What happens with arrays of objects?+
They are serialised into a single cell — JSON literal, pipe-joined, or comma-joined. To explode them into rows, normalise the JSON in code first.
Do all records need the same keys?+
No. The CSV header is the union of every key seen across records. Records that lack a key get an empty cell for that column.
How deep can the flattening go?+
There is no fixed limit. Practical depth is bounded only by the number of resulting columns, which Excel caps at 16,384.
Privacy first
Conversion runs locally in your browser. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.