Skip to content

Nested JSON to CSV Flattener

Flatten nested objects into CSV columns or expand escaped paths from CSV.

Found a problem, or something that could be better? We read every message and we fix things quickly.

Nested JSON to CSV flattener turns object paths into columns, with escaped dots and backslashes to avoid key collisions.

CSV to JSON keeps cells as strings and can expand those paths. Arrays remain JSON text; null and missing values become empty CSV cells.

How to use

  1. Paste JSON records or a CSV with a header, then choose the direction.
  2. Choose the delimiter, path expansion or spreadsheet formula escaping.
  3. Generate, inspect the field mapping and copy or download.

Frequently asked questions

How are nested keys named?

Dots separate levels. A literal dot or backslash inside a key is escaped with a backslash.

Does CSV restore JSON types?

No. Cells remain strings. Null versus missing, numbers and booleans are not reconstructed automatically.

Are arrays flattened into rows?

No. Arrays become JSON text in one cell, avoiding accidental multiplication of records.

What are the limits?

Use up to 1 MB input, 10,000 records, 200 output columns and 40 nested object levels. Conflicting paths are rejected.

Spreadsheet formulas

The default apostrophe prefix prevents common formula prefixes from being interpreted on spreadsheet import. This changes cell text; review imports in the destination app.

Path conflicts

A column cannot be both a leaf and a parent. Keys such as __proto__ are handled as data in separate own properties.