What Is a CSV Delimiter?
A delimiter is the character that separates fields in a CSV-style text file. Despite the name “comma-separated values,” real-world files also use semicolons, tabs, and pipes.
If the reader expects commas and the file uses semicolons, every row collapses into one column. That is a delimiter problem—not necessarily bad data.
| Delimiter | Common label | Example |
|---|---|---|
| , | Comma CSV | Ada,UK,34 |
| ; | Semicolon CSV | Ada;UK;34 |
| Tab | TSV | Ada\tUK\t34 |
| | | Pipe-delimited | Ada|UK|34 |
Why Delimiters Vary by Region and Tool
In many European locales, comma is the decimal separator (2,50). Spreadsheet apps may therefore use semicolon as the list separator when saving “CSV.”
US and UK teams often assume comma forever. Cross-border collaboration is where delimiter bugs explode.
- Excel locale list-separator settings change export behavior.
- Some ETL tools default to pipe or tab for safer parsing.
- TSV is preferred when fields contain many commas (addresses, titles).
Comma vs Semicolon vs Tab vs Pipe
Choose the delimiter that matches the destination—and document it when you share files.
| Delimiter | Best when | Watch outs |
|---|---|---|
| Comma | General US/UK interchange and many APIs | Fields with commas need quoting |
| Semicolon | Locales where comma is decimal | US Excel users may mis-open the file |
| Tab (TSV) | Text-heavy fields and some database exports | Invisible characters are harder to spot in editors |
| Pipe | Logs and some enterprise feeds | Less familiar to casual spreadsheet users |
Quoting still matters
Whatever delimiter you choose, fields containing that delimiter, quotes, or line breaks should be quoted. RFC 4180 describes the common quoting style for comma-separated files.
name,city,notes
"Nguyen, Minh",Toronto,"VIP, renew soon"Step-by-Step: Detect and Fix the Wrong Delimiter
Use this checklist before blaming the importer.
- Open a copy in a plain text editor and look at the first data line.
- Count whether commas, semicolons, tabs, or pipes separate fields.
- Preview the file in the Online CSV Editor.
- If columns are wrong, normalize the delimiter before conversion.
- Use the CSV to Delimited Converter when you need tab, pipe, semicolon, or another separator on purpose.
- Re-check in Excel or the destination system after export.
Example: semicolon file mistaken for comma CSV
This file is still often emailed as “.csv,” but comma-splitting will fail:
product;price;currency
Tea;2,50;EUR
Coffee;3,20;EURReal-World Examples
Delimiter mismatches are one of the most common cross-team CSV failures.
EU export opened in US Excel
A Berlin ops team exports semicolon CSV. A New York analyst double-clicks it and sees one column. Explicit import with semicolon selected fixes it in seconds.
Address lists that need TSV
A mailing list contains commas inside street addresses. Switching to tab-separated values reduces quoting pain for downstream scripts.
Pipe-delimited warehouse feed
A WMS emits pipe-delimited text. Converting to comma CSV makes the feed easier for business users, while engineering keeps the pipe original for automation.
Common Mistakes
Delimiter bugs are usually process bugs.
- Trusting the .csv extension as proof of commas.
- Find-and-replace commas blindly, destroying decimal numbers.
- Forgetting to quote fields after changing delimiters.
- Mixing TSV content with a .csv extension and no documentation.
- Converting to JSON/Excel before confirming columns parse correctly.
Best Practices
Make delimiter expectations explicit in every shared dataset.
- Prefer comma + quoting for general interchange unless locale requires otherwise.
- Use TSV when fields are text-heavy.
- State delimiter and encoding in the filename or README when needed.
- Preview before every conversion.
- Keep an original copy before delimiter rewrites.
Why Use Convert CSV Online?
Delimiter issues need fast visual confirmation. Convert CSV Online is free, browser-based, and requires no account for everyday conversions. Preview files in the Online CSV Editor, then use the CSV to Delimited Converter when you need a different separator. These workflows run client-side in the browser on Windows, macOS, and Linux.
Fix your delimiter now
Open the file online, confirm how fields are separated, and export a clean CSV your destination system can parse.
Conclusion
CSV delimiters are a contract. Comma is common, not universal. Detect first, normalize second, convert third.
Next: merge CSV files—when multiple tables need to become one.
FAQ
What delimiter does CSV use?
Comma is the classic delimiter, but many “CSV” files use semicolons, tabs, or pipes depending on locale and tool settings.
Why does Excel save CSV with semicolons?
In some locales, Excel uses the regional list separator. Where comma is the decimal mark, semicolon is often used as the field separator.
How do I know which delimiter my file uses?
Open the file in a text editor and inspect the first lines, or preview it in an Online CSV Editor and see whether columns split correctly.
Is TSV the same as CSV?
TSV is tab-separated values—a closely related delimited text format. People often group it with CSV colloquially, but the separator is a tab rather than a comma.
Can I convert between delimiters online?
Yes. Use a delimiter conversion tool such as the CSV to Delimited Converter on Convert CSV Online after previewing your data.
Do quotes matter if I change delimiters?
Yes. Fields containing the chosen delimiter, quotes, or line breaks should be quoted so parsers do not split them incorrectly.
References
Convert your CSV in the browser
Preview, clean, and convert CSV files free with Convert CSV Online—no installation and no account required for everyday conversions.