Data cleaning / FREE

JSON Flattener

Convert nested JSON into a flat table with explicit array handling.

Make it work with your data.

HOW TO USE IT

JSON Flattener

Choose how to handle arrays, flatten the JSON, then copy or download the resulting CSV.

What to know

Column names use JSON Pointer paths: /customer/name. A slash in a key becomes ~1 and a tilde becomes ~0. Expanding sibling arrays produces a Cartesian product. Empty arrays preserve a row with a blank cell; missing fields and nulls export as blank. Limits: 10,000 output rows, 300 columns, 30 nesting levels.

← Explore all tools