Why does Excel save CSV with semicolons instead of commas?

Excel uses the List Separator setting from your Windows regional settings. In countries where the comma is used as a decimal separator (like Germany, France, and much of Europe), Excel defaults to semicolons for CSV to avoid ambiguity between comma-as-decimal and comma-as-delimiter. Change the regional setting or use an export tool to specify the delimiter explicitly.

What is the difference between comma, semicolon, tab, and pipe CSV?

All four are CSV files where each row is a line of text and fields are separated by a specific character. Comma is the most common default. Semicolon is used in European locales. Tab-separated (TSV) is better when data contains commas. Pipe is used in data exports where both commas and tabs appear inside field values.

How do I open a semicolon-delimited CSV in Excel correctly?

Do not double-click the file. Instead, open Excel first, go to Data > From Text/CSV, select the file, and in the Power Query preview change the delimiter from Comma to Semicolon before loading. This prevents all data appearing in a single column.

CSV Delimiter Guide: Comma vs Semicolon vs Tab vs Pipe

What Is a CSV Delimiter?

CSV stands for Comma-Separated Values, but the name is misleading. A CSV file is any plain text file where each row represents one record and each field within a row is separated by a consistent character — the delimiter. The delimiter can be a comma, a semicolon, a tab character, a pipe, or even a custom character depending on the exporting system.

Here is the same data in four formats:

Comma-delimited:

Name,Region,Revenue
Acme Corp,North,45000
Beta Ltd,South,32000

Semicolon-delimited:

Name;Region;Revenue
Acme Corp;North;45000
Beta Ltd;South;32000

Tab-delimited:

Name	Region	Revenue
Acme Corp	North	45000
Beta Ltd	South	32000

Pipe-delimited:

Name|Region|Revenue
Acme Corp|North|45000
Beta Ltd|South|32000

All four files contain the same data. Which format to use depends on what the receiving system expects and what characters appear inside the data values.

Why Excel Sometimes Uses Semicolons Instead of Commas

This is the most common source of confusion for Excel users. When you click Save As and choose CSV in Excel, the delimiter Excel uses depends on your Windows regional settings — specifically the List Separator setting in Region > Additional Settings.

In English-speaking countries (United States, United Kingdom, Australia), the decimal separator is a period and the list separator is a comma, so Excel exports comma-delimited CSV.

In many European countries (Germany, France, Spain, Italy, Netherlands), the decimal separator is a comma — so 1,5 means one and a half. Using a comma as a delimiter would create ambiguity because 1,5 could be interpreted as two fields (1 and 5) instead of one field (1.5). To avoid this, Windows sets the list separator to a semicolon in these locales, and Excel follows.

This means that a CSV file exported by a colleague in Germany may open as a single-column mess in Excel on a US machine, because Excel expects commas but the file contains semicolons.

When to Use Each Delimiter

Comma (,)

Use comma as the default for most situations. It is the most widely expected format for APIs, databases, CRMs, e-commerce platforms, accounting software, and data import tools. When in doubt, comma is the safest choice.

Problem: If your data values contain commas — such as addresses like "123 Main St, Suite 4" or descriptions like "Large, extra-large" — those values must be wrapped in quotes in the CSV. Most export tools handle this automatically, but always verify after exporting.

Semicolon (;)

Use semicolon when the file will be imported by a European system that expects it, or when the data contains many commas that would complicate quoting. Semicolons are also commonly used in SAP, some ERP systems, and several European data exchange standards.

Problem: Semicolon CSV files often open incorrectly in Excel on US machines. The recipient needs to import the file using Data > From Text/CSV and specify the semicolon delimiter explicitly.

Tab (\t)

Tab-delimited files (TSV — Tab-Separated Values) are the best option when values frequently contain commas but rarely contain tabs. Tab-delimited files also open correctly in Excel on most machines by default because Excel recognizes tab as a delimiter when double-clicking a .txt file.

Tab-delimited is commonly used in bioinformatics, academic datasets, and some analytics exports where data fields contain structured prose with commas.

Pipe (|)

Pipe-delimited files are used in data engineering, EDI (Electronic Data Interchange), and legacy database exports where both commas and tabs might appear inside field values. Because pipes rarely appear in human-readable text, they are a safe choice for complex, unstructured data.

Pipe files do not open automatically in Excel as columns — you need to import them using Text to Columns or Data > From Text/CSV and specify the pipe as a custom delimiter.

How to Open a Semicolon or Pipe CSV Correctly in Excel

If you double-click a semicolon-delimited CSV, Excel will display all the data crammed into column A with semicolons visible in the cells. To open it correctly:

Open Excel first. Do not open the file by double-clicking.
Go to Data > From Text/CSV.
Browse to the file and click Import.
In the preview, open the Delimiter dropdown and change it from Comma to Semicolon (or choose Custom and type | for pipe).
Verify the preview columns look correct, then click Load.

How to Export Excel as CSV With a Specific Delimiter

Excel's built-in Save As CSV always uses the Windows list separator, which you cannot override from within Excel. To export with a specific delimiter:

Use the Excel to CSV Converter to choose comma, semicolon, tab, or pipe from a dropdown before downloading.
Use Power Query: load the data, use Home > Close & Load To, and set the output format.
Use a VBA macro to write the file with a specific separator character.

The Excel to CSV Converter is the fastest option for one-time exports and works directly in your browser without uploading files to a server.

Quoting Rules in CSV Files

When a field value contains the delimiter character, that field must be wrapped in double quotes to prevent misinterpretation. For example, in a comma-delimited file:

Name,Address,Revenue
Acme Corp,"123 Main St, Suite 4",45000

If the value also contains double quotes, those quotes must be escaped by doubling them:

Product,Description
Widget,"The ""Original"" Widget"

These quoting rules are defined by RFC 4180 and most well-formed CSV files follow them. However, poorly generated CSV files sometimes omit quotes or escape incorrectly, which causes import problems. Always validate your CSV in a plain text editor before sending it to a system that will parse it automatically.

Checking a CSV File After Export

After exporting a CSV, open the file in Notepad or another plain text editor to confirm:

Fields are separated by the expected delimiter character.
Fields that contain the delimiter are wrapped in double quotes.
The first row is the header row with column names.
Accented characters or non-English text appear correctly (check the file encoding — UTF-8 is the safest).
The number of columns per row is consistent.

A quick count: if every row in your data should have 10 fields, run a word count of commas (or semicolons) per line. Each row should have exactly 9 delimiters (for 10 fields). More or fewer than that indicates a quoting or export problem.

Common CSV Delimiter Mistakes

Double-clicking a semicolon CSV on a US machine: The file opens with all data in one column. Import it properly via Data > From Text/CSV instead.
Assuming the delimiter is always a comma: Check the file in a text editor before importing into a system that expects a specific format.
Not quoting fields that contain the delimiter: This causes row-splitting errors during import and is easy to miss until data is already in the destination system.
Wrong encoding: CSV files with special characters need UTF-8 encoding. Saving with Windows-1252 encoding causes garbled characters in systems that expect UTF-8.
Using Save As to change delimiters: Excel always saves the Windows list separator regardless of the file name. Use a dedicated export tool when you need a specific delimiter.

Frequently Asked Questions

How do I change the CSV delimiter Excel uses by default?

Open Control Panel > Region > Additional Settings and change the List Separator from ; to , (or vice versa). Excel will use this character when saving CSV files via Save As. Note that this affects all programs on the computer that use the system list separator.

Is CSV always UTF-8?

No. Excel typically saves CSV files in the system default encoding, which is Windows-1252 on Windows machines. This encoding handles English characters correctly but can garble accented characters and non-Latin scripts. If the CSV will be used by a system that expects UTF-8, save with UTF-8 encoding using a text editor or the Excel to CSV Converter.

What is the difference between CSV and TSV?

TSV (Tab-Separated Values) is a CSV file where the delimiter is a tab character instead of a comma. TSV files have the extension .tsv or sometimes .txt. They are otherwise identical in structure to comma-delimited CSV. Excel opens .tsv and tab-delimited .txt files correctly when double-clicked, interpreting tabs as column separators.