CSV to TSV Converter

CSV to TSV

Convert CSV to TSV. Paste CSV on the left; the TSV output builds on the right as you type.

id,name,role
1,Ada Lovelace,engineer
2,Grace Hopper,engineer

becomes a tab-separated version of the same three columns and two rows, with commas replaced by literal tabs between fields. Both formats go through the same parser and the same row objects internally, one tabular codec handles both, so nothing about the data changes, only the character between fields and the quoting rules built around it.

Quoting differs by delimiter

CSV quotes a cell when it contains a comma, a double quote, or a line break. TSV quotes a cell for the same three reasons, but checks for a literal tab instead of a comma. A cell like "Smith, John" needs quotes in CSV because of the comma; the same cell converted to TSV doesn’t need quotes at all, since a comma isn’t special in TSV.

Detecting the source delimiter

Auto-detect scores comma, semicolon, tab, and pipe against your file’s first several rows and picks whichever gives the most consistent column count. Most real CSV exports, including semicolon-delimited ones from regions where comma is the decimal separator, convert correctly without touching the Delimiter control.

Coming back the other way

Converting a TSV file back to comma-separated CSV works the same way in reverse; see the TSV to CSV converter.