How are CSV types handled in YAML?

CSV values are strings by default. YAML will interpret unquoted values as numbers, booleans, or null. To preserve string types, quote values in YAML. Use a schema or post-processing to enforce types (e.g., parse dates, cast numbers).

Can I convert YAML back to CSV?

Only for flat YAML (a list of maps with the same keys). Nested YAML or YAML with varying keys does not map to CSV. If you need round-trip conversion, keep the YAML flat and homogeneous.

TASK

Convert CSV to YAML

Convert tabular CSV data to YAML for structured configuration or documentation. Each row becomes a YAML list item with column headers as keys.

1

CSV is a flat tabular format; YAML supports nested structures. Converting CSV to YAML produces a list of maps: each CSV row becomes a YAML list item, with column headers as keys and cell values as values. This is useful for configuration files derived from spreadsheets.
2

CSV Converter →
Parse the CSV file and convert to an intermediate format (JSON). The first row is treated as headers (column names), and subsequent rows become data records. Specify the delimiter (comma, semicolon, tab) and quoting rules.
3

YAML Converter →
Convert the intermediate JSON to YAML. Each record becomes a YAML list item with the column headers as keys. YAML's syntax is more readable than JSON for configuration — no quotes needed for most values, comments supported.
4

json-csv
View recipe Open in Toolchain

Use the CSV-to-JSON workflow as the first step, then convert the JSON to YAML for a complete CSV-to-YAML pipeline.
5

For hierarchical YAML (nested objects), you need a transformation step after conversion — CSV is flat, so the initial YAML is a flat list. Use a naming convention (e.g., parent.child as a column header) to create nesting, or post-process the YAML manually.

Frequently asked questions

How are CSV types handled in YAML?: CSV values are strings by default. YAML will interpret unquoted values as numbers, booleans, or null. To preserve string types, quote values in YAML. Use a schema or post-processing to enforce types (e.g., parse dates, cast numbers).
Can I convert YAML back to CSV?: Only for flat YAML (a list of maps with the same keys). Nested YAML or YAML with varying keys does not map to CSV. If you need round-trip conversion, keep the YAML flat and homogeneous.