How to Convert YAML to TSV
YAML is lovely to read but you can't drop it into a spreadsheet. This converter bridges the gap. It reads a YAML list of mappings — the common shape for records — and turns each item into a tab-separated row. Every key across all items becomes a column, unioned so records with different fields still line up, with empty cells filling any gaps. Tabs and newlines inside a value are replaced with spaces so your columns never shift, and any nested map or list in a cell is written compactly so nothing is lost. TSV is the format spreadsheets expect on paste, so it lands cleanly in Excel and Google Sheets without an import step. Choose whether to include a header row, then copy or download. Everything runs in your browser, so nothing is uploaded.
Paste your YAML
Paste a list of mappings or load the sample; it's parsed locally with nothing uploaded.
Choose the header
Keep the header row for labelled columns, or turn it off for data only.
Copy or download
Grab the TSV with one tap or save it as a .tsv file.
YAML vs TSV — What's the Difference?
YAML — YAML Ain't Markup Language
A human-friendly, indentation-based format that keeps types and nested structure. It's the default for configuration, but spreadsheets can't open it directly.
TSV — tab-separated values
A flat table format where tabs separate columns and newlines separate rows. It pastes cleanly into spreadsheets and avoids CSV's quoting quirks. Converting YAML to TSV flattens records into a paste-ready table.
Common Use Cases
YAML into Excel
Turn a YAML config or data list into TSV and paste it straight into a spreadsheet.
Google Sheets imports
TSV drops neatly into Sheets with each value in its own cell.
Review config data
See many YAML records as an aligned grid to scan and compare quickly.
Export from configs
Pull tabular data out of YAML settings files for reporting.
Data handoff
Give teammates a paste-ready table instead of raw YAML.
Downstream tools
Feed tab-separated data to scripts and tools that prefer TSV.
Spot-check records
Quickly view what fields a YAML record list contains.
Quick transforms
A fast, no-install way to turn YAML records into a table.
Tips & Best Practices
Structure YAML as a list
A top-level sequence of mappings — each item starting with a dash — converts most cleanly to rows.
Paste directly into a sheet
TSV is what spreadsheets expect on paste, so it lands in cells without an import step.
Keep the header for labels
Leave the header row on so columns are named when pasted into a sheet.
Trust tab sanitising
Tabs and newlines inside values become spaces automatically, so columns never break.
Flatten deep nesting first
Nested values are written compactly in one cell; flatten the YAML for separate columns.
Consistent keys help
Records with the same keys give the tidiest table, though differing keys are unioned safely.
Troubleshooting
It says YAML must be a list
The top level needs to be a sequence — a series of items each starting with a dash. A single mapping isn't a table of rows.
Columns look shifted
A value may have contained a tab or newline. Those are replaced with spaces automatically; re-copy the output rather than an edited version.
A cell shows braces or brackets
That value was a nested map or list. It's written compactly so no data is lost; flatten the YAML for separate columns.
Indentation errors
YAML is indentation-sensitive. Use consistent spaces (not tabs) for nesting so the structure is read correctly.
Frequently Asked Questions
How do I convert YAML to TSV for free?
Paste your YAML list of records above and tab-separated values appear instantly. Copy them or download a .tsv file — free, no signup.
What YAML shape does it expect?
A list (sequence) of mappings — each item starts with a dash and contains key-value pairs. Each item becomes a row.
How are columns decided?
Every key across all items becomes a column, unioned so records with different fields still line up.
What if records have different keys?
Any key missing from a record produces an empty cell, keeping the whole table aligned.
Why TSV instead of CSV?
TSV pastes directly into Excel and Google Sheets and avoids CSV's quoting edge cases, since tabs rarely appear inside values.
What happens to tabs inside a value?
Any tab or newline inside a value is replaced with a space so your columns never shift out of alignment.
What about nested maps or lists?
A nested value in a cell is written compactly as JSON-like text so nothing is lost; flatten the YAML first for separate columns.
Can I omit the header row?
Yes. Turn off the header option to output only the data rows.
Does the preview use real tabs?
The preview shows tabs as → for clarity, but the copied and downloaded output contains real tab characters.
Will it paste into Excel correctly?
Yes. Copy the output and paste into Excel or Sheets and each value lands in its own cell.
Does it keep data types?
TSV is plain text, so values are written as text. Types are preserved if you convert to JSON instead.
Is my data sent to a server?
No. Everything happens inside your browser, so your data never leaves your device.
Can I download the result?
Yes. Save the output as a .tsv file, or copy it straight to your clipboard.
How large a file can it handle?
It comfortably converts thousands of records, all within your browser.
Can I convert to CSV instead?
Yes — use our YAML to CSV converter for comma-separated output.
Does it preserve Unicode?
Yes. Any Unicode characters in your data are preserved in the TSV output.
Does it work on phones?
Yes, in any modern browser on Windows, Mac, Android or iPhone with nothing to install.
Is this converter really free?
Completely free, forever — no account, no ads and no premium wall.
100% free · No signup · Processed in your browser · Data never sent
Last updated: August 2026 · FlipMyFormat YAML to TSV Converter
Written and maintained by the FlipMyFormat team · Runs entirely in your browser