JSON to Relational CSV Converter

Convert complex API JSON into clean, relational CSV tables — fully in-browser.

No uploads Vanilla JS Copy / Download

Perfect for exporting API responses to Excel, BigQuery, or PostgreSQL.

JSON input

Upload file

Explode primitive arrays into child tables ? Child table prefix Replace dots with underscores in child table names ? CSV → JSON: unflatten dot paths to nested objects ? Delimiter ?

Tip: Drag & drop a .json or .csv file anywhere to load it.

CSV output

Usage & schema tips

JSON→CSV: nested objects flatten; arrays of objects become child tables with _parent_row_id + _index.
Arrays of primitives can be exploded (toggle) or kept as strings. Dates output ISO strings.
CSV→JSON: optional unflatten for dot-path headers; mixed array/object paths warn.
Delimiters: comma / semicolon / tab; BOM stripped.
ZIP best under ~20MB in-browser.

Joins: main PK _row_id; child PK (_parent_row_id, _index); FKs back to main._row_id.