Change CSV Delimiter
Convert CSV files between delimiters such as commas, tabs (TSV), semicolons, and pipes. Fully RFC 4180 compliant, properly re-quoting fields containing the new delimiter symbol.
Interactive workspace loading...
How to Use Change CSV Delimiter
Key Features
Common Use Cases
- Converting US/UK comma CSVs into European semicolon CSVs for regional Excel compatibility.
- Converting CSV data into TSV for fast pasting into Google Sheets or command-line Unix tools like awk and cut.
- Formatting data with pipe delimiters for Markdown tables or database ingestion.
- Normalizing mixed-separator files before batch processing.
Frequently Asked Questions
In many European countries, the comma is used as the decimal separator (e.g. 19,99 €). Using commas as column separators in CSV files causes column splitting errors, so semicolons (;) are used instead.
The tool adheres to RFC 4180: if a cell contains the target delimiter, it will be wrapped in double quotes (e.g. '123 Main St; Apt 4' becomes '"123 Main St; Apt 4"').
Yes! Simply choose 'Tab (\t) [TSV]' as the target delimiter, and you will get clean, standard Tab-Separated Values.