CSV \u21c4 YAML

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.

Example

CSVYAML
name,address.city- name: Ada
Ada,London address: city: London

When to use it

  1. Create YAML data files for Jekyll, Hugo or Eleventy from a spreadsheet.
  2. Build test fixtures from CSV.
  3. Export a YAML list to Excel.
  4. Seed Ansible or Kubernetes values from a table.

How to Use

  1. Pick the direction.
  2. Paste or drop files.
  3. Copy or download the result.

Features

  1. Both directions
  2. Type detection
  3. Dotted-header nesting
  4. Block or flow style
  5. Batch to ZIP
  6. No upload

FAQs

How do I convert CSV to YAML?

Paste or drop the CSV; the YAML appears immediately.

Are numbers kept as numbers?

Yes, with 'Detect numbers' on. Leading-zero values like 007 stay text.

Can I make nested YAML?

Yes. Headers like address.city become nested maps.

What YAML can be turned into CSV?

A list of records, or a key holding one.

Is my data uploaded?

No.

Technical Details

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.

Data & CSV Tools

Data & CSV Tools

  • XSD Viewer
  • CSV Column Extractor
  • CSV Delimiter Converter
  • CSV to SQL INSERT
  • CSV to Markdown Table
  • CSV to JSON
  • JSON to CSV
  • YAML to JSON