Change Delimiter in TSV Files Online
Change the delimiter in TSV files — switch from comma to pipe, semicolon, tab, or any custom character — in your browser.
How to change Delimiter in TSV files
- Drop your CSV file onto the upload area. The current delimiter is detected automatically and the first 200 rows are previewed as a table.
- Under Output delimiter, choose Comma, Semicolon, Pipe or Tab, or choose Custom and type a single character.
- Click Download with new delimiter. The whole file is written out again with the new separator.
- Check the file name. Tab output is saved with a .tsv extension and every other choice with .csv.
Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.
Worked example
A hardware supplier exports its price list as a comma-separated CSV. The warehouse system of a German partner only imports semicolon-separated files.
Input (TSV)
sku description unit_price stock
BLT-M6 Bolt, M6 x 20 0.12 5400
NUT-M6 Hex nut M6 0.05 12000
WSH-M6 Washer; flat, M6 0.03 8000
SCR-4 Wood screw 4 x 40 0.09 Settings
- Output delimiter: Semicolon ;
Result
| sku | description | unit_price | stock |
|---|---|---|---|
| BLT-M6 | Bolt, M6 x 20 | 0.12 | 5400 |
| NUT-M6 | Hex nut M6 | 0.05 | 12000 |
| WSH-M6 | Washer; flat, M6 | 0.03 | 8000 |
| SCR-4 | Wood screw 4 x 40 | 0.09 | NULL |
The values do not change, only the separator. The header line becomes sku;description;unit_price;stock. "Bolt, M6 x 20" no longer needs quotes because a comma is now ordinary text. "Washer; flat, M6" contains the new delimiter, so it is written as "Washer; flat, M6" in double quotes. The missing stock value becomes an empty field at the end of the last line.
Frequently Asked Questions
Which delimiters can I choose?
Comma, semicolon, pipe and tab are one-click presets. Custom accepts any single character you type, such as ^ or ~. The download button stays disabled until you enter one.
What happens if a value already contains the new delimiter?
That field is wrapped in double quotes, and any double quotes inside it are doubled. Fields that contain a line break are quoted too. Other fields are written without quotes.
Does the preview show the new delimiter?
No. The preview is the parsed table, which looks the same whatever the separator. The new delimiter is applied only when you download.
Related Tools
Trim Whitespace in CSV Files Online
Trim leading and trailing whitespace from all text columns in CSV files, directly in your browser. No upload required.
Convert Encoding of CSV Files Online
Detect and convert the character encoding of CSV files directly in your browser. Switch between UTF-8, Latin-1, Windows-1252, and more — no upload required.
Repair CSV Files Online
Repair malformed CSV files directly in your browser. Fix unbalanced quotes, inconsistent column counts, BOM markers, and mixed line endings — no upload required.
Change Delimiter in CSV Files Online
Change the delimiter in CSV files — switch from comma to pipe, semicolon, tab, or any custom character — in your browser.
TSV Viewer Online
View and inspect TSV files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.
Convert TSV to Parquet Online
Convert TSV files to Parquet format directly in your browser. No upload required — your data never leaves your device.