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.

CSV ↔ TSV ↔ Pipe Converter

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.

—

Input delimiterOutput delimiter

Input

Output (4 rows × 3 cols)

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.

Guides on this topic

Working with CSV Files Without Breaking Them Why CSV keeps going wrong — quoting, delimiters, encodings, leading zeros and dates — and how to move data between spreadsheets, JSON and SQL without silent corruption.

Related tools

HTML Table to CSV Converter

Extract HTML <table> data into CSV, TSV or semicolon-separated rows, in your browser.

Convert 0 0

JSON Lines (NDJSON) Viewer

Paste or drop a `.jsonl` / `.ndjson` file, see records as a table, filter by `field:value`, pick which columns to keep, and re-export as JSON or CSV.

File 0 0

CSV → SQL INSERT Generator

Convert CSV / TSV rows into SQL INSERT statements with table name, dialect quoting, type inference, and multi-row mode.

Convert 0 0

CSV to Excel (XLSX) Converter

Turn CSV or TSV into a real .xlsx file in your browser, with leading zeros, long IDs and codes like SEPT1 kept exactly as typed.

File 0 0

Markdown Table Generator

Paste CSV, TSV, or pipe-delimited data and get a properly aligned GitHub-flavored Markdown table.

Text 0 0

CSV Viewer & Sorter

View CSV / TSV data as a sortable, searchable table — open a file or paste rows, no spreadsheet required.

Text 0 0