CleanCSV

Change the Delimiter of a CSV File

Convert between comma, semicolon, tab and pipe separated files. The current delimiter is detected for you and quoting is handled correctly.

Free, no sign-upFiles never leave your deviceCSV, Excel & JSON

CSV delimiter converter

No account. No uploads. Just clean data.

100% in your browser
1

Upload your file

Drop your CSV or Excel file here

or browse your device. You can select several files at once.

CSV, TSV, TXT, XLSX, XLS, ODS and JSON · up to 50.0 MB and 250,000 rows

Your files never leave your device.

Step by step

How to use this tool

  1. 1

    Drop the CSV, TSV or TXT file into the tool above. A note shows which separator was detected.

  2. 2

    In the download section choose CSV with Comma, Semicolon or Pipe, or choose TSV for tab-separated output.

  3. 3

    Download. Values that contain the new separator, quotes or line breaks are quoted automatically.

Why delimiters differ

In countries that write decimals with a comma (1,5), Excel saves CSV files with semicolons so numbers are not split in two. Systems that expect commas then read each row as a single column. Converting the delimiter fixes that without touching the values.

Do not use find and replace for this

Replacing every ; with , in a text editor breaks any value that contains a comma or semicolon. Converting here parses the file properly first and then writes it again with correct quoting.

Decimal commas

Changing the delimiter does not change numbers like 1,50. If the target system needs 1.50, use Find & replace on the amount column with Regular expression on: find ^(\d+),(\d+)$ and replace it with $1.$2.

Frequently asked questions

How do I know which delimiter my file uses?

Upload it and the detected separator is noted under the file. Comma is assumed when nothing else is found.

Can I convert CSV to TSV?

Yes. Choose TSV in the download section.

Will Excel open the result correctly?

Comma-separated files open correctly in Excel with English regional settings. For European settings, download with semicolons or as an .xlsx file instead.