convert

CSV to TSV

Convert comma-separated CSV to tab-separated TSV, correctly handling quoted fields.

Runs on your deviceBatch readyPaste textNew

Paste or drop

Paste text below, or drop a file instead.

0 chars · 0 lines
…or drop a file
Drag and drop, or choose files
CSVTXT

Choose an output

Convert comma-separated CSV to tab-separated TSV, correctly handling quoted fields.

About CSV to TSV

This tool converts comma-separated data to tab-separated data with a real CSV parser, not a find-and-replace. Commas inside quoted fields, such as "Smith, John" or "1,200", stay part of the value instead of splitting it. The output is ready for tools and paste targets that expect tabs.

When it helps

  • Preparing data for Unix tools like cut, awk or join that split on tabs.
  • Pasting rows into a spreadsheet so each value lands in its own cell.
  • Supplying .tsv input to research, genomics or machine-learning tools.

Tips

  • The input delimiter is detected automatically, so semicolon-separated files from European versions of Excel work too.
  • Fields that already contain a tab or a line break are wrapped in quotes in the output so the rows stay intact.
  • Empty lines are skipped, which also removes the blank row many exports leave at the end of the file.

Good to know

Quick answers about csv to tsv in your browser.

Because commas also appear inside quoted values. A plain replace would split "Austin, TX" into two columns and shift the rest of the row. Parsing the CSV properly avoids that.

Quotes that only wrapped a field are removed once the value is read. They are added back only where the TSV needs them, for example around a value that contains a tab.

Yes. There is no sign-up, no watermark and no limit on how many files you process.

No. Files are read and processed locally in your browser, so they never leave your device.

Related tools

DATEPUB to PDFConvert EPUB text to a simple PDF.DATEPUB to HTMLExtract EPUB spine documents into one HTML file.DATEPUB to TXTExtract readable text from an EPUB.DATCSV/TSV to JSONConvert delimited data to JSON records.DATJSON to CSVConvert a JSON array or object collection to CSV.DATJSON to TSVConvert JSON records to TSV.DATData to HTMLRender data as a portable HTML table.DATNewJSON to ExcelTurn a JSON array of objects into an Excel spreadsheet, with nested fields flattened into columns.DATNewCSV to Markdown TableTurn CSV or TSV data into a GitHub-flavored Markdown table for READMEs, docs and issues.

Part of the CSV Tools collection.