Convert YAML to XLSX

Turn YAML files into XLSX. One sheet named after the file, cut to 31 characters.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop YAML files on the dialor turn it to pick what to do

A sheet with one row per object.A list of objects in YAML becomes rows in an Excel sheet, under one header.

  1. What you get

    One XLSX file with a single sheet. The sheet is named after the file and cut to 31 characters.

    A list of objects becomes one row per object. The header holds every key in the order it was first seen. A single object becomes one row.

    If the YAML file holds several documents, they are treated as a list.

  2. How values are written

    Numbers, true and false, and plain dates become typed cells. Words like yes and no, on, and codes with a leading zero such as 0755 stay text.

    Nested objects and lists are written into their cell as JSON text. A null leaves the cell empty.

  3. What changes or is left out

    Comments are dropped. Aliases are expanded, so each place that used one gets the full value.

    A merge key (<<) is not merged. It is kept as an ordinary key, so it appears as its own column.

    For other conversions, see every YAML conversion.

YAML and XLSX.What each format is.

The formats

From · YAML

YAML

YAML configuration and data files.

Extensions
.yaml .yml
MIME type
application/yaml
Kind
Text and data
To · XLSX

Excel Workbook

Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.

Extensions
.xlsx
MIME type
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Kind
Documents

In your code.The same YAML to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.yaml report.xlsx
$ cv convert report.yaml report.xlsx

Questions.What people ask about YAML to XLSX.

01OF 04

It takes the name of the file and is cut to 31 characters.

They are written into their cell as JSON text. The nested data is not spread over extra columns or sheets.

Yes. Codes with a leading zero stay text, and so do yes, no and on.

No. Comments are dropped.

More conversions.Other ways in and out of YAML and XLSX.