What is a delimiter?
A delimiter is a separator character. It tells the computer where one column ends and the next begins. Without delimiters, CSV files would just be long lines of text with no structure.
Simple example:
With comma delimiter:
John,Smith,john@example.com
The commas separate: First Name | Last Name | Email
Without delimiters (just text):
JohnSmithjohn@example.com
No separation. What's the first name? No way to tell.
The computer reads the file character by character. When it hits the delimiter (e.g., a comma), it knows to move to the next column.
Why delimiters matter
If your data has the wrong delimiter, the entire file breaks. Your spreadsheet software or database importer won't understand where the columns are, and data gets mixed up or lost.
Data ends up in the wrong columns
If a file uses semicolons but the importer expects commas, all the data might end up in one column.
Imports fail completely
Some systems detect the wrong delimiter and reject the entire file with an error.
Data gets corrupted
If names or addresses contain the delimiter character, the parser splits them incorrectly.
Invisible problems
Sometimes wrong delimiters don't cause immediate errors, but create subtle data problems you discover later.
Common CSV delimiters
CSV stands for "Comma-Separated Values," but files don't always use commas. Here are the most common delimiters:
Comma (,)
Most common. Used by Excel, Google Sheets, most systems.
Example:
John,Smith,john@example.comPotential issues:
Problems if data contains commas (e.g., 'Smith, Jr.')
Semicolon (;)
European systems (Excel in Europe uses this). Some databases export this.
Example:
John;Smith;john@example.comPotential issues:
Rarely needed in North America. Easy to confuse with comma.
Tab (⇥)
Tab-separated values (TSV). Excel pastes data with tabs. Some databases use this.
Example:
John Smith john@example.comPotential issues:
Invisible in text editors. Hard to see if it's actually there.
Pipe (|)
Technical/database exports. Used when data frequently contains commas.
Example:
John|Smith|john@example.comPotential issues:
Less common. Not everyone recognizes it.
Space
Rarely used officially, but sometimes exported from old systems.
Example:
John Smith john@example.comPotential issues:
Very fragile. Data with spaces breaks immediately.
Default is comma
If a file is called "data.csv" and doesn't specify a delimiter, assume it uses commas. That's the standard.
How to identify your file's delimiter
You need to know which delimiter your file uses before you can import it correctly.
Method 1: Open in a text editor
- 1Right-click the CSV file
- 2Choose 'Open with' → Notepad (or any text editor)
- 3Look at the first row. What character separates the values?
- 4If you see commas: comma delimiter. Semicolons: semicolon. Etc.
Example in text editor:
First Name,Last Name,Email,Phone John,Smith,john@example.com,(555) 123-4567
Clear: commas separate columns
Method 2: Open in Excel and check
- 1Open the file in Excel
- 2If data is in multiple columns, the delimiter was recognized correctly
- 3If all data is in one column, Excel didn't recognize the delimiter
All data in one column = wrong delimiter detected
Method 3: Check the export settings
If you're exporting from a database or tool:
- • Look for export options that say "delimiter" or "field separator"
- • Check documentation for the software you're exporting from
- • Ask the system what delimiter it's using
Common delimiter problems and how to spot them
All data in one column
Likely cause:
File uses a delimiter that the importer doesn't recognize
Fix:
Manually specify the correct delimiter in import settings
Names or addresses get split across columns
Likely cause:
Data contains the delimiter character (e.g., 'Smith, Jr.' contains a comma)
Fix:
Use quotes around fields with commas, or choose a different delimiter
Data looks correct in Excel but fails on import
Likely cause:
Excel auto-detected the delimiter but your system uses a different one
Fix:
Open in text editor to see actual delimiter, then specify it explicitly
Random characters or symbols appear
Likely cause:
File encoding mismatch combined with wrong delimiter detection
Fix:
Save file as UTF-8 and specify delimiter explicitly
How to fix delimiter problems
Option 1: Specify delimiter in import dialog
Most importers (Excel, databases, web tools) have a "delimiter" option:
- 1Start the import
- 2Look for 'Delimiter', 'Field Separator', or 'Column Separator' option
- 3Select the correct delimiter (comma, semicolon, tab, pipe)
- 4Preview the data. It should split into correct columns
- 5Click Import/Load
Option 2: Convert the file
If you need to change delimiters:
- 1Open the file in Excel
- 2Data should be split into columns (if not, use import dialog to specify delimiter)
- 3Save as CSV (Excel will use commas by default)
- 4Now the file uses a standard comma delimiter
Option 3: Use a text editor (advanced)
For power users, find-and-replace in a text editor:
- 1Open file in text editor (Notepad, VS Code)
- 2Use Find and Replace (Ctrl+H)
- 3Find the old delimiter, replace with new one
- 4Save the file
Best practice
Always use comma as your delimiter unless you have a specific reason not to. It's the standard, and most systems expect it. Only use semicolons, tabs, or pipes if your data frequently contains commas.
Delimiter checklist
Import data without delimiter problems
Import Builder automatically detects delimiters and splits your data into the correct columns. No manual delimiter selection needed.
Start building free