Skip to main content

Convert CSV to TSV (and TSV to CSV)

Convert tabular text between comma-separated and tab-separated formats. Processing stays local in your browser.

  • Clipboard
Automate

Embed this widget

Customize the result, check the live preview, then copy the code.

Preview

Embed code type

Code to copy

Responsive and automatically resized by Bethemesh.

Was this tool useful?

How does this tool work?

A table copied from a spreadsheet often uses tabs, while another importer expects commas or receives a semicolon-separated regional export. The CSV and TSV converter changes those boundaries without interpreting amounts or identifiers. It works in both directions and returns tabular text for copying or export. Records and cells stay associated even when a quoted value contains a delimiter. This is not a workbook converter: it does not process Excel sheets, formatting or calculation formulas. It changes the representation of textual fields rather than the business information inside them.

For CSV to TSV, the source delimiter is detected from commas, semicolons, tabs and vertical bars using the first logical record. Output uses a tab between cells. For TSV to CSV, reading explicitly uses tabs and output always uses commas. This page offers no alternative destination CSV delimiter. If a receiving application requires semicolons, use a suitable export route rather than merely renaming the extension of a comma-separated file. File extensions describe formats but do not change field boundaries.

No record is treated specially as a header. Every record is converted in its original order, including files without headings and files with repeated heading names. Values remain strings, retaining leading zeros, spaces and decimal punctuation. Reading recognises quoted fields, doubled quotation marks and quoted line breaks. The serializer adds quotation marks when the destination delimiter requires them. That quoting convention supports complex TSV values, but some specialised TSV readers do not implement the same rules, so compatibility must be checked with the receiving software.

A leading UTF-8 BOM is removed, and newly written record separators use LF line endings. The precise use of quotation marks may therefore change without changing the cells. An unclosed quote prevents conversion and produces an error message. Equal record widths are not validated here; use CSV validation when that constraint matters. The import button accepts files up to 5 MiB and reads UTF-8 text. There is no Windows-1252 or UTF-16 encoding selector, nor a streaming mode intended for very large files.

How to use this tool

  1. Supply a coherent text table

    Paste data or import a CSV or TSV within the displayed limit. Inspect the first record because it determines source-delimiter detection in the CSV-to-TSV direction, especially in unusual one-column-looking files.

  2. Choose the conversion direction

    Select CSV to TSV for tabs or TSV to CSV for commas. This choice also controls download extension and media type. Changing a filename extension alone does not convert the delimiters or quoted fields.

  3. Inspect values containing separators

    Run conversion and check quoted values, decimal punctuation and multiline cells, then copy or export the result. Try a small output in the destination application before replacing an established import process.

Use cases

Prepare spreadsheet paste data

Turn semicolon-separated CSV into tab-separated text so pasted values occupy separate columns. Check the spreadsheet application's own automatic type-conversion settings before assuming identifiers will remain textual after insertion.

Supply a comma-delimited importer

Convert tabular text into comma-separated CSV when that exact delimiter is expected. Commas already inside values are protected through quoting rather than treated as new column boundaries.

Retain textual identifiers

Change an export's delimiters without turning references containing leading zeros into numbers. The generated file preserves those references, although software opening it afterwards may apply its own interpretation.

Examples

Replace semicolon boundaries with tabs

CSV-to-TSV conversion separates the three columns with tabs. The semicolon in Box; garden remains part of the description and the decimal point remains in 12.50. The amount is not calculated, reformatted or converted to another currency.

Input

id;description;price
A;"Box; garden";12.50

Result

id	description	price
A	Box; garden	12.50

Quote a comma when producing CSV

For TSV to CSV, the note already contains a comma. The engine surrounds it with quotation marks so it does not create a third column. The resulting file still contains two fields per record despite that internal comma.

Input

id	note
1	Hello, world

Result

id,note
1,"Hello, world"

Tips and best practices

  • A real tab differs from the two literal characters backslash and t. If a source contains escaped text, decode it through an appropriate process before asking the converter to interpret it as TSV.
  • Ambiguous automatic detection cannot infer the schema you intended. When the first record contains no delimiter, inspect the resulting columns carefully rather than assuming the conversion discovered the correct structure.
  • Do not globally replace commas with tabs in a text editor. Decimal commas and commas inside quoted values belong to the cells. Parsing the CSV first preserves the distinction between values and field separators.

Sources and references

Frequently asked questions

Does conversion change numerical values or dates?

No. Cells are treated as text while field serialisation changes. Identifiers and dates retain their spelling. Automatic conversion performed afterwards by Excel or another receiving application is behaviour of that other software, not part of this operation.

Can I create semicolon-separated CSV from TSV?

This interface writes commas in the TSV-to-CSV direction and offers no destination-delimiter selector. Use an export configured for semicolons when the receiving system requires that particular convention instead of ordinary comma-separated fields.

Why are quotation marks added or removed?

They are recalculated for the destination delimiter and each cell's characters. A comma-containing field needs quotes in comma-separated CSV, whereas that comma alone does not require quotes in tab-separated output. The cell value itself remains the same.

Do all applications read quoted TSV identically?

No. This engine uses CSV-like quoted-field rules with a tab delimiter. Check support for quotation marks and multiline values in the chosen importer instead of assuming every TSV reader accepts exactly the same conventions.

Related tools

Tools similar or complementary to this one.

Similar tools

Validate CSV structure and quickly identify problematic rows or columns in your data.

Data & spreadsheetsFeaturedUse this tool

Convert Excel, CSV, and other spreadsheet formats directly in your browser.

Data & spreadsheetsFeaturedUse this tool
GuideBest practicesIntermediate

Build a reproducible data-preparation workflow

Put cleaning, validation, filtering, merging, comparison and conversion in a sensible order, and learn when a reusable pipeline is better than isolated tools.

29 August 20262 min