Micro Tools
Advertisement

XLSX to YAML converter

Convert XLSX to YAML free in your browser. Paste your XLSX on the left, press Convert, and copy clean YAML on the right. No sign-up, no uploads.

Converter

Paste XLSX below, press Convert, and copy the YAML output.

Picking a file reads its first sheet into the input box.

Advertisement

How the spreadsheet becomes YAML

When you pick a file, the SheetJS library reads the first worksheet into a grid in memory, and the first row becomes the column headers for every row below it. That grid is exactly what you see staged in the input box as JSON, and pressing Convert reshapes it into YAML with types preserved from the cells.

Getting the best results

Press Load sample first to see the exact XLSX shape the converter expects, then replace it with your own data. If a conversion errors, the message names the exact line or token at fault, so fixing the input is usually a one-minute job. For repeated jobs, bookmark the page; your data never leaves the browser.

Related tools

JSON formatterFormat and validate JSON, privately. Regex testerTest regex live with highlighting. Base64 encoderBase64 encode and decode, plus URL encoder and JWT decoder.

XLSX to YAML FAQs

Which part of my spreadsheet gets converted?
Upload any .xlsx or .xls file and the tool reads the first worksheet only, using its first row as the column headers. Blank rows are skipped. If your data lives on another sheet, move or copy it to the first sheet before uploading, or paste the cells as a JSON array of arrays.
What YAML shape does the output use?
A list of maps, one per row, with the first key on the dash line: - id: 1 followed by indented keys. Strings that look like numbers or booleans are quoted so they stay strings, and the result parses with PyYAML, js-yaml and Ruby without tweaks.
Do cell types survive the conversion?
Numbers, booleans and text come through with their types, and empty cells become empty strings. Dates arrive as Excel serial values, so format date columns as text in Excel first if you need readable dates in the YAML output.
Is there a size limit for XLSX input?
No hard limit, but everything runs in your browser tab, so tens of thousands of rows convert in seconds while millions of rows may slow the page. For very large XLSX files, split them into smaller chunks and convert each separately.
Is my XLSX data private, and who uses this?
Yes. The conversion runs 100% in your browser with the SheetJS library loaded from CDN; nothing is uploaded to any server. Developers, analysts and DBAs use it to move XLSX data into YAML for migrations, reports and config work without installing anything.
Advertisement