Documentation
How to use the JSON → Relational CSV Converter, with schema, examples, and FAQs.
Sponsored
Features for developers
Relational output
Nested arrays become child tables with
_parent_row_id + _index; perfect for SQL joins.
Schema docs & SQL
Download CSVs, schema README, and ready-to-run CREATE TABLE SQL in one click.
Privacy-first
Runs in your browser. No uploads. Plausible is cookieless; AdSense uses cookies only for ads.
Export-ready
Copy, download, or ZIP tables; choose delimiter; explode primitive arrays when needed.
Limitations
Best for datasets under ~20MB for ZIPs; deeply nested mixed arrays stringify.
Trust signals
Clear schema notes, transparent privacy policy, changelog, and contact channel for support.
How it works
- Paste or drop JSON/CSV. Nothing leaves the browser.
- Choose options: delimiter, explode arrays, replace dots, or unflatten CSV.
- Convert. Main table keeps
_row_id; child tables carry_parent_row_id+_index. - Download CSV/SQL/README or ZIP everything for your warehouse, spreadsheet, or BI tool.
Examples
JSON → CSV
[{ "id": "proj-1001", "name": "Demo", "owners": [{ "name": "Ada", "role": "lead" }], "metadata": { "tags": ["demo","beta"] } }] produces a main table plus an owners child table.
CSV → JSON
id,name,team.0,team.1,metrics.total,metrics.daily.0 can rebuild nested objects when "Unflatten" is toggled.Schema notes
- Main table: primary key
_row_id(derived fromid/_id/uuidor row index). - Child tables: PK
(_parent_row_id, _index); FK_parent_row_id→main._row_id. - Primitive arrays: optionally exploded into child tables with
valuecolumn. - Objects inside arrays: normalized into child tables; arrays of mixed types are stringified to stay lossless.
- Downloads: CSV per table, schema README (Markdown), and SQL DDL.
FAQ
Is my data uploaded?
No. All parsing and conversions run locally in your browser. Only Plausible (cookieless) and AdSense (ads cookies) load externally.
Where do I place the outputs?
Use CSVs directly in Excel/Sheets, copy to BigQuery/Snowflake loaders, or run the SQL DDL to mirror the schema.
Can I restore nested JSON?
Yes—use CSV → JSON mode with "Unflatten" for dot-path headers. Mixed path styles warn but still convert.
AdSense compliance?
Ad units are rendered; cookies come from AdSense only. See Privacy and Terms for details.