Pages

Topics

Tools

↑↓navigate↵openescclose
Formatting & Data

CSV ↔ JSON

Convert CSV, TSV, or semicolon-separated data into JSON and back, with quoted fields, header control, and download.

Runs entirely in your browser — nothing you paste is uploaded.

Delimiterdetected comma
Presets
180 chars
4 rows · 5 columns3 rows · 5 columns
live
JSON
414 chars · 23 lines
[
  {
    "id": "1",
    "customer": "Ryu, Min",
    "email": "ryu@example.com",
    "total": "49.90",
    "currency": "USD"
  },
  {
    "id": "2",
    "customer": "Ada \"the countess\" Lovelace",
    "email": "ada@example.com",
    "total": "120.00",
    "currency": "GBP"
  },
  {
    "id": "3",
    "customer": "Grace Hopper",
    "email": "grace@example.com",
    "total": "15.50",
    "currency": "USD"
  }
]

RFC 4180 quoting is honoured: quoted delimiters, doubled quotes, and line breaks inside a field survive.

CSV and JSON reference

quick reference
"quoted, field"
A field containing the delimiter, a quote, or a line break must be wrapped in double quotes.
"" inside a field
Doubling the quote is the only escape in RFC 4180: Ada ""the countess"" Lovelace is read back as Ada "the countess" Lovelace.
Delimiter
Comma is the default, but tab (TSV) and semicolon win in locales where the comma is the decimal separator.
Header row
With a header, each row becomes an object keyed by column name; without one, each row stays an array.
CRLF vs LF
RFC 4180 uses CRLF, but most parsers accept a bare LF. Excel exports CRLF and a trailing newline.
Excel CSV
Excel drops leading zeros and rewrites long numbers unless the column is preformatted as text; import through Data → From Text for control.
All Python guides