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.
Loading…
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.
- 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.
inputstricttolerantliveparsein · sourcecsv · livename,age Alice,30
loaded · parsedtarget · ready - 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-preservinglosslesslivememoisedrow0 · optionskeys · livekeys = [name, age]
options applied · liveround-trip - 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-cleandeterministiclist · convertedof records · ready- name: Alice age: "30"
converted · livediff-clean - 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
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.
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.
k8sAnsible 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-preservingGitOps
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-awareFixtures
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.
losslessMigration
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-cleanDocs
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-gradeFrequently asked questions
Something missing?
Tell us what you need. We ship the top requests every two weeks.