Diysb Tools

Converter CSV para TSV

Carregue seu arquivo CSV no formulário abaixo e ele será convertido automaticamente para um arquivo TSV. Nas opções da ferramenta, você pode personalizar o formato CSV de entrada – especificar o delimitador de campo, o caractere de aspas e o símbolo de comentário, além de pular linhas CSV vazias e escolher se deseja preservar os cabeçalhos das colunas CSV.

Ferramentas CSV

What is a Converter CSV para TSV?

Esta ferramenta transforma dados de Valores Separados por Vírgula (CSV) em dados de Valores Separados por Tabulação (TSV). CSV e TSV são formatos de arquivo populares para armazenar dados tabulares, mas usam delimitadores diferentes para separar valores – CSV usa vírgulas (

Input CSV
Output TSV
Opções de ferramentas
CSV Format Options
Enter the character used to delimit columns in the CSV file.
Enter the quote character used to quote the CSV fields.
Enter the character indicating the start of a comment line. Lines starting with this symbol will be skipped.
Conversion Options
Keep the first row as column names.
Enable to prevent the conversion of empty lines in the input CSV file.
Converter CSV para TSV Exemplos

Convert Game Data from the CSV Format to the TSV Format

In this example, we transform a Comma Separated Values (CSV) file containing a leaderboard of gaming data into a Tab Separated Values (TSV) file. The input data shows the players' names, scores, times, and goals. We preserve the CSV column headers by enabling the "Preserve Headers" option and convert all data rows into TSV format. The resulting data is easier to work with as it's organized in neat columns

player_name,score,time,goals ToniJackson,2500,30:00,15 HenryDalton,1800,25:00,12 DavidLee,3200,40:00,20 EmmaJones,2100,35:00,17 KrisDavis,1500,20:00,10
player_name,score,time,goals ToniJackson,2500,30:00,15 HenryDalton,1800,25:00,12 DavidLee,3200,40:00,20 EmmaJones,2100,35:00,17 KrisDavis,1500,20:00,10
player_name score time goals ToniJackson 2500 30:00 15 HenryDalton 1800 25:00 12 DavidLee 3200 40:00 20 EmmaJones 2100 35:00 17 KrisDavis 1500 20:00 10
player_name score time goals ToniJackson 2500 30:00 15 HenryDalton 1800 25:00 12 DavidLee 3200 40:00 20 EmmaJones 2100 35:00 17 KrisDavis 1500 20:00 10
CSV Format Options
Enter the character used to delimit columns in the CSV file.
Enter the quote character used to quote the CSV fields.
Enter the character indicating the start of a comment line. Lines starting with this symbol will be skipped.
Conversion Options
Keep the first row as column names.
Enable to prevent the conversion of empty lines in the input CSV file.

Mythical Creatures

In this example, we load a CSV file containing coffee varieties and their origins. The file is quite messy, with numerous empty lines and comments, and it is hard to work with. To clean up the file, we specify the comment pattern // in the options, and the program automatically removes the comment lines from the input. Also, the empty lines are automatically removed. Once the file is cleaned up, we transform the five clean rows into five columns, each having a height of two fields.

creature;origin;habitat;powers Unicorn;Mythology;Forest;Magic horn Mermaid;Mythology;Ocean;Hypnotic singing Vampire;Mythology;Castles;Immortality Phoenix;Mythology;Desert;Rebirth from ashes #Dragon;Mythology;Mountains;Fire breathing #Werewolf;Mythology;Forests;Shape shifting
creature;origin;habitat;powers Unicorn;Mythology;Forest;Magic horn Mermaid;Mythology;Ocean;Hypnotic singing Vampire;Mythology;Castles;Immortality Phoenix;Mythology;Desert;Rebirth from ashes #Dragon;Mythology;Mountains;Fire breathing #Werewolf;Mythology;Forests;Shape shifting
Unicorn Mythology Forest Magic horn Mermaid Mythology Ocean Hypnotic singing Vampire Mythology Castles Immortality Phoenix Mythology Desert Rebirth from ashes
Unicorn Mythology Forest Magic horn Mermaid Mythology Ocean Hypnotic singing Vampire Mythology Castles Immortality Phoenix Mythology Desert Rebirth from ashes
CSV Format Options
Enter the character used to delimit columns in the CSV file.
Enter the quote character used to quote the CSV fields.
Enter the character indicating the start of a comment line. Lines starting with this symbol will be skipped.
Conversion Options
Keep the first row as column names.
Enable to prevent the conversion of empty lines in the input CSV file.

Convert Fitness Tracker Data from CSV to TSV

In this example, we swap rows and columns in CSV data about team sports, the equipment used, and the number of players. The input has 5 rows and 3 columns and once rows and columns have been swapped, the output has 3 rows and 5 columns. Also notice that in the last data record, for the "Baseball" game, the number of players is missing. To create a fully-filled CSV, we use a custom message "NA", specified in the options, and fill the missing CSV field with this value.

day,steps,distance,calories Mon,7500,3.75,270 Tue,12000,6.00,420 Wed,8000,4.00,300 Thu,9500,4.75,330 Fri,10000,5.00,350
day,steps,distance,calories Mon,7500,3.75,270 Tue,12000,6.00,420 Wed,8000,4.00,300 Thu,9500,4.75,330 Fri,10000,5.00,350
day steps distance calories Mon 7500 3.75 270 Tue 12000 6.00 420 Wed 8000 4.00 300 Thu 9500 4.75 330 Fri 10000 5.00 350
day steps distance calories Mon 7500 3.75 270 Tue 12000 6.00 420 Wed 8000 4.00 300 Thu 9500 4.75 330 Fri 10000 5.00 350
CSV Format Options
Enter the character used to delimit columns in the CSV file.
Enter the quote character used to quote the CSV fields.
Enter the character indicating the start of a comment line. Lines starting with this symbol will be skipped.
Conversion Options
Keep the first row as column names.
Enable to prevent the conversion of empty lines in the input CSV file.