TSV to CSV

Your files never leave your device.

Choose a format
Choose a format

Values are copied exactly as written; any value containing a comma is put in quotes.

Questions about TSV to CSV

How does TSV to CSV work?

TSV to CSV changes the tabs between columns into commas and leaves the values themselves untouched. Any value that contains a comma, a double quote or a line break is wrapped in quotes so it stays in one cell. The CSV is written as UTF-8 without a BOM, with Windows (CRLF) line endings.

Are my values changed in any way?

No. Numbers, dates and text are copied character for character; nothing is retyped, rounded or reformatted. Only the separators change, plus quotes where a value needs them.

My TSV is UTF-16. Can it be converted?

Yes, as long as the file starts with a byte order mark. It is read as UTF-16 and the CSV is written as UTF-8. Files that are neither valid UTF-8 nor UTF-16 with a byte order mark are read as Windows-1252.

Are quotes in the TSV handled?

Yes. A field wrapped in double quotes is read as one value, so it can contain tabs or line breaks, and a doubled quote ("") becomes a single quote character. A quote in the middle of a value is kept as it is.