CSV to TSV Converter

Understanding CSV to TSV converter

What is CSV?

A comma-separated values (CSV) file is a delimited text file that uses a comma to separate values. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The use of the comma as a field separator is the source of the name for this file format. A CSV file typically stores tabular data (numbers and text) in plain text, in which case each line will have the same number of fields.

The CSV file format is not fully standardized. The basic idea of separating fields with a comma is clear, but that idea gets complicated when the field data may also contain commas or even embedded line breaks. CSV implementations may not handle such field data, or they may use quotation marks to surround the field. Quotation does not solve everything: some fields may need embedded quotation marks, so a CSV implementation may include escape characters or escape sequences.

What is a TSV file?

A TSV file stores a data table in which columns of data are separated by tabs. It can be imported into most spreadsheet programs, which format the data into cells. TSV files can also be exported by spreadsheet programs, which allows the data to be viewed with a basic text editor or word processing program. TSV files are commonly used for exchanging data between databases. It is an alternative format to .CSV, which is another popular format for exporting spreadsheet data. CSV files use commas to separate columns of data instead of tabs.

Convert CSV Text into a TSV

This online tool which accept CSV either in plain text or in file or in URL format converts it to TSV. It will convert every new line in csv to tsv and each comma seperated values to tsv values.