Pull the list out of a YAML file and get a CSV you can open in a spreadsheet
Runs in your browser. Nothing you type is sent anywhere. Updated on 24 Oct 2026.A spreadsheet wants rows, and most YAML files are a tree with one list somewhere inside them. This finds that list and makes it the table, one row per item, and tells you which top-level keys were left behind so you can switch to single-row mode if you wanted all of it. Anchors are expanded first, so repeated blocks arrive as full rows.
The page starts with YAML to CSV selected.
Paste the YAML, or press Open file and pick the .yaml file.
Keep Find the list selected so the list inside the file becomes the rows, or press One row to keep every top-level key instead.
Choose Semicolon under Separator if your spreadsheet expects semicolons rather than commas.
Check the Table preview, then press Download CSV to save a file that opens in Excel.
This converter moves structured data between JSON, YAML, XML, CSV, TSV, TOML and INI in every direction that makes sense: forty of the forty-two possible pairs. Paste the data or open the file and it works out which format it is from the content itself, not from the name on the end of it, then offers the conversion people usually want next. If the guess is wrong, one tap fixes it.
The difficult part is not parsing. It is being honest about shape. CSV and TSV are rows of columns; JSON, YAML, TOML and XML are values inside values; INI is one flat level of named sections. Moving between those shapes always decides something on your behalf, so every conversion prints one line saying what it decided: which list became the rows, which nested objects became dotted columns such as address.city, which keys were left out and why. A list inside a cell becomes JSON text rather than disappearing.
Excel is a way in and a way out rather than an eighth format. Open an .xlsx and one sheet is read in your browser and shown as CSV, so you can see exactly what will be converted; choose Excel in the To row and the result is saved as an .xlsx with typed cells, a bold header row and fitted column widths. XML to Excel is the common case: the repeating element becomes the rows, exactly as it does for CSV.
The rest of the article, and all 8 questions about Data Converter, are on the Data Converter page.
JSON, YAML, XML, CSV, TSV, TOML and INI, in forty of the forty-two possible directions. The two it refuses are CSV to INI and TSV to INI, because INI holds named sections and spreadsheet rows have no names, so every row would need an invented heading such as [row_1].
A spreadsheet needs rows, so the converter looks for the list that is the table. A JSON array of objects becomes one row per object. If the array sits inside an object, that array is used and the other top-level keys are named so you can see exactly what is not in the sheet. Nested objects become dotted columns such as address.city.
Both. Drop or open a .json, .yaml, .xml, .csv, .tsv, .toml, .ini or .cfg file and it is read on your device. The format is worked out from the content rather than the extension, so a file saved with the wrong name is still read correctly, and the tool says when the name and the content disagree.
Yes. Choose Excel in the To row and press Download Excel: the table is saved as an .xlsx with a bold header row, real numbers and dates, and codes like 007 kept as text. To go the other way, open an .xlsx of up to 10 MB; one sheet is read in your browser and shown as CSV, ready to become XML or JSON. Formulas come across as their saved results.
Still stuck? Ask about Data Converter and anybody who knows can answer. No account needed.
Same job, other tools: JSON to YAML – Turn JSON into clean, readable YAML for configs · YAML Validator – Check YAML syntax and see the exact line and column of each error · TSV to JSON – Convert tab-separated values, such as a paste from Excel, into JSON.
In the collections JSON Tools · Developer Converters.