YAML to Excel Converter Online Tool

Input

Output

Excel output is a binary .xlsx file. Use Download to save the workbook. Copy is not available for this format.

Table Editor

3 rows × 3 columns

#
1
2
3

YAML to Excel

Turn a YAML list of records into an Excel .xlsx workbook. Each list item becomes a row, and the keys become column headers.

The download is one worksheet named Sheet1. .xlsx is the Office Open XML workbook defined by ECMA-376. Excel, Google Sheets, and LibreOffice open it. Microsoft lists it among the file formats Excel supports.

The input is a YAML sequence of mappings. YAML’s structure is specified in the YAML 1.2.2 spec. Keys from the first record form the header row.

Cells are stored as text, so a code like 001 is not shortened into a number. Formula-like text such as =1+1 is stored as text and is not calculated on export.

Steps

Paste YAML that starts with - key: value records, or upload a .yaml / .yml file.
Set the input format to YAML and the output format to Excel.
Check the grid. Add a missing value in the Table Editor if one record omitted a key.
Click Download to save table.xlsx.

FAQ

Q: How do I convert YAML to Excel?

Paste a list of records, select Excel as the output, and download the .xlsx workbook.

Q: What YAML shape is required?

A sequence of mappings, one record per - item. A single mapping without a list is not a table.

Q: Are nested objects expanded?

This converter reads one level of keys on each list item. Put the values you want in the sheet on that level.

Q: Is the YAML uploaded?

No. The workbook is built locally in your browser.

Part of tool topic

Table Tools - CSV, JSON & Markdown

Tool Chain Recommendation

After working with your table, you may also want to convert it to another format.

YAML to CSV

Online YAML to CSV converter, quickly convert YAML data to CSV format, with copy and download support

After working with your table, you may also want to convert it to another format.

YAML to HTML Table

Online YAML to HTML table converter, quickly convert YAML data to HTML table format, with copy and download support

After working with your table, you may also want to convert it to another format.

YAML to JSON

Online YAML to JSON converter, quickly convert YAML data to JSON format, with copy and download support

After working with your table, you may also want to convert it to another format.

YAML to LaTeX Table

Online YAML to LaTeX table converter, quickly convert YAML data to LaTeX table format, with copy and download support

After working with your table, you may also want to convert it to another format.

YAML to Markdown Table

Online YAML to Markdown table converter, quickly convert YAML data to Markdown table format, with copy and download support

After working with your table, you may also want to convert it to another format.

YAML to SQL INSERT

Online YAML to SQL INSERT converter, quickly convert YAML data to SQL INSERT statements, with copy and download support

After working with your table, you may also want to convert it to another format.