What Is a TSV to CSV Converter?
A TSV to CSV converter changes tab-separated values into comma-separated values. Both are plain-text table formats: TSV separates columns with a tab character, and CSV uses commas. Many systems produce TSV, including database exports, Google Sheets downloads, bioinformatics pipelines, analytics platforms and anything copied from a spreadsheet. Many import tools, however, only accept CSV.
A simple find-and-replace of tabs with commas breaks your data as soon as a value contains a comma or quote. This converter parses each field properly and quotes values that need quoting, following the RFC 4180 standard, so the resulting CSV imports cleanly everywhere.
How to Convert TSV to CSV
- Paste or upload TSV data. You can copy a range of cells from Excel or Google Sheets and paste it directly.
- Choose the direction and delimiter. Convert TSV to CSV, or CSV back to TSV, with comma, semicolon or pipe output.
- Check the output, which updates live as you type.
- Copy or download the converted file.
Features
- Correct CSV quotingFields containing commas, quotes or line breaks are wrapped and escaped automatically.
- Two-way conversionSwitch between TSV to CSV and CSV to TSV with one setting.
- Spreadsheet paste supportCells copied from Excel or Sheets are tab-separated, so just paste them.
- Regional delimitersOutput semicolon-separated CSV for European Excel versions.
- Windows or Unix line endingsMatch the requirements of your target system.
- PrivateConversion happens locally in your browser.
TSV vs CSV
| TSV | CSV | |
|---|---|---|
| Separator | Tab character | Comma (or semicolon) |
| Quoting needed | Rarely | When values contain commas or quotes |
| Common file extensions | .tsv, .tab, .txt | .csv |
| Import support | Good | Universal |
Why Not Just Replace Tabs with Commas?
A quick find-and-replace of every tab with a comma seems to work until your data contains a comma. Consider this TSV row:
Laptop Pro 14→1299.00→Fast, light and "quiet"
A naive replacement produces Laptop Pro 14,1299.00,Fast, light and "quiet", which a CSV reader interprets as four columns instead of three, and the stray quotes may corrupt the rest of the file. A proper converter outputs:
Laptop Pro 14,1299.00,"Fast, light and ""quiet"""
The description is wrapped in quotes and the inner quotes are doubled, exactly as RFC 4180 requires. This tool applies those rules to every field automatically, so the CSV imports correctly into Excel, databases and web applications.
Converting CSV Back to TSV
Switch the direction to CSV → TSV when a tool expects tab-separated input, for example when pasting data into spreadsheet cells, loading into bioinformatics or statistics software, or importing into databases with LOAD DATA. The CSV is parsed properly (quoted fields, embedded commas and doubled quotes), then written with tabs between fields. Tabs or line breaks inside values are replaced with spaces so each record stays on one line.
Where TSV Data Comes From
- Spreadsheet clipboard: copying cells in Excel, Google Sheets or Numbers puts tab-separated text on your clipboard.
- Databases: MySQL
SELECT ... INTO OUTFILE, PostgreSQLCOPYand many SQL clients export TSV by default. - Science and research: genomics (BED, GFF), linguistics corpora and statistics packages favour TSV because data rarely contains tabs.
- Analytics exports: tools such as Google Search Console and some ad platforms offer TSV downloads.
Frequently Asked Questions
Is this TSV to CSV converter free?
Yes. It is completely free, with no limits on file size or the number of conversions, and no sign-up required.
Which file extension should I use?
Use .csv for comma- or semicolon-separated output and .tsv for tab-separated output. The download button chooses the correct extension automatically based on the direction.
Can I output semicolon-separated CSV for Excel?
Yes. Choose "Semicolon" as the CSV delimiter. This is the format Excel expects in many European countries.
Are empty cells preserved?
Yes. Empty values stay empty, and the number of columns in every row is kept exactly as in the input.
What does "Trim whitespace" do?
It removes spaces at the start and end of each value, which often creep in when data is copied from documents or web pages. Untick it to keep values exactly as they are.
Can I paste data directly from Excel?
Yes. When you copy cells in Excel or Google Sheets, the clipboard contains tab-separated text. Paste it into the input box to get CSV instantly.
What happens to commas inside my values?
Any value containing a comma, quote or line break is wrapped in double quotes, and inner quotes are doubled, so the CSV stays valid.
Can I convert CSV to TSV?
Yes. Choose "CSV → TSV" in the Direction setting.
Is my data uploaded?
No. All processing happens in your browser.