Convert YAML to CSV

Flatten a YAML list into a spreadsheet.

CSV

About this converter

Generally because somebody needs to read a config list, an inventory or a set of definitions in a spreadsheet rather than in a text editor.

A YAML list of mappings becomes rows directly. If the document is an object wrapping a single list, that list is used and the page says which key it came from — which is the shape of most YAML that contains a list worth tabulating.

Nesting becomes dotted column names, and comments are lost, since a CSV has nowhere to put them. If the YAML is the source of truth, treat the CSV as a view of it rather than a replacement.

Frequently asked questions

My YAML is a config file, not a list. What do I get?

A single row, with a column for every leaf value and dotted names showing the nesting. That is a reasonable way to see a flat summary of a configuration, though a deep file produces a very wide table.

Can I get back to YAML afterwards?

Round-tripping through the CSV to YAML page will reproduce the values and the dotted keys, but not the nesting — a column called address.city comes back as a key of that exact name rather than as a nested object. Comments do not come back at all.

Does what I paste get sent anywhere?

No. The conversion runs in your browser, on your own machine — which is why the result appears as you type. Nothing is uploaded and nothing is logged. That matters for this kind of tool in particular: config files and API responses are exactly the things that carry keys, hostnames and customer data.

Related tools