← All tools

Change the CSV delimiter

Turn a semicolon-separated CSV into a comma-separated one, or the reverse. Your file never leaves this computer.

Drop your CSV file here or click to choose. To paste text instead, use the link below.

Comma or semicolon?

CSV stands for "comma-separated values", but not every country uses commas. In languages where the decimal separator is a comma, such as German, French and Turkish, Excel saves CSV files with semicolons so amounts like 1.250,50 stay in one cell.

The trouble starts when you hand that file to a system that expects commas. Upload a semicolon-separated CSV to Google Sheets, an online shop, an email marketing tool or an English-language Excel and every row shows up in a single column. The same happens the other way round when a comma-separated file is double-clicked in a German or French Excel.

What this tool does

It detects the file's current delimiter automatically and rewrites the file with the one you choose. If a cell contains the delimiter character, such as a comma in an address field, the cell is wrapped in quotes so the columns do not shift. The row and column counts appear in the preview, so you can check before you download.

You can also convert to tab-separated files if needed; some older systems and database tools prefer that format.

Another way to open it correctly in Excel

Instead of double-clicking the file, use Data > From Text/CSV in Excel and choose the delimiter yourself. But if you are giving the file to someone else or to another system, setting the right delimiter up front is simpler.

Privacy

Conversion happens in your browser. Your file is never uploaded to a server or stored.

How to use it

  1. Drop your CSV file into the box. The current delimiter is detected automatically.
  2. In the Output section the Output delimiter is preset to comma (or pick the one you need).
  3. Check the preview and download the CSV.

Frequently asked questions

Why does Excel use semicolons in some countries?

In languages where the decimal separator is a comma, Excel uses a semicolon as the CSV delimiter. For programs that expect comma-separated CSV you can change it here.

What if a cell contains a comma?

The tool wraps such cells in quotes automatically, so columns do not shift.

Can I convert a tab-separated file too?

Yes. You can convert in any direction between tab, semicolon, comma and pipe.

Related guide

Related tools