The Ultimate CSV Delimiter Guide: Commas, Semicolons, Pipes & Tabs
Understand the differences between CSV delimiters, RFC 4180 rules, delimiter collision, and when to use Pipe or Tab delimiters.
What Makes a Great Delimiter?
CSV stands for Comma-Separated Values, but in reality, modern CSV workflows use a variety of characters to separate data fields. Depending on the software and regional conventions, using the right delimiter is the difference between an effortless import and an unreadable file.
1. The Comma (,) — Universal Standard
Defined by RFC 4180, the standard comma is supported by virtually every software library on Earth. However, if your fields contain natural sentences, street addresses, or formatted currency numbers (e.g. "$1,200.00"), the field MUST be enclosed in double quotes ("...").
2. The Semicolon (;) — European Spreadsheet Essential
In countries like Germany, France, Italy, and Romania, spreadsheets use a comma as the decimal separator (e.g., 19,99 €). If a standard comma delimiter were used in CSVs, numbers would break across two separate columns. For this reason, European editions of Microsoft Excel default to semicolons.
3. The Pipe (|) — The Data Engineer's Secret
When dealing with messy, user-generated content from web forms, pipes are by far the safest delimiter. The pipe symbol rarely appears in names, addresses, or descriptions, dramatically reducing the risk of parsing corruption.
Ready to Format Data Faster?
Experience instant, 100% private in-browser delimiter tools, SQL conversions, and file converters with zero server uploads.