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.
[
{
"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.
Related Python syntax guides
All Python guidesPython iter(): How the Built-in Function Works
Explains Python's iter() built-in: how it creates iterators, the two-argument sentinel form, custom iterator classes, and common edge cases.
PythonPython Pika: Queues, Exchanges, Routing Keys, and Acknowledgements
Learn how to use Python's Pika client with RabbitMQ: declare queues and exchanges, publish with routing keys, consume messages, and handle acknowledgements reliably.
PythonPython Kafka: kafka-python vs Confluent Client
python kafka python vs confluent kafka: Compare kafka-python and Confluent Kafka Python clients: API differences, performance, feature coverage, and when to choose eac...
PythonPython Kafka Offsets, Partitions, and Manual Commits
Learn how Kafka offsets and partitions work and how to manually commit offsets in Python consumers with kafka-python and confluent-kafka. Covers sync vs async commits, rebalances, and seeking.