Convert CSV to YAML

Turn spreadsheet rows into a YAML list.

YAML

About this converter

The usual job is seed data or fixtures: a list kept in a spreadsheet because that is where it is easy to edit, needed in YAML because that is what the application reads.

Each row becomes an entry in a list, with the header row as the keys. Numbers and true/false are read as values rather than text, which matters more here than almost anywhere — YAML is read by configuration systems, and a boolean arriving as the string "true" is the kind of thing that fails quietly at deploy time.

Leading zeros are the exception and stay as text, because an account number is not an integer however much it looks like one.

Frequently asked questions

Will my true and false values work as booleans?

Yes — they are read as booleans and written unquoted, which is what a configuration system will expect. Turn the option off if you want everything kept as strings.

Why did my reference number keep its quotes?

Because it has a leading zero, or is long enough that turning it into a number would change it. Keeping it as a string is the only way to preserve it exactly.

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