TSV to CSV
Move data between spreadsheet exports and CSV importers.
How TSV to CSV works
Convert tab-separated data into clean, properly quoted CSV, with ragged rows reported instead of silently dropped. Everything happens inside this page: the tool reads your input, runs the calculation or conversion locally, and hands the result back to you. Nothing is transmitted, because there is no backend to transmit it to.
That design choice is deliberate. Most free tool sites upload your files to a server, process them there, and quietly keep a copy. Toolcin cannot do that — the site is a set of static files. If your connection dropped the moment the page finished loading, every tool would still work.
Tabs into commas, safely
Cells are split on tabs, then written back with commas. Any field that contains a comma, a quote or a newline is wrapped in double quotes with inner quotes doubled — the RFC 4180 rule — so the result opens correctly in Excel and in a parser.
This is the reverse of the CSV to TSV page and uses the same parser, so a round trip through both leaves the data unchanged.
Where TSV input comes from
Copying cells out of a spreadsheet, a database COPY export, or a `column -t` output in a terminal. All of those produce tabs, and all of them need commas before they can be attached to an email or uploaded to a service that only accepts CSV.
| Input | Output |
|---|---|
| name\trole | name,role |
| a b\tc | "a b",c — only commas force quotes |
| x,\ty | "x,",y |
The ragged-row problem
A TSV with inconsistent column counts usually means a value contained a tab. The converter keeps the rows as they are rather than padding or dropping them, so check the column count in the output before importing.
Blank lines are preserved as empty rows, which some databases reject. Remove them first if the loader is strict.
Good to know
- Works offline once loaded, including on flights and in locked-down networks.
- No file size limit beyond your device's own memory.
- Free to use, with no account and no usage counter.
- Results are produced locally, so they are not logged or shared with anyone.
Questions
What if a value contains a comma?
It is wrapped in quotes so the CSV stays valid.
Are blank rows dropped?
Yes, empty rows are removed.
Will my commas inside values be escaped?
Yes, the field is quoted.
Does it handle UTF-8?
Yes, the output is UTF-8 without a BOM.
Keep going
More files tools
JSON to SQL
Turn a JSON array into a CREATE TABLE statement plus INSERT rows with inferred column types.
Open toolHTML to Text
Strip HTML tags and scripts to leave readable plain text with paragraphs intact.
Open toolText to HTML
Convert plain text into paragraphs and line breaks, with HTML characters escaped.
Open toolText to JSON Array
Turn a list of lines into a valid JSON array of strings. One line becomes one array element, with quotes and escapes handled for you.
Open toolCSV Column Extract
Extract a single column from CSV data by position and delimiter. Useful when a spreadsheet export has twenty columns and you need one.
Open toolSQL Formatter
Re-indent SQL by putting each major clause on its own line. SELECT, FROM, WHERE, JOIN, GROUP BY and ORDER BY each start a new line.
Open tool