About the CSV to TSV
Replacing every comma with a tab breaks as soon as a value contains a comma, like "Arlington, VA". This tool parses the CSV properly first, so quoted commas, doubled quotes and line breaks inside fields are kept as data, and then writes each row with tab characters between fields.
TSV is handy because commas are common in text but tabs are rare. Pasting TSV into Excel or Google Sheets splits it into columns automatically, and tools such as cut -f2, awk -F'\t' and PostgreSQL COPY read it without extra options. If a value does contain a tab, quote or line break, it is wrapped in double quotes the way Excel does it; turn on Quote all fields to quote every value.
The input delimiter is auto-detected, so semicolon-separated exports work too. Everything runs locally in the browser.
Example: the row 2,"Grace Hopper","Arlington, VA" becomes 2, Grace Hopper and Arlington, VA separated by tab characters; the quotes are no longer needed because the comma is not a separator in TSV. Rows with fewer fields than the header are written as they are, so you can spot them.
How to use it
- Paste CSV or open a .csv file.
- Confirm the detected delimiter and header setting.
- Copy the TSV or download converted.tsv.