Short Answer
In everyday CSV talk, separator and delimiter mean the same thing: the character that splits fields in a row. "Delimiter" is the more common technical term (field delimiter). "Separator" shows up in UI labels ("list separator") especially in Windows and Excel regional settings.
If someone says "change the separator" or "set the delimiter," they almost always want you to switch between comma, semicolon, tab, or pipe.
Common Field Delimiters
Pick based on locale and data content—not habit alone.
| Delimiter | Typical use | Watch out for |
|---|---|---|
| Comma (,) | US/UK default CSV | Commas inside amounts or addresses |
| Semicolon (;) | Many EU Excel exports | US tools assuming comma |
| Tab (\t) | TSV / spreadsheet paste | Invisible; easy to mislabel as .csv |
| Pipe (|) | Data warehouses, logs | Pipes in free text (rare but real) |
Excel’s "List Separator" Setting
On Windows, Excel often follows the regional list separator. In locales where the decimal mark is a comma (1,23), Excel frequently uses semicolon as the CSV field separator so decimals do not collide with commas.
That is why the same "Save as CSV" produces commas in the US and semicolons in Germany or France.
Delimiter vs Decimal Separator vs Thousands Separator
Do not confuse three different characters.
| Concept | Role | Examples |
|---|---|---|
| Field delimiter | Splits columns | , ; tab | |
| Decimal separator | Splits whole/fraction in numbers | . or , |
| Thousands separator | Groups digits for humans | , or . or space |
Machine-friendly amounts
For interchange, prefer plain decimals with . (e.g., 1234.56) and no thousands separators—regardless of field delimiter.
Step-by-Step: Fix a Wrong Delimiter
When everything lands in one column, the delimiter is wrong.
- Open the file in the Online CSV Editor or a text editor.
- Look at the first data line: which character repeats between fields?
- Re-import or convert with that delimiter set explicitly.
- Or rewrite the file with the CSV to Delimited Converter to a standard comma CSV.
- Verify column count matches the header.
Record Separators (Rows)
Rows are usually separated by newlines (LF or CRLF). That is sometimes called a record delimiter. Quoting allows newlines inside fields without starting a new row—another reason "just split on newline" is unsafe.
Real-World Examples
Delimiter mismatches in production.
EU ERP → US SaaS
Semicolon CSV from SAP opened as one column in a US importer. Converting to comma UTF-8 CSV fixed onboarding.
Warehouse pipe files
Nightly extracts used | because descriptions contained commas. Downstream BI expected CSV—documented delimiter unblocked the job.
"CSV" that was TSV
A vendor named the file .csv but used tabs. Detecting the real delimiter avoided a week of blame on the parser.
Common Mistakes
Language confusion causes real bugs.
- Assuming every .csv is comma-separated.
- Changing field delimiter without updating decimal rules.
- Saving TSV with a .csv extension.
- Forgetting to quote fields that contain the delimiter.
- Relying on Excel auto-detect instead of an explicit setting.
Best Practices
Write the delimiter into the contract.
- Document delimiter + encoding + decimal style.
- Prefer comma + UTF-8 for global APIs when you control the format.
- Accept semicolon when EU Excel users are the source—detect and normalize.
- Use .tsv when the delimiter is tab.
- Validate column counts on every load.
Why Use Convert CSV Online?
Convert CSV Online is free, browser-based, and requires no account for everyday conversions. Preview delimiters in the Online CSV Editor, normalize with CSV to Delimited, and export Excel-ready files. Client-side workflows work on Windows, macOS, and Linux browsers.
See the separator instantly
If the preview shows one column, you found the problem before the database did.
Conclusion
Separator and delimiter are two names for the character that splits CSV fields. Know which one your file uses, do not confuse it with decimal separators, and normalize explicitly when systems disagree.
FAQ
Is a CSV separator the same as a delimiter?
In practice yes—both refer to the character that separates fields (comma, semicolon, tab, pipe). "Delimiter" is the usual technical term.
Why does my CSV use semicolons?
Excel in many European locales uses semicolon as the list separator so commas can remain decimal marks.
What delimiter should I use?
Comma for most international interchange; semicolon when your audience is EU Excel-centric; tab for TSV; pipe when fields contain many commas.
What is the difference between delimiter and decimal separator?
The delimiter splits columns. The decimal separator splits the integer and fractional parts of a number. They must not fight each other.
How do I change a CSV delimiter?
Re-export with the desired separator, or use a converter such as CSV to Delimited on Convert CSV Online.
Why does Excel put my CSV in one column?
Excel guessed the wrong delimiter. Import via Data → From Text/CSV and set the separator manually.
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.