Diysb Tools

CSVをTSVに変換する

以下のフォームにCSVファイルをアップロードすると、自動的にTSVファイルに変換されます。ツールのオプションでは、入力CSV形式をカスタマイズできます。フィールド区切り文字、引用符、コメント記号を指定したり、空のCSV行をスキップしたり、CSVの列ヘッダーを保持するかどうかを選択したりできます。

CSVツール

What is a CSVをTSVに変換する?

このツールは、カンマ区切り値（CSV）データをタブ区切り値（TSV）データに変換します。CSVとTSVはどちらも表形式のデータを保存する一般的なファイル形式ですが、値を区切る区切り文字が異なります。CSVではカンマ（

Input CSV
Output TSV
ツールオプション
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.
CSVをTSVに変換する 例

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

Input
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
Output
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.

Input
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
Output
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.

Input
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
Output
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.

全て CSVツール

CSVをJSONに変換する

CSV データを JSON 形式に変換します。

CSVをXMLに変換する

CSV データを XML 形式に変換します。

CSVの行を列に変換する

CSV の行を列に変換します。

CSV列の入れ替え

CSV 列を並べ替えます。

CSVをYAMLに変換する

CSV ファイルを YAML ファイルにすばやく変換します。

CSVセパレーターの変更

CSVファイルの区切り文字を変更する

不完全なCSVレコードを見つける

CSV 内で値が欠落している行と列をすばやく見つけます。

CSV転置

CSV ファイルをすばやく転置します。

CSV列を挿入する

CSV ファイル内の任意の場所に 1 つ以上の新しい列をすばやく挿入します。

TSVからJSONへ

TSVをJSON形式に変換する