Your data is processed in your browser and never uploaded.
This CSV delimiter converter changes the separator in a CSV file, for example from commas to semicolons so the file opens correctly in a European Excel, or from semicolons to commas for an import that expects commas.
How to use the CSV Delimiter Converter
- 1 Paste your CSV or click Open file.
- 2 Leave the current separator on Detect automatically, and choose the new separator.
- 3 Download the converted CSV or copy it.
Worked examples
Input: name,price / "Pen, blue",1.20
Result: name;price / Pen, blue;1.20
The comma inside the value no longer needs quotes.
Input: name;price / Pen;1,20
Result: name,price / Pen,"1,20"
The decimal comma is quoted so it stays one value.
Why CSV files use different separators
"Comma-separated values" do not always use commas. In countries where the comma is the decimal separator (2,50 rather than 2.50), Excel saves and expects CSV files separated by semicolons. Many databases export with tabs, and some systems use the pipe character. When the separator does not match what the next program expects, everything ends up in one column.
How the CSV delimiter converter works
The converter parses the file properly instead of simply replacing characters. That matters, because a plain search-and-replace would also change commas inside quoted values and inside numbers, and corrupt the data. Here the file is read with PapaParse, which understands quotes, escaped quotes and line breaks inside values, and written back with the new separator. A value is quoted only when it needs to be: when it contains the new separator, a quote or a line break.
Options
- Current separator: detected automatically, or choose it if the guess is wrong.
- New separator: semicolon, comma, tab, pipe or any other character.
- Line endings: Windows (CRLF) is what Excel writes; Mac and Linux tools use LF.
- Put every value in quotes: some importers require every field quoted.
Private by design
The file is read and converted by your own browser. Nothing is uploaded to a server, so it is safe to use with customer lists, finance exports and other internal data. Large files simply take a moment longer on a slower computer.
Frequently asked questions
Why does Excel put my CSV in one column?
Its separator does not match your Excel language settings. Convert commas to semicolons (or the other way round) and the columns will split.
Will commas inside values break the file?
No. The file is parsed, not searched and replaced, so commas inside quoted values stay where they belong.
What is a TSV file?
A CSV that uses tabs as the separator. Choose Tab as the new separator to create one.
Is my file uploaded?
No. The conversion happens in your browser.
Related tools
Excel to CSV Converter
Convert Excel spreadsheets (XLSX, XLS, ODS) to CSV with a comma, semicolon or tab separator. Pick the sheet, preview and download.
CSV to Excel Converter
Convert CSV to an Excel XLSX file. The separator is detected automatically, numbers stay numbers and leading zeros are kept.
Excel to JSON Converter
Convert an Excel sheet to JSON: an array of objects keyed by the header row, or an array of rows. Numbers and dates keep their types.
JSON to Excel Converter
Convert JSON to Excel or CSV: arrays of objects become rows and columns, nested fields are flattened into dot-named columns.
Excel to HTML Table Converter
Convert an Excel sheet into clean HTML table code with a header row, ready to paste into a website, email or CMS.
CSV Column Filter & Duplicate Remover
Keep only the CSV columns you need and remove duplicate and empty rows, with case-insensitive matching.