All conversions

CSV → TSV

Convert CSV to TSV

This direction is usually a relief: tabs almost never appear inside real data, so the output needs far less escaping than the input had. The work is on the way in — reading the quoting rules correctly, including the quoted field that contains a line break.

How to do it

  1. Drop the .csv onto the editor. The delimiter is detected from the file itself, so a semicolon-separated export is read correctly without being told.
  2. Confirm the columns look right. A file with a stray quote usually shows up as one very wide row, and the review panel names it.
  3. Export as TSV. Cells that still contain a tab or a newline are quoted; everything else comes out bare.

Do it in the editor

What usually goes wrong

  • Tabs already inside cells

    Rare, but fatal if ignored. Those cells are flagged before export, and you can strip the tab or keep it quoted — your call, made visibly.

  • A quoted field spanning lines

    A comment or address written across two lines is one cell, not two rows. The parser follows the quoting rather than splitting on newlines.

If the source came out of Excel, check the encoding in the status bar. A file saved as ANSI is read as windows-1252 and converted to UTF-8 on export.