CSV to TSV

Comma-separated into tab-separated.

Updated
Loading tool…

Comma-separated into tab-separated.

How to use CSV to TSV

  1. Paste your comma-separated data into the input
  2. Let it parse quoted fields and insert tabs between columns
  3. Copy or download the tab-separated output
Try next →CSV to ExcelCSV into an .xlsx spreadsheet.

About CSV to TSV

CSV to TSV converts comma-separated values into tab-separated values, swapping the comma delimiter between each column for a tab. Paste your CSV and each row comes back with its columns split by tabs, ready to drop straight into Excel, Google Sheets, or any tool that expects tab-delimited input. It parses quoted CSV fields properly, so a comma sitting inside a quoted value stays part of that cell instead of breaking the row into an extra column.

Tab-separated output is handy when you want to paste rows directly into a spreadsheet, since every column lands in its own cell with no import dialog. Many scripts and bulk-import tools also read TSV more reliably than CSV, because a tab rarely appears inside a value the way a stray comma can. If you would otherwise reach for a one-off Python script, an Excel "Save As", or a command-line trick to reformat a file, this does the same job in the browser with nothing to write or install. Going the other way, from tabs back to commas, is what the companion TSV to CSV tool handles.

The conversion runs entirely in your browser, so the CSV you paste is turned into TSV on your own device and nothing is uploaded to a server. It is free, needs no account or sign-up, has no usage limits, and there is nothing to install.

Frequently asked questions

Is it free, and is there a sign-up?
Yes, it is free to use, with no account and no sign-up. There are no usage limits and nothing to install. Paste your CSV and copy the TSV it gives you.
Does my CSV get uploaded to a server?
No. Everything happens in your browser, so the data you paste stays on your own device. Nothing is sent anywhere or saved.
How do I convert CSV to TSV here?
Paste your comma-separated rows into the box. The tool reads the CSV, including quoted fields, and rebuilds each row with tab characters between the columns for you to copy.
Why would I want tab-separated output?
Tabs are convenient when you paste directly into a spreadsheet, since each column drops into its own cell. Some import tools and scripts also prefer tabs because values rarely contain a tab, unlike commas.
What if a cell contains a tab or a line break?
TSV has no way to quote a cell, so any tab or line break inside a value is replaced with a single space to keep the columns lined up. If your data relies on those characters staying intact, CSV is the safer format to keep.
Can this also convert TSV to CSV?
This page converts one way, from CSV to TSV. For the reverse direction, use the companion TSV to CSV tool, which turns tab-separated rows back into comma-separated values and quotes any cell that contains a comma.
How do I convert a TSV file into a CSV file?
Open the .tsv file in a text editor, copy its contents, and paste them into the TSV to CSV tool to get comma-separated output back. Because this all runs in the browser, you work with the text you paste rather than uploading the file itself.
How do I convert CSV to TSV in Python?
Read the file with csv.reader and write it out with csv.writer(f, delimiter='\t'); the csv module handles quoted commas for you. If you would rather not write a script, pasting into this tool gives the same result with no setup.
How do I convert CSV to TSV in Excel?
Excel has no direct .tsv option, but you can open the CSV and use File then Save As, choosing "Text (Tab delimited) (*.txt)", then rename the result to .tsv. Pasting into this tool skips the Save As step when you just need the tab-separated text.
How do I convert CSV to TSV on the command line or in bash?
A quick trick like tr ',' '\t' swaps commas for tabs, but it will also mangle commas inside quoted fields, so it is only safe for simple data. For rows with quoted values, use a CSV-aware tool such as csvkit's csvformat -T, or paste into this converter, which parses the quoting correctly.