CSV to TSV
Convert to
Tools for this file
Your files never leave your device.
Values are copied exactly as written; only the commas between columns become tabs.
Questions about CSV to TSV
How does CSV to TSV work?
CSV to TSV turns a comma-separated file into a tab-separated one. Quoted fields that contain commas or line breaks stay in one cell, and the TSV is saved as UTF-8 with Windows (CRLF) line endings.
Do values containing commas still need quotes?
No. In the TSV a value is only wrapped in quotes if it contains a tab, a double quote or a line break, or starts or ends with a space. Commas inside values are left as they are.
My CSV uses semicolons. Will it work?
No. Only commas are treated as column separators. In a semicolon-separated file the semicolons are kept as ordinary characters, so the rows are not split into their columns.
What happens to accented characters?
They carry over. The CSV can be UTF-8 (with or without a byte order mark) or UTF-16 with a byte order mark; anything that isn't valid UTF-8 is read as Windows-1252, the older Western European Windows encoding. The TSV is always written as UTF-8.