Comma-Delimited CSV: What It Means & How to Fix It

What does “comma-delimited” mean?

A comma-delimited file is a plain-text file where each value is separated by a comma. It’s the most common form of CSV (Comma-Separated Values) and the de-facto standard for moving tabular data between systems — spreadsheets, databases, e-commerce stores, analytics platforms, APIs.

The format is dead simple. One line per row, commas between fields, optional header on the first row:

name,age,city
Ada,36,London
Linus,54,Helsinki
Grace,79,New York

When people say “CSV” they usually mean comma-delimited. But CSV files in the wild often use other delimiters — semicolons, tabs or pipes — depending on locale and the tool that produced them. That’s the source of most CSV headaches.

How to make a CSV comma-delimited

If you have a file using a different delimiter, here are the three fastest ways to convert it to commas.

1. Use the converter above (instant)

Paste your CSV (or upload it), the tool auto-detects the current delimiter, and you pick “Comma (,)” as the output. Download or copy the result. Files never leave your browser.

2. Save as comma-delimited in Excel

1. Open the file in Excel.
2. Go to File → Save As.
3. In the format dropdown, pick CSV UTF-8 (Comma delimited) (*.csv). Don’t pick the plain “CSV” option — on European locales, that uses semicolons.
4. Save. The new file is comma-delimited and UTF-8 encoded.

3. Save as comma-delimited in Google Sheets

1. Open the file in Google Sheets.
2. Go to File → Download → Comma-separated values (.csv).
3. Done — Google Sheets always exports with commas, regardless of locale.

Comma vs semicolon vs tab vs pipe — when to use each

CSV doesn’t have a single official delimiter. Different tools and regions have different defaults. Here’s a quick guide:

The same dataset, in all four formats:

# Comma
name,age,city
Smith John,42,New York

# Semicolon
name;age;city
Smith John;42;New York

# Tab
name	age	city
Smith John	42	New York

# Pipe
name|age|city
Smith John|42|New York

How to fix a broken comma-delimited file

If your CSV opens in Excel and everything sits in column A — or columns split unexpectedly partway through — one of these four issues is the cause:

The delimiter doesn’t match Excel’s locale

Excel uses your operating system’s “list separator” setting. On a French Windows install, that’s a semicolon. Open a comma file on a semicolon system, and Excel reads the whole row as one field. Fix: use the converter above to switch the delimiter, or change Windows’ Region → Additional settings → List separator.

Fields contain unescaped commas

A row like 1,Smith, John,42 looks like four fields, but the intent was three. The fix is to wrap multi-comma fields in double quotes: 1,"Smith, John",42. Most modern exporters do this automatically; hand-edited files often don’t.

Mixed line endings

CSVs from old Macs use \r; Windows uses \r\n; Linux uses \n. If only the first row appears, line endings are the issue. Open the file in VS Code, press the line-ending indicator at the bottom, and switch to LF or CRLF.

Wrong encoding

If accented characters look like café, the file is UTF-8 being read as Latin-1 (or vice versa). Open in a text editor, save as UTF-8, and try again.

When “comma-delimited” isn’t the right choice

Commas are the default, but they’re a bad fit when your data naturally contains commas — addresses, prices in European format (1,99 €), free-text fields. In those cases:

• Use tabs (TSV) if your data is mostly text with no tab characters. Cleanest output.
• Use pipes if the data has commas, tabs and quotes. Pipes almost never appear in real data.
• Use semicolons if you’re primarily exchanging files with European Excel users.

You can convert any of these formats back to standard comma-delimited with the tool above when you’re ready to ship the data downstream.

Related tools

Frequently asked questions

• What does 'comma-delimited' mean?

  Each value in the file is separated by a comma. 'name,age,city' is comma-delimited; 'name;age;city' is semicolon-delimited. Both are valid CSV variants.

• How do I save a CSV as comma-delimited in Excel?

  File → Save As → CSV UTF-8 (Comma delimited) (*.csv). On non-US locales, the regular 'CSV' option may save with semicolons.

• Why does Excel save my CSV with semicolons?

  Excel uses your Windows or macOS list separator. In most of Europe, this is a semicolon. To force commas, use 'CSV UTF-8 (Comma delimited)'.

• What's the difference between CSV and TSV?

  CSV uses commas; TSV uses tabs. TSV is safer when fields commonly contain commas.

• Is comma-delimited the same as RFC 4180?

  RFC 4180 is the formal CSV spec. It mandates commas as the delimiter and CRLF line endings.

• Can a comma-delimited CSV contain commas inside a field?

  Yes — wrap the field in double quotes. A literal double quote inside a quoted field is escaped as two double quotes.

• Does this tool upload my file?

  No. The conversion runs entirely in your browser using JavaScript.