CSV to TSV Converter

Where tab-separated is the default

Several tools expect tabs unless told otherwise. PostgreSQL's COPY in its text format and MySQL's LOAD DATA INFILE both split fields on tabs by default. On the command line, cut -f2 selects the second tab-separated column without any options, and awk -F'\t' and sort -t$'\t' work reliably because a TSV field never contains the separator. None of these understand CSV quoting, which is why converting first avoids broken columns.

One record per line

In the converted file every line is exactly one record, because line breaks inside cells were flattened. That makes line-based tools safe: wc -l counts records plus the header, head -n 101 gives the header and 100 rows, and split -l cuts a large file without breaking a record in half. In a CSV with multi-line addresses or comments, all three silently miscount. To go back to CSV for a spreadsheet or import form, use TSV to CSV.

How to use it

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

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. Any tab or newline inside a cell is flattened to a space, because TSV has no way to quote them.