Papiral
PixelForge
Tabular
TabularHow to Change the Delimiter in a CSV File
3 methods — browser tool, Excel, and Python
CSV files use commas by default, but some systems export semicolons, tabs, or pipes instead. If your file's delimiter doesn't match what your import target expects, you'll end up with all data in a single column. Here's how to convert between delimiters.
Method 1: Using Tabular (browser, instant)
- 1Go to the Convert Delimiter tool on Tabular.
- 2Upload your CSV file.
- 3Select the current delimiter (comma, semicolon, tab, pipe) — Tabular auto-detects it.
- 4Select your target delimiter.
- 5Click Run and download the converted file.
Tabular correctly handles quoted fields containing the delimiter character — for example, a cell containing 'Smith, John' won't be split incorrectly when converting delimiters.
Method 2: Using Excel
- 1Open the file in Excel using the Import Wizard: Data > From Text/CSV.
- 2In the import dialog, manually select the correct delimiter (semicolon, tab, etc.).
- 3Complete the import.
- 4To save with a comma delimiter: File > Save As > CSV (Comma delimited).
- 5To save with a tab delimiter: File > Save As > Text (Tab delimited).
Excel's 'Save As CSV' always uses a comma. For semicolons or pipes, use the Python method.
Method 3: Using Python
- 1Install pandas: pip install pandas
- 2Run the script below.
python
import pandas as pd
# Read with current delimiter (change sep= to match your file)
df = pd.read_csv("input.csv", sep=";") # semicolon-delimited
# Write with new delimiter
df.to_csv("output.csv", sep=",", index=False) # comma-delimited
# Common delimiter options:
# sep="\t" → tab (TSV)
# sep="|" → pipe
# sep=";" → semicolonFrequently asked questions
How do I know what delimiter my CSV file uses?
Open the file in a plain text editor (Notepad on Windows, TextEdit on Mac, or VS Code). Look at the first line — the character separating the column headers is the delimiter. Common ones: comma (,), semicolon (;), tab (whitespace), pipe (|).
What is a TSV file?
TSV stands for Tab-Separated Values. It's a CSV variant that uses tab characters instead of commas as the delimiter. TSV files often have a .tsv extension but may also be .txt. Use Tabular's Convert Delimiter tool to convert TSV to CSV.
My file uses semicolons but Excel shows all data in one column. How do I fix it?
Excel uses your system's regional settings to determine the default delimiter. On European Windows systems, semicolon is the default — but on US systems, Excel defaults to comma. Use Data > From Text/CSV and manually select Semicolon as the delimiter instead of double-clicking the file.
Can a CSV file use multiple delimiters?
No — a valid CSV file uses exactly one delimiter consistently throughout. If your file mixes delimiters, it's malformed. Use Tabular's CSV Validator to detect inconsistencies, then fix the source of the data.
Ready to try the fastest method?
Convert your CSV from comma-separated to tab, semicolon, or pipe-delimited format — instantly.
Convert Delimiter — free