CSV File Has Wrong Delimiter — How to Fix Semicolon or Tab Separated Files
Many CSVs use semicolons ; or tabs \t as separators, especially from European Excel defaults. Most import tools expect commas, causing broken imports.
What a delimiter is and why it matters
A delimiter separates columns. If the wrong character is used, the importer sees a single column with all data merged.
How to identify your delimiter
- Open the file in a plain‑text editor and look at the first data row.
- If you see
;or tabs between values, that’s your delimiter.
Why suppliers often export semicolons
European locales set the default list separator to a semicolon because the comma is used for decimal points.
How to fix in Excel (Text Import Wizard)
- Open Excel → Data → From Text/CSV.
- Choose your file and set the delimiter to “Semicolon”.
- Click “Load” and then “Save As” → CSV UTF‑8.
How to fix in Google Sheets
- Import the file → “Separator type: Custom” → type
;. - File → Download → CSV.
How to fix in Python
import pandas as pd
df = pd.read_csv('file.csv', sep=';')
df.to_csv('fixed.csv', index=False)
Fix it instantly with CSVFixer
Upload your CSV on the Delimiter Fix tool and get a clean comma‑separated file.
FAQ
- How do I know what delimiter my CSV uses? Open it in a text editor; the most common non‑comma character is the delimiter.
- Why does my CSV open in one column? The importer expects commas; any other delimiter keeps the whole row as one field.
- Can Excel export comma‑separated files? Yes – choose “CSV UTF‑8 (Comma delimited)”.