Handitab

TSV ↔ CSV

Convert tab-separated TSV to comma-separated CSV or the other way around, with the input delimiter detected from the first line.

About TSV ↔ CSV

TSV and CSV are plain text table formats that differ only in the column delimiter: a tab or a comma. This tool detects the delimiter of the input from its first line (comma, semicolon, tab, or pipe), parses quoted fields, and writes the rows again with the delimiter you choose. Fields that contain the new delimiter, a quote, or a line break are wrapped in double quotes. Empty rows are dropped.

How to use TSV ↔ CSV

  1. Type or paste into the "TSV or CSV" box, or press "Use example" to try it with sample data.
  2. Set "Convert to" if the defaults do not fit.
  3. The result appears below and updates as you type.
  4. Copy the result with the copy button, or download it as a file where that is offered.

Questions about TSV ↔ CSV

When should I use TSV instead of CSV?

TSV is handy when values often contain commas, such as addresses or decimal numbers in some locales, because tabs rarely appear inside data. It also pastes straight into spreadsheet cells. CSV is accepted by more import tools.

Runs in your browser. Page last updated .

More encoding and data tools

All 28 encoding and data tools
TSV to JSON ConverterConvert tab-separated values (TSV) to a JSON array of objects, using the first row as keys and turning numeric cells into numbers.URL DecoderDecode a percent-encoded URL or query string back to readable text, turning %XX escapes and plus signs into their original characters.URL EncoderEncode text or a full URL with percent escapes so spaces, symbols, and non-ASCII characters are safe to use in a link or query string.URL Encoder/DecoderEncode special characters in text or a URL as percent escapes, or decode percent-encoded text back to its original characters.XML to JSONConvert XML to JSON, keeping attributes as keys with an @ prefix and turning repeated child elements into arrays automatically.YAML ↔ JSONConvert YAML to JSON or JSON to YAML in either direction, with syntax checked along the way and the line of any error reported.