Loading...
Loading...
Switch from comma-separated to tab-separated format. TSV is required by certain database tools, bioinformatics pipelines, and clipboard paste workflows in Excel.
Commas appear naturally inside text values such as addresses, names with titles, and numeric values formatted with thousand separators. A comma-separated file handles this with quoting rules, but parsers in some older tools do not implement quoting correctly and split the field at every comma. Tabs appear far less frequently inside text data, which makes TSV simpler to parse without the risk of misinterpreting a delimiter mid-field.
When you paste tab-separated data from the clipboard into an Excel spreadsheet, Excel automatically splits the content into separate columns. Comma-separated clipboard data pastes into a single column. If you copy data from a web table or another application and want it to land in correctly separated Excel columns, converting to TSV first and then copying the output achieves that.
Many bioinformatics tools produce or expect TSV output by convention. BLAST tabular output uses tab-separated fields. BED, GFF, and VCF formats for genomic data are tab-delimited. If you have reference data in CSV format and need to join it with BLAST output or a BED file in a pipeline, converting the CSV to TSV first lets you use standard command-line tools like join, awk, and cut without needing to specify a custom delimiter.
Scientific data analysis tools in R and Python also accept TSV. The read.table() function in R and pandas.read_csv() with sep='\t' both handle TSV natively. Some analysis scripts hard-code the tab delimiter, requiring input files to be TSV regardless of their actual origin format.
What file extension should a TSV file use?
The conventional extension is .tsv, though some tools use .txt. The content is plain text regardless of extension. Use .tsv when sharing with tools that detect the format from the extension.
What happens to tabs that already exist inside a field value?
If a cell value contains a tab character, it will break the TSV structure because the parser will treat it as a delimiter. The converter warns you if embedded tab characters are detected in the data. Remove them from the source or replace them with spaces before converting.
Can I convert TSV back to CSV?
Yes. Use any of the other CSV tools by pasting the TSV content and manually selecting tab as the input delimiter in the delimiter settings, or use the CSV Viewer to inspect the TSV first to confirm it parses correctly.