CSV ⇄ TSV
Switch between comma, tab and semicolon separated files.
- 1Upload
- 2Settings
- 3Download
How to use CSV ⇄ TSV
About CSV ⇄ TSV
Comma, tab and semicolon separated files hold the same kind of table but are not interchangeable: an import screen that wants tabs will reject commas, and many European programs expect semicolons. This free tool re-writes a delimited text file with the separator you choose, in your browser.
The file is parsed properly rather than find-and-replace, so a comma inside a quoted address does not split a column, and fields that need quotes in the new format are quoted for you. Pick tab separated (TSV), comma separated (CSV) or semicolon separated and download the result.
How it works: CSV separates values with commas and TSV separates them with tabs. The tool reads your file with the correct rules for quotes and line breaks, then writes it back out with the other separator, so cells that contain commas or tabs stay intact.
Step by step: 1) add your file; 2) choose the direction, CSV to TSV or TSV to CSV; 3) convert; 4) download. Check a few rows afterwards to confirm columns line up.
Realistic limits: only the separator changes. The tool does not guess data types, fix encoding problems or repair rows that already have an inconsistent number of columns. If text looks garbled with accented characters, the original file probably uses a different encoding than the one your program assumed.
Typical uses: pasting data into systems that prefer tabs, preparing a file for a bioinformatics or statistics tool, or turning tab-separated exports from a database into a file spreadsheets open easily.
Which format to choose: CSV is the most widely accepted format for imports and spreadsheets, but it relies on quotation marks to protect commas in text. TSV avoids most of those problems because tabs rarely appear inside ordinary text, which makes it simple for scripts and command-line tools. If your data contains tabs or line breaks inside cells, either format needs quoting, and this tool handles that.
Verification: after converting, open the output in a plain text editor and look at the first few lines. Tabs appear as wide gaps; commas appear as commas. Confirm the number of columns per row is consistent by sorting or scrolling to the end. If a row has fewer or more columns than the header, the problem exists in the source and is better fixed there.
Tips for better results
- Use tab separated for data pasted into spreadsheets or sent to scientific tools that expect TSV.
- Use semicolons for programs set to a locale where the comma is the decimal mark.
- If you want an .xlsx workbook instead, use CSV to Excel.
- TSV is handy when your text contains many commas, such as addresses.
- European spreadsheets often use semicolons; check your delimiter if columns merge.
- Spot-check the first and last rows after converting.