TSV to CSV

Move data between spreadsheet exports and CSV importers.

How TSV to CSV works

Convert tab-separated data into clean, properly quoted CSV, with ragged rows reported instead of silently dropped. Everything happens inside this page: the tool reads your input, runs the calculation or conversion locally, and hands the result back to you. Nothing is transmitted, because there is no backend to transmit it to.

That design choice is deliberate. Most free tool sites upload your files to a server, process them there, and quietly keep a copy. Toolcin cannot do that — the site is a set of static files. If your connection dropped the moment the page finished loading, every tool would still work.

Tabs into commas, safely

Cells are split on tabs, then written back with commas. Any field that contains a comma, a quote or a newline is wrapped in double quotes with inner quotes doubled — the RFC 4180 rule — so the result opens correctly in Excel and in a parser.

This is the reverse of the CSV to TSV page and uses the same parser, so a round trip through both leaves the data unchanged.

Where TSV input comes from

Copying cells out of a spreadsheet, a database COPY export, or a `column -t` output in a terminal. All of those produce tabs, and all of them need commas before they can be attached to an email or uploaded to a service that only accepts CSV.

InputOutput
name\trolename,role
a b\tc"a b",c — only commas force quotes
x,\ty"x,",y

The ragged-row problem

A TSV with inconsistent column counts usually means a value contained a tab. The converter keeps the rows as they are rather than padding or dropping them, so check the column count in the output before importing.

Blank lines are preserved as empty rows, which some databases reject. Remove them first if the loader is strict.

Good to know

  • Works offline once loaded, including on flights and in locked-down networks.
  • No file size limit beyond your device's own memory.
  • Free to use, with no account and no usage counter.
  • Results are produced locally, so they are not logged or shared with anyone.

Questions

What if a value contains a comma?

It is wrapped in quotes so the CSV stays valid.

Are blank rows dropped?

Yes, empty rows are removed.

Will my commas inside values be escaped?

Yes, the field is quoted.

Does it handle UTF-8?

Yes, the output is UTF-8 without a BOM.

Keep going

More files tools