Comparison
Comma vs semicolon vs tab delimiters explained
Why different systems use different separators and how to handle each.
Dec 28, 20244 min read
The C in CSV stands for comma, but commas aren't the only delimiter. Understanding why helps you work with any file.
Comma: the default
Commas are the original CSV delimiter. They work well when your data doesn't contain commas. When it does, values need quoting.
- Most common delimiter
- Standard in US/UK systems
- Requires quoting for data with commas
- RFC 4180 standard
Semicolon: the European choice
In countries where commas are decimal separators (1.234,56 vs 1,234.56), semicolons prevent ambiguity.
- Common in European exports
- Avoids conflict with decimal commas
- Excel uses based on locale
- Often seen in SAP exports
Quick CTA
Auto-detect delimiters
Readable CSV figures out your delimiter automatically. Just drop the file.
Try itTab: the safe choice
Tabs rarely appear in real data, making them a safe delimiter. Tab-separated values (TSV) avoid most quoting issues.
- Rarely conflicts with data
- No quoting usually needed
- Common in bioinformatics
- Easy to see in text editors
Pipe and others
Some systems use pipes (|), carets (^), or other characters. These are less common but work the same way.
- Pipes in legacy systems
- Custom delimiters for special cases
- Always document non-standard choices
- Tool support varies
Key takeaway
There's no wrong delimiter, just mismatched expectations. Know what your file uses and what your tools expect.