CSV Delimiter Converter
Convert CSV between comma, semicolon, tab, pipe and custom delimiters without breaking quoted fields.
Processed locally in your browser/ Your data stays in your browser.
What is CSV Delimiter Converter?
Different regions and programs use different separators: many European spreadsheets export semicolons because the comma is their decimal mark, databases like tab-separated files (TSV), and some systems prefer pipes. Replacing characters by hand corrupts cells that contain the separator.
This converter parses the input properly, then writes it with the new delimiter, adding quotes only where the new delimiter or a line break appears inside a cell. The input delimiter can be auto-detected. It handles CSV to TSV, TSV to CSV, semicolon to comma and any other pair, plus custom single characters.
How does it work?
- Paste the file, or open it with the open-file button.
- Leave the input delimiter on auto-detect or set it, using custom character for unusual separators.
- Choose the output delimiter, the quoting style and the line endings.
- Copy the result or download it; a .tsv extension is suggested for tab output.
Common use cases
- Turning a semicolon-separated export from a European spreadsheet into a comma-separated file.
- Converting CSV to TSV for pasting into a database tool or a spreadsheet.
- Preparing a pipe-delimited file for a legacy system.
- Fixing a file that opens in one column because of the wrong delimiter.
Examples
Try this input in the tool above:
id;name;note 1;Alice;"likes ; and ," 2;Bob;plain
id name note 1 Alice likes ; and , 2 Bob plain
Privacy
CSV Delimiter Converter runs entirely in your browser. The text or files you provide are processed on your device and are not uploaded, logged or stored on our servers.
Limitations
Only single-character delimiters are supported. Decimal commas inside numbers are not converted to dots: only the separator between cells changes.
Frequently asked questions
Will commas inside my text be lost?
No. Cells containing the output delimiter are quoted automatically, and the content is unchanged.
How do I convert CSV to TSV?
Set the input delimiter (or leave auto-detect) and choose Tab as the output delimiter. Swap the values to go from TSV back to CSV.
Can I use a character that is not in the list?
Yes. Choose "Custom character" and type a single character such as ~ or ^. Write \t for a tab.
Related tools
CSV Formatter
Re-serialize messy CSV into a consistent file: same quoting rules, trimmed cells, one delimiter and one line-ending style.
JSON & Data
CSV Validator
Check that a CSV is well-formed before importing it, and get a list of problems with line numbers.
JSON & Data
CSV Viewer
Paste CSV text or open a .csv file and inspect it as a table, with row and column counts and the detected delimiter.
JSON & Data
CSV to JSON Converter
Turn CSV rows into clean JSON in one step, with typed values, custom delimiters and pretty or minified output.
JSON & Data
JSON to CSV Converter
Paste a JSON array and get a CSV file ready for Excel or Google Sheets, with nested data flattened into columns.
JSON & Data
CSV to Excel Converter
Paste CSV and download a proper Excel workbook where numbers are numbers and dates are dates.
JSON & Data
Excel to CSV Converter
Drop a spreadsheet, choose a sheet and get a clean CSV, with the delimiter and quoting you need.
JSON & Data
CSV to TSV Converter
Paste comma- or semicolon-separated data and get clean tab-separated text, ready for spreadsheets, databases and command-line tools.
JSON & Data