· CSV.ink Team

What Is a TSV File? How to Open and Convert It

A .tsv file is a plain-text table that uses tabs between columns instead of commas. Open it in Excel via import, or convert it to CSV when a tool only accepts commas.

TSV stands for tab-separated values. Same idea as CSV: one row per line, columns separated by a delimiter — here the delimiter is a tab character (\t), not a comma.

Why people use TSV

Commas show up constantly inside addresses, product names and CSV-ish prose. Tabs show up less often in prose, so many pipelines skip heavy quoting. Spreadsheet paste from HTML tables also often arrives as TSV on the clipboard.

How to open a .tsv file

  • Excel: Data → From Text/CSV, pick the file, set delimiter to Tab. Double-click may work if your Excel locale treats tabs correctly — import is safer.
  • Google Sheets: File → Import → Upload, separator Tab.
  • VS Code / text editors: fine for a quick look; tabs may look like uneven spaces.
  • Browser: use an online TSV viewer if you do not want to install anything.

TSV viewer and editor →

TSV vs CSV

Interchangeable for most flat tables once you agree on the delimiter. CSV is more common in “Download” buttons; TSV shows up in science tools, some database exports and clipboard transfers. Neither format stores formatting or multiple sheets.

Convert when the next tool is picky

If an uploader insists on .csv, convert tabs to commas (and quote fields that contain commas). Going to Excel for a colleague is usually .xlsx, not another text dialect.

TSV to CSV →

TSV to Excel →

CSV to TSV →

A file named .txt can still be TSV inside. Trust the delimiter, not only the extension.

Creating a TSV yourself

In code, join fields with "\t" and rows with "\n". Quote fields only when they contain tabs or line breaks — rarer than comma quoting in CSV, which is part of the appeal. From a spreadsheet: export as “Tab Delimited Text” if the menu offers it, then rename to .tsv if needed.

When you paste a table from a webpage into a text editor, you often already have TSV. Save that paste and convert only if the destination demands commas.

Ferramentas relacionadas

← Todos os artigos

Mais artigos