CSV Semicolon vs Comma: Which One Should You Use?

A CSV can use commas or semicolons between columns. Both are normal.

Semicolons are common in places where a comma is already used inside numbers, such as 12,50. Using a semicolon between fields makes those numbers easier for spreadsheet programs to read correctly.

This guide is about choosing and changing the separator. If your letters look broken, such as José instead of José, use the CSV strange-character guide instead. If the whole file opens in one spreadsheet column, follow the one-column CSV diagnosis before changing the file.

Why some CSV files use semicolons

Imagine this row:

Product;Price;Quantity
Notebook;12,50;2

The comma is part of the price. The semicolon separates the columns.

That is why many European spreadsheet and business systems export CSV files with semicolons. It is a regional choice, not a broken file.

When should you use comma or semicolon?

For a typical English-language export that uses a decimal point, comma-separated data is natural:

Product,Price,Quantity
Notebook,12.50,2

The semicolon example above solves a different regional problem: it keeps 12,50 intact when the comma belongs to the number itself.

The best choice is the one your destination expects. If you are sending a file to another person or system, check their import settings instead of guessing.

Nablyx does not treat every punctuation mark as a separator. Its CSV processing checks the file for a consistent delimiter and considers comma, semicolon, tab, and pipe as candidates. The detected input separator is only the starting point: you can still choose a different output separator when the receiving system requires one.

How to convert comma and semicolon CSV files

1. 01

   Add the CSV

   Choose the CSV from your device.

2. 02

   Check the input separator

   If the detected columns look right, keep the current choice. Otherwise choose comma or semicolon yourself.

3. 03

   Choose the output separator

   Pick the separator expected by the program or person receiving the file.

4. 04

   Run the conversion

   The tool writes a new CSV with the chosen separator while keeping the field values themselves unchanged.

5. 05

   Open the result in the destination app

   Check that the columns split correctly and that a few important numbers still look right.

What happens to your file?

The CSV stays on your device while the conversion runs. It is not uploaded to our servers.

Changing the separator does not rewrite the meaning of your values. A price written as 12,50 stays 12,50; only the character between fields changes.

That conversion is parser-based rather than a blind character replacement. A comma inside a quoted field stays part of that field while the actual column separators are rewritten, which is why confirming the input separator matters before converting.

The original file is not replaced. You download a new CSV and can compare it with the source before using it.

Practical limits

The conversion accepts one CSV up to 150 MB. The cap follows the same registry method: the displayed limit comes from the shipped tool registry and is backed by first-party browser measurement. The first-party measurement evidence is recorded in docs/tool-audit/batch-a.md.

Changing comma to semicolon, or semicolon to comma, does not change regional number formats. If the destination expects 12.50 instead of 12,50, that is a separate data-formatting job.

Excel can also use your computer's regional settings when a CSV is opened directly. If a file lands in one column, importing it and choosing the separator manually is often enough.

If the characters themselves are wrong, changing the separator will not fix them. Use the encoding repair tool for that problem.

Simple example

Before:

name;city
Ana;Madrid
Leo;Paris

After changing the separator to comma:

name,city
Ana,Madrid
Leo,Paris

Convert your CSV separator

See the transformation

Broken text and mixed separators become one reliable CSV

Repair garbled text and inconsistent separators while leaving the actual cell values alone.

Input

name;city;note

José;München,West;"ready"

Chloë|Zürich;review

Result

name;city;note

José;"München,West";ready

Chloë;Zürich;review