Skip to content

File Tools

CSV Delimiter Converter

Re-delimit CSV/TSV data between comma, semicolon, tab, and pipe — with RFC-correct quoting so embedded separators never break fields.

Fields that contain the output delimiter are quoted automatically, per the CSV standard.

Why the Semicolon Exists in European CSVs

The comma-decimal countries (Spain, Germany, France, most of Latin America) export spreadsheets with semicolon delimiters because the comma is already the decimal separator — "1.234,56" cannot live in a comma-separated field unquoted. This is why a CSV that opens perfectly in one locale shows a single column in another: Excel picks the delimiter from the system locale. Quoted fields containing the target delimiter must stay quoted through the conversion, or the column structure silently shifts by one for those rows.

How the Tool Processes Your File

  1. Paste delimited data or load a .csv/.tsv/.txt file.
  2. Choose the detected input delimiter and the output delimiter.
  3. The parser honors quoting per RFC 4180, then re-emits with quoting only where required.
  4. Copy the result or download it with the correct file extension.
Formula & Technical Standard
Parse with the input delimiter (respecting quotes), serialize with the output delimiter, quoting fields that contain it.

Typical Use

European Excel export
Input: Semicolon-delimited data
Output: Comma-delimited CSV
Most databases and scripts expect commas; converting an Excel-locale export makes it consumable.
Pipe-delimited legacy feed
Input: Pipe-separated product feed
Output: Tab-separated for spreadsheet import
TSV pastes cleanly into spreadsheets without a delimiter dialog, since tabs are detected automatically.

Common Questions

What if my data contains the output delimiter?

Those fields are automatically wrapped in double quotes, exactly as the CSV standard requires.

How is this different from the CSV Formatter?

The Formatter validates and cleans a CSV in its own format. The Delimiter Converter changes the separator itself.