Format Code Now
/
ConvertYAML to Excel Next: CSV to JSON ›

YAML to Excel Converter

CV-130

Paste a YAML list of items, such as users, servers or test cases, and download an .xlsx workbook with one row per item and one column per key. Nested keys become their own columns.

Runs in your browser. Nothing is uploaded.

YAML

Excel file

Paste YAML to build the workbook.

How to use it

  1. Paste your YAML on the left, or press Open file to load a .yaml or .yml file. Press Sample to try it.
  2. Check the preview of the first rows and columns on the right.
  3. Choose One column per field to flatten nested values, or JSON text in one cell to keep them together.
  4. Press Download .xlsx and open the file in your spreadsheet program.

What YAML shapes work

A top-level list of mappings gives one row per item. A mapping with a single key that holds the list, such as people: followed by the items, works the same way and names the sheet after that key. A single mapping gives one row. Items that are plain values instead of mappings go in a column named value. Anything else, such as one bare string, gets a clear error.

Nested values and lists

With One column per field, nested mappings become columns named by their path, such as address.city, and lists become numbered columns, such as tags[1] and tags[2]. With JSON text in one cell, each nested mapping or list stays together as compact JSON in a single cell, which keeps the sheet narrow. Keys appear as columns in the order they are first seen, and an item without a key gets an empty cell.

Types are kept as YAML defines them

The YAML is read with js-yaml using the YAML 1.2 core schema plus << merge keys. Unquoted numbers become number cells and true or false become Excel TRUE and FALSE. An integer too long for a JavaScript number, such as a 20-digit ID, is kept as exact text instead of being rounded. Dates are not converted, so 2026-01-15 stays as the text you wrote. Quoted values always stay text, including "00117".

Error messages and what to do

MessageWhat it meansFix
Expected a YAML list of mappings (items starting with "- "), or one mapping. Found a single value.The whole input is one plain value, such as a single word or number, so there are no rows or columns to make.Write each item as a list entry that starts with a dash and holds key: value pairs, as in the Sample.
The YAML list is empty, so there are no rows to convert.The input is an empty list, such as [] or a key with no items under it.Add at least one item to the list.

Questions people ask

How do I convert YAML to an Excel spreadsheet?

Paste a YAML list here, where each item is a set of key: value pairs, and press Download .xlsx. Each item becomes a row and each key becomes a column, with the header row in bold. The preview shows the first rows before you download.

Why did 00117 turn into 117?

In YAML, an unquoted 00117 is read as the number 117, so the leading zeros are already gone when the file is parsed. Put the value in quotes, as "00117", and it stays text with its zeros in the spreadsheet.

Are long numbers rounded?

No. Integers longer than JavaScript can hold exactly, above 9,007,199,254,740,991, are kept as text with every digit. Shorter integers and decimals become number cells you can sum. Excel itself shows at most 15 significant digits of a number cell.

Does it work with docker-compose or Kubernetes files?

It reads any single YAML document, but config files are mostly nested settings rather than lists of records, so you may get one wide row. It suits lists of similar items. Files with several documents separated by --- give an error; convert one document at a time.

Is my YAML sent to a server?

No. The YAML is parsed and the workbook is built by your browser on this device. Nothing is uploaded, and no copy is kept anywhere.

About this tool

Reads YAML with js-yaml (core schema plus << merge keys). A top-level list, or a mapping whose only key holds a list, gives one row per item; a single mapping gives one row. Nested mappings become columns such as address.city and lists become tags[1], tags[2], or you can keep each nested value as JSON text in one cell. Numbers and true/false keep their type; integers too long for a JavaScript number stay as exact text. Dates stay as the text you wrote. Quoted values stay text, so write "00117" in quotes to keep leading zeros. Comments are dropped and anchors are expanded into their values.

Format Code Now: free, no ads, no accounts. Your input stays in your browser.