Skip to content

XLSX to YAML Converter

Convert a Microsoft Excel (.xlsx) file into YAML. Upload a spreadsheet, pick a sheet, and get a YAML list of objects keyed by the header row.

Category: data
Use Case: Config Files, Ansible Playbooks, CI/CD Pipelines
Privacy: 100% browser-based

Click to upload an .xlsx file

Your file is processed entirely in your browser

Recommended Settings

Pro Tips

  • The first row of the sheet is used as YAML keys - each subsequent row becomes one list item
  • Empty cells are converted to null so the YAML structure stays consistent across rows
  • If your workbook has multiple sheets, switch between them with the Sheet selector - each one converts independently
  • YAML preserves key order from the original sheet, so column order in Excel controls field order in the output
  • The whole file is read and converted locally in your browser - nothing is uploaded anywhere

Most Popular

Most users convert the first sheet into a YAML list of objects for config files or automation scripts

When to Use This Tool

Config Files

Maintain application configuration in a spreadsheet for non-technical editors, then export it as YAML for your app to load.

Ansible Playbooks

Convert a spreadsheet of hosts, variables, or inventory data into YAML for use in Ansible playbooks or inventory files.

CI/CD Pipelines

Turn spreadsheet data into YAML for GitHub Actions, GitLab CI, or Kubernetes manifests that read structured YAML input.

Data Fixtures

Generate YAML test fixtures from a spreadsheet of sample data instead of hand-writing YAML by hand.

How It Works

1

Read the uploaded .xlsx file as binary data directly in your browser

2

Parse the file into a workbook using the SheetJS library, extracting all sheet names

3

Convert the selected sheet into an array of objects, using the header row as keys

4

Serialize the array into YAML using the js-yaml library

5

Display the resulting YAML, ready to copy or download

100% Private

Files never leave your device. All processing happens locally in your browser.

Lightning Fast

Powered by SheetJS (xlsx) + js-yaml for optimal performance on modern browsers.

Open Source

Built with verified, open-source libraries. Fully transparent.

Frequently Asked Questions

Can I convert a workbook with multiple sheets?

Yes. After uploading, use the Sheet selector to choose which sheet to convert. Each sheet is converted independently.

What happens to empty cells?

Empty cells are converted to null in the YAML output, rather than being omitted, so every item keeps the same shape.

Is my spreadsheet uploaded to a server?

No. The entire file is read and converted locally in your browser using the SheetJS library. Your data never leaves your device.

What happens to formulas in my spreadsheet?

Formulas are converted using their last calculated value, not the formula text itself, since YAML has no concept of spreadsheet formulas.

Does the output preserve number and boolean types?

Yes. Numeric and boolean cells are output as native YAML numbers and booleans (not quoted strings), matching how they were stored in the spreadsheet.