The short answer
Same data, different separator. CSV separates cells with commas. TSV separates them with tab characters. That is the whole difference, and it decides which tools can read your file.
When each one wins
| Use | Format |
|---|---|
| Excel and Sheets | CSV |
| Databases and command line tools | TSV |
| Log files and data dumps | TSV |
| Sharing with non-technical people | CSV |
TSV exists because real cell text often contains commas, but almost never contains a tab. A database export that uses tabs survives messy addresses and descriptions without a wall of quote marks.
The quoting trap
A CSV cell that holds a comma must be wrapped in quotes, or the reader thinks the cell ended early. This is where most hand-edited CSVs break. Quoted commas, quote marks inside quotes and line breaks inside cells all have exact rules.
Convert without the pain
The CSV to TSV tool handles the rules for you:
- Paste CSV or TSV, or drop the file in.
- The input format is detected on its own.
- Pick the output, tabs or commas.
- Copy the result or download it.
Cells with commas inside quotes survive the trip in both directions.
Beyond plain text
Need the data in a spreadsheet with real columns? CSV to Excel builds a workbook. Need it for code? CSV to JSON produces structured data.
Found this useful? Browse the free tools or suggest the next guide.