CSV Delimiters Explained: Commas, Tabs, and More

While "CSV" stands for Comma-Separated Values, not all CSV files use commas as their delimiter. Understanding different delimiter options is crucial for working with data from various sources and regions.

What is a Delimiter?

A delimiter is a character that separates individual values (fields) within a row of data. In a CSV file, the delimiter tells software where one field ends and another begins.

text

Name,Email,Age    ← Comma delimiter
Name	Email	Age    ← Tab delimiter
Name;Email;Age    ← Semicolon delimiter

Common Delimiters

Comma (,)

The most common delimiter, especially in English-speaking countries.

John,john@example.com,28,New York

Use when: Default choice for most applications, especially US-based systems.

Watch out: Data containing commas must be quoted.

Tab (\t)

Creates TSV (Tab-Separated Values) files. Common when copying from spreadsheets.

John	john@example.com	28	New York

Use when: Data may contain commas, or copying from Excel/Google Sheets.

Advantage: Tabs rarely appear in actual data, reducing escaping needs.

Semicolon (;)

Standard in many European countries where comma is used as decimal separator.

Product;Price;Quantity
Widget;19,99;100

Use when: Working with European data or decimal numbers with commas.

Common in: Germany, France, Italy, Spain, Netherlands, and other EU countries.

Pipe (|)

Less common but useful when data contains both commas and semicolons.

John Smith|123 Main St, Apt 4|New York

Use when: Data contains commas, semicolons, or needs clear visual separation.

Common in: Database exports, log files, legacy systems.

Space

Used in fixed-width or simple data files.

John 28 NYC
Jane 34 LA

Use when: Simple data without spaces in values.

Warning: Problematic if field values contain spaces (e.g., "New York").

Regional Differences

The choice of delimiter often depends on regional settings, particularly the decimal separator:

Region	Decimal Separator	CSV Delimiter
USA, UK, Australia	Period (.)	Comma (,)
Germany, France, Spain	Comma (,)	Semicolon (;)
Netherlands, Belgium	Comma (,)	Semicolon (;)
Brazil, Portugal	Comma (,)	Semicolon (;)

Why this matters: In countries using comma as decimal separator, "19,99" means 19.99 (the price). Using comma as CSV delimiter would break the data: Widget,19,99 would be parsed as three fields instead of two.

How to Detect the Delimiter

When you receive a CSV file and aren't sure which delimiter is used:

Open in a text editor: View the raw file to see which character separates values
Check the file extension: .tsv files typically use tabs, .csv usually means comma or semicolon
Look at the data: Count occurrences of potential delimiters. The correct one usually appears consistently
Try different options: Most spreadsheet apps let you specify the delimiter when importing

Handling Delimiters in Data

What if your data contains the delimiter character? CSV handles this through quoting:

csv

Name,Address,City
John,"123 Main St, Apt 4",New York
Jane,"456 Oak ""Ave""",Los Angeles

Rules for quoting:

Wrap the field in double quotes if it contains the delimiter
Wrap the field in double quotes if it contains a line break
If the field contains quotes, double them (" becomes "")

Choosing the Right Delimiter

✓

Use comma for general-purpose CSV files, especially for US audiences or APIs

✓

Use semicolon when working with European data or when data contains commas

✓

Use tab when copying from spreadsheets or when data might contain both commas and semicolons

✓

Use pipe for database exports or when all other common delimiters appear in your data

Converting Between Delimiters

Need to change the delimiter in your file? Our Text to CSV Converter lets you:

Input data with any delimiter (tab, space, comma, semicolon, pipe, or custom)
Output as standard comma-separated CSV or semicolon-separated CSV
Handle proper quoting and escaping automatically

Key Takeaways

CSV files can use different delimiters despite the name
Comma is standard in US/UK; semicolon is standard in Europe
Regional decimal separators influence delimiter choice
Use quoting to handle delimiter characters within data
Tab is the safest choice when delimiter content is uncertain