Turn spreadsheet rows into clean YAML, or YAML lists back into CSV. Useful for seeding config files, Ansible inventories, test fixtures and static-site data from a spreadsheet — and for getting YAML data back into Excel. Drop several files to convert them all at once.
| CSV | YAML |
|---|---|
| name,address.city | - name: Ada |
| Ada,London | address: city: London |
Paste or drop the CSV; the YAML appears immediately.
Yes, with 'Detect numbers' on. Leading-zero values like 007 stay text.
Yes. Headers like address.city become nested maps.
A list of records, or a key holding one.
No.
CSV is parsed with a quote-aware parser, and the delimiter is auto-detected unless you choose one. Each row becomes a map keyed by the header row. Optionally, numbers, true/false and null are converted to their YAML types; values like 007 or long IDs stay strings so nothing is silently changed. Dotted headers such as address.city can become nested maps. The YAML is written by js-yaml, either block style or one record per line. In reverse, YAML is loaded and must be a list of records, or a single key holding one. Nested maps are flattened to dotted columns, lists become a JSON cell, and the header is the union of all keys.