About the CSV to YAML Converter
Data that is maintained in a spreadsheet often needs to end up in a YAML file: a list of team members for a site, translations, feature flags, test fixtures. This converter parses the CSV and writes a block-style YAML sequence where each row is a mapping keyed by the header names. Values that look like numbers or booleans are typed unless you turn that off, and strings that would be misread by a YAML parser are quoted.
The delimiter is auto-detected, quoted fields with embedded commas and newlines are handled, and an Excel byte-order mark is ignored. Output uses two-space indentation, which every YAML consumer accepts.
Use the reverse converter to get the data back into a spreadsheet after editing the YAML.
How to use
- Paste or upload the CSV.
- Decide whether values should be typed.
- Copy the YAML into your file.
Common questions
- Why are some strings quoted in the output?
- Values such as "yes", "1e5" or "null" would change type when parsed as YAML, so they are quoted to stay strings.
- Can I get a mapping keyed by the first column instead of a list?
- Not directly. Convert to JSON with the "object of columns" shape, or post-process the YAML.
- Are empty cells null or empty strings?
- Empty strings, written as "". Replace them with null in the output if your schema prefers.