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.
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.
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.
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
YAML
YAML configuration and data files.
- Extensions
- .yaml .yml
- MIME type
- application
/yaml - Kind
- Text and data
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.
$ cv convert report.yaml report.xlsx$ cv convert report.yaml report.xlsxQuestions.What people ask about YAML to XLSX.
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.