TSV TO CSV

How Does TSV to CSV Read the File?

On this page the delimiter is set to tab when detection is on Auto, so a TSV file is never misread as comma-separated just because its text contains commas. Encoding is detected the same way as everywhere else on 2csv: UTF-8, byte-order marks, and a Windows-1252 fallback that is reported.

• Accepts .tsv and .txt files, and pasted spreadsheet cells.
• First row is the header can be turned off for files without one.
• Any repairs the parser makes are listed in the CSV validator.

How Are Values Quoted in the CSV?

The output follows RFC 4180, the common definition of the CSV format. Any value containing a comma, a double quote, or a line break is wrapped in double quotes, and quotes inside a value are doubled. Values without those characters are left unquoted, unless you turn on quote every field, which some importers prefer.

• A value such as Smith, John is written as "Smith, John".
• A value containing a quote, such as 12" ruler, is written as "12"" ruler".
• A value with a line break inside stays in one quoted field.

Can You Clean the Data on the Way?

Yes. The TSV opens as a normal table, so you can trim whitespace, remove duplicates, or sort before exporting. The conversion back to tabs is on CSV to TSV, and the same export bar writes JSON, JSON Lines, and SQL if the data is headed somewhere else.

What Else Can You Do With a CSV Here?

• CSV viewer: Open a CSV of any size, scroll every row, and see a profile of each column.
• Sort CSV: Sort rows by one or more columns, as text, numbers, or dates, ascending or descending.
• Filter CSV: Show only the rows that match an expression such as price > 10 AND state = "NY".
• CSV validator: Find ragged rows, broken quotes, bad headers, encoding problems, and values of the wrong type.
• Remove duplicates from CSV: Find and remove duplicate rows, comparing whole rows or only the columns you choose.
• Trim CSV whitespace: Trim leading and trailing spaces, collapse double spaces, and drop invisible characters and empty rows.
• Find and replace in CSV: Find text in one column or every column and replace it, with match case, whole cell, and regex options.
• Remove rows from CSV: Delete rows by number or range, the first or last rows, empty rows, or rows that match a rule.
• CSV editor: Edit cells, add or delete rows, and add, delete, rename, or move columns.
• Split CSV column: Split one column into several at a delimiter, such as a full name into first and last.
• Merge CSV columns: Join two or more columns into one with the separator you choose, skipping empty values.
• CSV column type converter: Convert a column to clean numbers, ISO dates, true/false, or upper, lower, or title case.
• CSV to JSON converter: Convert CSV to a JSON array of objects or arrays, or to JSON Lines, with typed values.
• JSON to CSV converter: Convert a JSON array or JSON Lines to CSV, flattening nested objects into dotted column names.
• CSV to SQL converter: Turn a CSV into SQL INSERT statements, with an optional CREATE TABLE, for PostgreSQL, MySQL, SQLite, or SQL Server.
• CSV to TSV converter: Convert a comma-separated file to tab-separated values that paste cleanly into spreadsheets.
• CSV splitter: Split a large CSV into smaller files of a set number of rows, with the header repeated in each.

All eighteen tools are on the 2csv home page, and once a file is open you can switch between them without reloading it. Part of the 2suite.io privacy-first ecosystem.