CSV ↔ TSV ↔ Pipe Converter
Convert
Pastes data delimited one way and re-emits it delimited another. Auto-detects the input separator from the first line, parses with full quote / escape-quote support, and re-emits with RFC-4180-style quoting (cells containing the new delimiter, quotes, newlines, or edge whitespace are wrapped in `"…"` and inner quotes doubled). Useful when an Excel export hands you semicolons but your pipeline expects commas, or when you need TSV to paste cleanly into Google Sheets.
name role note Alice Admin Lives in Seoul, Korea Bob Editor "Says ""hi""" Carol Viewer Plain note
Inner double quotes are escaped by doubling, per RFC 4180.
How to use
- Paste delimited text into the input box. The separator is detected from the first line.
- Pick the output delimiter. The conversion runs live.
- Row × column count is displayed so you can sanity-check the parse.
Frequently asked questions
- How is the input delimiter detected?
- By counting candidate characters (`,`, `\t`, `|`, `;`) on the first line, ignoring anything inside `"…"` quotes. The most frequent wins — comma is the tiebreaker since it's the most common on the web.
- What's the quoting rule on output?
- RFC 4180 style: a cell is wrapped in `"…"` whenever it contains the output delimiter, a double quote, a newline, or starts/ends with whitespace. Embedded double quotes are escaped by doubling (`"` → `""`).
- Why CSV ↔ TSV at all?
- TSV is friendlier for spreadsheets — Google Sheets and Excel paste it directly into cells without a dialog. CSV is friendlier for data tools and CLI pipelines. Quick conversion between them removes a step.
Related tools
CSS Unit Converter
Convert between px, rem, em, pt, vw, vh, and % using your own base font size and viewport.
JSON ↔ YAML Converter
Convert JSON to YAML or YAML to JSON — pick the indent and copy the result.
Data Size Converter
Convert between bytes, KB, MB, GB, TB — in decimal (1000) or binary (1024).
Roman Numeral Converter
Convert between Arabic numbers and Roman numerals from 1 to 3999.
Number Base Converter
Convert numbers between binary, octal, decimal, and hexadecimal.
Unit Converter
Convert length, weight, temperature, area, volume, speed, and time.