Diysb Tools

Конвертировать CSV в YAML

Просто загрузите CSV-файл в форму ниже, и он автоматически будет преобразован в YAML-файл. В настройках инструмента вы можете указать символ разделителя полей, символ кавычки и символ комментария, чтобы адаптировать инструмент к пользовательским форматам CSV. Кроме того, вы можете выбрать выходной формат YAML: с сохранением заголовков CSV или без них.

CSV-инструменты
Input CSV
Output YAML
Параметры инструмента
Adjust CSV input
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.
Adjust YAML indentation
Set the number of spaces to use for YAML indentation.
Конвертировать CSV в YAML Примеры

Convert Music Playlist CSV to YAML

In this example, we transform a short CSV file containing a music playlist into structured YAML data. The input CSV contains five records with three columns each and the output YAML contains five lists of lists (one list for each CSV record). In YAML, lists start with the "-" symbol and the nested lists are indented with two spaces

The Beatles,"Yesterday",Pop Rock Queen,"Bohemian Rhapsody",Rock Nirvana,"Smells Like Teen Spirit",Grunge Michael Jackson,"Billie Jean",Pop Stevie Wonder,"Superstition",Funk
The Beatles,"Yesterday",Pop Rock Queen,"Bohemian Rhapsody",Rock Nirvana,"Smells Like Teen Spirit",Grunge Michael Jackson,"Billie Jean",Pop Stevie Wonder,"Superstition",Funk
- - The Beatles - Yesterday - Pop Rock - - Queen - Bohemian Rhapsody - Rock - - Nirvana - Smells Like Teen Spirit - Grunge - - Michael Jackson - Billie Jean - Pop - - Stevie Wonder - Superstition - Funk
- - The Beatles - Yesterday - Pop Rock - - Queen - Bohemian Rhapsody - Rock - - Nirvana - Smells Like Teen Spirit - Grunge - - Michael Jackson - Billie Jean - Pop - - Stevie Wonder - Superstition - Funk
Adjust CSV input
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.
Adjust YAML indentation
Set the number of spaces to use for YAML indentation.

Planetary CSV Data

In this example, we are working with CSV data that summarizes key properties of three planets in our solar system. The data consists of three columns with headers "planet", "relative mass" (with "1" being the mass of earth), and "satellites". To preserve the header names in the output YAML data, we enable the "Transform Headers" option, creating a YAML file that contains a list of YAML objects, where each object has three keys: "planet", "relative mass", and "satellites".

planet,relative mass,satellites Venus,0.815,0 Earth,1.000,1 Mars,0.107,2
planet,relative mass,satellites Venus,0.815,0 Earth,1.000,1 Mars,0.107,2
- planet: Venus relative mass: 0.815 satellites: '0' - planet: Earth relative mass: 1.000 satellites: '1' - planet: Mars relative mass: 0.107 satellites: '2'
- planet: Venus relative mass: 0.815 satellites: '0' - planet: Earth relative mass: 1.000 satellites: '1' - planet: Mars relative mass: 0.107 satellites: '2'
Adjust CSV input
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.
Adjust YAML indentation
Set the number of spaces to use for YAML indentation.

Convert Non-standard CSV to YAML

In this example, we convert a CSV file with non-standard formatting into a regular YAML file. The input data uses a semicolon as a separator for the "product", "quantity", and "price" fields. It also contains empty lines and lines that are commented out. To make the program work with this custom CSV file, we input the semicolon symbol in the CSV delimiter options. To skip comments, we specify "#" as the symbol that starts comments. And to remove empty lines, we activate the option for skipping blank lines (that do not contain any symbols). In the output, we obtain a YAML file that contains a list of three objects, which use CSV headers as keys. Additionally, the objects in the YAML file are indented with four spaces.

item;quantity;price milk;2;3.50 #eggs;12;2.99 bread;1;4.25 #apples;4;1.99 cheese;1;8.99
item;quantity;price milk;2;3.50 #eggs;12;2.99 bread;1;4.25 #apples;4;1.99 cheese;1;8.99
- item: milk quantity: 2 price: 3.50 - item: bread quantity: 1 price: 4.25 - item: cheese quantity: 1 price: 8.99
- item: milk quantity: 2 price: 3.50 - item: bread quantity: 1 price: 4.25 - item: cheese quantity: 1 price: 8.99
Adjust CSV input
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.
Adjust YAML indentation
Set the number of spaces to use for YAML indentation.