CSV TO TSV

What Is the Difference Between CSV and TSV?

CSV separates values with commas and wraps values that contain commas, quotes, or line breaks in double quotes. TSV separates values with tab characters and usually has no quoting at all. Because commas are common in text and tabs are rare, TSV is simpler to read with basic tools and pastes cleanly.

• CSV can hold any text in a cell, thanks to quoting.
• TSV cannot hold tabs or line breaks inside a cell.
• Spreadsheets split pasted TSV into cells automatically.

What Happens to Tabs and Line Breaks Inside Cells?

TSV cannot hold them, so they become spaces, and the count of changed cells is reported. A notes column with line breaks will come out as one line per cell. If line breaks matter, keep the file as CSV; if they do not, consider cleaning them first with Trim whitespace, which can replace them on purpose.

Reporting the count matters because the change is otherwise invisible. A file with no tabs or line breaks inside cells converts with a count of zero, which confirms that the TSV holds exactly the same values as the CSV, only separated differently. A count above zero tells you which choice to make.

Can You Convert the Other Way?

Yes. TSV to CSV reads a tab-separated file and writes a standard, properly quoted CSV. Cells copied from a spreadsheet arrive tab-separated, so pasting them onto the page and exporting as CSV is another quick route. The export bar also writes JSON, JSON Lines, and SQL from the same table.

Before converting, the other tools can tidy the data in place. Remove duplicates, Sort CSV, and Filter CSV all work on the same open table, and if a filter is active the TSV export contains only the matching rows, as the export bar notes.

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.
• TSV to CSV converter: Convert a tab-separated file to a standard, properly quoted comma-separated CSV.
• 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.