CSV ⇄ JSON

About CSV ⇄ JSON

CSV to JSON: upload or paste CSV, pick delimiter (Auto-detect, Comma, Semicolon, Tab, or Pipe), Shape (Array of objects or Array of arrays), First row is header, and Infer types. Pretty JSON is always on. Download JSON and Copy. Empty cells become null when Infer types is on, or empty strings if you turn it off. A UTF-8 BOM on the way in is stripped.

JSON to CSV: upload or paste JSON (an array of objects works best). Nested objects flatten as a.b.c. Primitive arrays join with commas. Nested arrays are stringified. Pick columns with checkboxes. Optional UTF-8 BOM for Excel on Windows, and True/False for Excel or Python. Download CSV and Copy. Copy omits the BOM; the download file keeps it if you turned BOM on. Newlines are Windows-style.

How to use CSV ⇄ JSON

1. 1Pick a tab. CSV to JSON or JSON to CSV.
2. 2Drop or paste the file. Delimiter auto-detect on CSV. An array of objects works best for JSON.
3. 3Set options. Headers, shape, and types one way. Columns and BOM the other.
4. 4Preview, then Download JSON or Download CSV. First 20 rows. Copy is available on both tabs.

CSV to JSON

Preview is the first 20 data rows plus a JSON snippet (clipped on screen; Copy is the full string). Header row on by default. Infer types on by default: integers, decimals that keep a trailing .0, and true/false.

JSON to CSV

A single-key object whose value is an array is unwrapped. An array of arrays uses row 0 as the header. Column checkboxes hide keys you do not want in the CSV. Large pastes convert on the page; there is no separate queue.

Limits and privacy

CSV to JSON and JSON to CSV both run in your browser. Each upload is 15MB. Pasted CSV or JSON is not size-capped. Nothing is sent to aiaq.io. No account.