How to use CSV ↔ JSON
- 1. Paste CSV or JSON. Header row becomes object keys.
- 2. Pick an output. JSON, CSV, or INSERT.
- 3. Name the table. Used only for SQL emit.
- 4. Copy. Local only.
About this tool
CSV is how spreadsheets and warehouses still talk. JSON is how APIs talk. INSERT is how you seed a database from either. This tool does the boring mapping in the tab.
Quoted commas
PapaParse honors RFC 4180 quotes. If a column is wrong, look for an unescaped quote.
SQL literals
Strings are quoted and doubled. Numbers stay numeric. Empty cells become NULL.
Code examples
CSV
id,email
1,[email protected]