TSV to CSV Converter

Tab-separated output from databases

Command-line database clients commonly produce TSV: mysql --batch prints tab-separated rows, and PostgreSQL's COPY … TO writes tabs in its default text format. Both escape special characters in their own way. PostgreSQL writes a NULL as \N, a tab in the data as \t, and a newline as \n. Those escapes are copied into the CSV as literal text, so replace them before importing the result elsewhere.

Checking the CSV that comes out

Cells containing a semicolon or a pipe are quoted as well as those with commas, which is valid CSV and keeps the file safe for programs that guess a different separator. Lines end with a single line feed. Most programs accept that, although the CSV standard, RFC 4180, specifies a carriage return and line feed. Open the result in the CSV viewer to confirm every row has the same number of columns before importing it.

How to use it

1. Paste TSV or choose a file.
2. Check the result.
3. Copy or download the CSV.

Privacy & limitations

The text is converted in your browser and never uploaded, which matters when the file is a config or an export you would rather not hand to a stranger. Quotes inside a cell are doubled, which is how CSV escapes them.