TSV to CSV Converter (Change CSV Delimiter)

Tab-separated text is what you get when you copy cells from Excel or Google Sheets; many databases, mailing tools and scripts want comma-separated CSV instead, and European Excel writes semicolons. This converter reads any of them and writes the delimiter you need, quoting values the way RFC 4180 describes so that a comma inside "Seoul, Korea" or a line break inside a note never splits a cell. It covers CSV to TSV, TSV to CSV and changing a CSV's delimiter in one place.

How to use this tool

1. Paste the cells or the file's text into the box.
2. Leave the input delimiter on "Detect automatically", or pick it yourself (Custom for anything else, such as ^ or ::).
3. Choose the output delimiter and how values are quoted.
4. Pick CRLF or LF line endings, then copy the converted text.

Formula

value → "value with "" for each "" when it contains the delimiter, a double quote or a line break

Detection tries tab, semicolon, comma and pipe on the first 200 rows and keeps the one that splits the most rows into the same number of values (at least two); ties go to more columns, then to that order, so semicolon files with decimal commas are read correctly. Values are never changed: only the separators and the quotes around values differ. A final line break in the input is kept.

Example

The sample has four columns pasted from Excel. As CSV, Says "hi" contains quotes, so it becomes "Says ""hi"""; Seoul, Korea contains a comma, so it becomes "Seoul, Korea"; the empty note stays empty: Lin Wei,"Seoul, Korea",,980. The amounts are untouched. Converting Tea;1,50 from a German Excel file gives Tea,"1,50".