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

  1. Paste or drop JSON/CSV. Nothing leaves the browser.
  2. Choose options: delimiter, explode arrays, replace dots, or unflatten CSV.
  3. Convert. Main table keeps _row_id; child tables carry _parent_row_id + _index.
  4. 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

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.