csv → yaml · header row · list of records · live

Convert CSV to YAML

Treat the first CSV row as headers, the rest as records. Output is a YAML list of objects — easy to drop into Kubernetes, Ansible or any tool that prefers YAML.

CSV → YAML
Input
55 B
4 lines
Output
8 B
1 lines
Status
ready
live
Ratio
0.15×
out/in
input · csv
output · yaml
Loading…
Quick Start

How CSV becomes YAML

RFC 4180 parsing handles quoted fields and embedded commas. The first row defines keys; each subsequent row becomes an object inside a YAML list.

  1. 01

    Paste CSV

    Header row + data rows. Quoted fields handled.

    Parsing is strict-but-tolerant — comments and trailing commas are accepted on input where the source format historically permits them; output stays canonical.

    inputstricttolerantliveparse
    in · sourcecsv · live
    name,age
    Alice,30
    loaded · parsedtarget · ready
  2. 02

    Header row

    First row becomes the keys for every record.

    Conversion preserves type information where the target supports it (numbers stay numeric, booleans stay boolean) so the destination parser never has to re-coerce.

    headertype-preservinglosslesslivememoised
    row0 · optionskeys · live
    keys = [name, age]
    options applied · liveround-trip
  3. 03

    List of objects

    Each remaining row → one object in a YAML list.

    Re-encoding is idempotent: running output back through the same converter produces the same bytes, which keeps round-trips git-friendly.

    objectsidempotentround-tripdiff-cleandeterministic
    list · convertedof records · ready
    - name: Alice
      age: "30"
    converted · livediff-clean
  4. 04

    Copy or download

    Save as .yaml — ready for Kubernetes manifests or Ansible vars.

    Copy writes via navigator.clipboard.writeText; downloads use the target’s native MIME so editors apply the right syntax highlighting on open.

    exportclipboardtarget MIMEblobclient-side
    ✓ · copiedready · done
    ✓ Copied
    shipped · ready to shipsuccess
Pro tips

Converting between formats, safely

Pick the strictest source format

Lossy formats hide bugs. Choose JSON or YAML as your source-of-truth, convert downstream as needed.

Round-trip in CI

If your converter is idempotent, your CI can verify A → B → A equals the original. Catches subtle data loss.

Numbers vs strings differ

YAML/TOML have a number type; CSV doesn’t. Quote IDs in CSV to keep leading-zero values intact.

Watch character encoding

Source format may be Latin-1 / Windows-1252; target should be UTF-8. Convert encoding before structure.

Preserve comments where you can

YAML and TOML support comments. Don’t silently drop them — they often encode intent.

Schema-aware beats blind

Use a schema to guide conversion. Field types, required-ness, and defaults survive better with structure.

Use Cases

When to convert CSV to YAML

Kubernetes, Ansible, GitOps.

Kubernetes ConfigMaps

Drop CSV-shaped seed data into a YAML manifest. Type information survives: numbers stay numeric, booleans stay boolean, strings stay strings. The destination parser doesn't have to re-coerce, which avoids the "'true' becomes "true"" bug class.

k8s

Ansible vars

Bulk-load host inventory from a CSV spreadsheet. Run output back through the inverse converter to verify idempotent round-trips in CI. A → B → A should produce byte-identical input — if it doesn't, you've found data loss.

type-preserving

GitOps

Commit JSON-friendly seed data in YAML form. Comments and metadata survive where the target format supports them (YAML, TOML, HCL). The tool doesn't silently drop intent-encoded annotations, which keeps your config self-documenting.

schema-aware

Fixtures

Generate YAML fixtures for tests from a CSV export. Pair with a schema (JSON Schema, OpenAPI, Zod, Pydantic) to catch shape drift on either side. Catch breaking changes at conversion time rather than at runtime in production.

lossless

Migration

Convert legacy CSV exports into modern YAML configs. Output respects target-format conventions: quoting in CSV, indent in YAML, brackets in JSON. Existing parsers don't need patches, and the result drops into legacy pipelines unchanged.

diff-clean

Docs

Embed structured CSV data into a docs site that uses YAML. Encoding-aware: handles UTF-8 vs UTF-16 vs Latin-1 / Windows-1252 transparently. The character-set surprise that breaks "works on my machine" doesn't apply here.

spec-grade
FAQ

Frequently asked questions

No — everything stays a string. js-yaml emits quoted strings to be safe.
Yes — RFC 4180 quoting (double-quote escapes a quote).
Empty strings in the YAML object.
This parser uses comma. Convert via CSV to TSV first for tab data.
No. The conversion is local.
Suggest a tool

Something missing?

Tell us what you need. We ship the top requests every two weeks.

Sent straight to the maintainers · no account needed
47 in queue·8 shipped this month
Request queued. Thanks!