DataShift

Convert Excel to YAML Online

Turn a spreadsheet into a YAML list — useful for generating config files from tabular data.

Excel → YAML

Free Excel to YAML converter. Upload .xlsx and get a YAML sequence of mappings, one per row. Works in your browser.

100% local — no uploads
Input · EXCEL

Output will appear here

How to use the Excel → YAML

  1. Paste or upload your EXCEL data

    Paste text directly into the input box, drag and drop a file onto it, or click "Upload file" to browse. Conversion starts instantly on paste — no button click required.

  2. Configure options (optional)

    Open the Options panel to customise delimiter, headers, nested-object flattening, and more. Use the Field Selector to pick exactly which columns appear in the output.

  3. Copy or download your YAML

    Click Copy to grab the result, or Download to save the file. Everything runs locally in your browser — no data ever leaves your device.

Frequently Asked Questions

Is my data safe?
Yes. Every conversion runs entirely inside your browser. No data is ever transmitted to a server. The tool works offline once loaded.
What is the maximum file size?
There is no hard limit. Files under 1 MB convert instantly. Files 1–10 MB show a progress indicator. Files over 10 MB prompt a warning and run in a background thread to keep the browser responsive.
Why does my EXCEL fail to parse?
Common causes are trailing commas, single-quoted strings, unquoted keys, or missing closing brackets. The converter auto-repairs many of these and tells you exactly what it changed.
Can I convert multiple files at once?
The tool handles one file at a time. For bulk conversion, consider the csvjson CLI or API.

How it works

Step 1

Each row becomes a YAML list item

The spreadsheet header row becomes YAML mapping keys. Each data row becomes one item in the YAML list. Sheet name is used as the top-level key for multi-sheet workbooks.

Example

Server list spreadsheet to Ansible inventory YAML

Input
hostname | ip       | role
web-01   | 10.0.1.1 | web
db-01    | 10.0.1.2 | db
Output
- hostname: web-01
  ip: 10.0.1.1
  role: web
- hostname: db-01
  ip: 10.0.1.2
  role: db

Frequently asked questions

Can I convert just one sheet from a multi-sheet workbook?

Yes. A sheet picker appears for multi-sheet workbooks so you can select which sheet to convert.

Related Tools

XLS{ }
Excel → JSONUpload an .xlsx file and get clean JSON back — with multi-sheet support, type inference, and sensible handling of merged cells and blank rows.
YML{ }
YAML → JSONParse Kubernetes manifests, Docker Compose files, CI/CD configs, and any YAML into clean JSON. Anchors, aliases, and multi-document YAML all handled.
CSVYML
CSV → YAMLTurn a spreadsheet or CSV export into a YAML list — useful for config files, fixture data, and Ansible inventories.

All conversions run in your browser — nothing is uploaded.

Browse all 26 converters →