CSV Delimiter Converter
Convert CSV delimiters online: comma to semicolon, tab to comma, pipe to comma and back. Source auto-detected, quoting fixed, LF or CRLF. Runs in your browser.
How to use CSV Delimiter Converter
- 1Paste the file or open a .csv, .tsv or .txt file; the source delimiter is detected.
- 2Choose the delimiter to convert to and the line endings.
- 3Copy the result or download it.
What makes it better
- Detects the source delimiter and shows which one it found
- Parses quotes correctly, so commas inside cells are not mistaken for separators
- Adds quotes where the new delimiter appears inside a cell
- LF or CRLF line endings and an optional quote-every-cell mode
- Warns about rows with a different number of cells
About CSV Delimiter Converter
CSV Delimiter Converter rewrites a delimited file with a different separator: comma, semicolon, tab or pipe, in either direction. The source delimiter is detected for you, the text is parsed properly rather than find-and-replaced, and any cell that contains the new delimiter, a quote or a line break is quoted so no column shifts.
Common uses
- Turn a comma CSV into the semicolon format a European Excel expects.
- Convert a TSV export to CSV for a tool that only accepts commas.
- Change a pipe-delimited legacy feed to comma or tab.
- Fix a file whose delimiter does not match what an import screen wants.
Example
Input
id,note,price 1,"red; large",9.5 2,plain,4
Result
id;note;price 1;"red; large";9.5 2;plain;4
Good to know
- A plain find-and-replace breaks files where cells contain the old or new delimiter. This tool reads the quoted cells first and writes them again, so values containing commas or semicolons stay in one column.
- Opening a CSV in Excel can treat cells that begin with =, +, - or @ as formulas. Turn on Prefix formula-looking cells under Advanced if the file comes from an untrusted source.
- Cell text is not changed, only separators, quoting and line endings. Rows with a different cell count are kept as they are, and a warning tells you how many there are.
CSV Delimiter Converter FAQ
How do I change a CSV from comma to semicolon?
Paste the file, leave From on Auto-detect, choose Semicolon under To and copy the result. Any cell that already contains a semicolon is wrapped in quotes.
How does the tool know the original delimiter?
It looks at the first lines and picks the separator that splits them into the most consistent number of cells. If a short file is misread, choose the From delimiter yourself.
Can it convert TSV to CSV and back?
Yes, in both directions. Tab characters inside quoted cells are preserved, and values that need quoting for the new delimiter are quoted.
Why would I pick CRLF line endings?
Choose CRLF for older Windows programs that expect carriage return and line feed. LF is right for Mac, Linux and most modern tools.
What does Quote every cell do?
It wraps every value in double quotes, doubling any quote inside it. Some importers require this even when a value contains no special characters.