How to convert Excel to YAML

You can easily convert Excel .xls or .xlsx files to YAML (.yml) format with Easy Data Transform:

• Download and install Easy Data Transform on your PC or Mac, if you haven’t done so already. It will only take a minute. There is a fully functional free trial and you don’t have to give us your email or sign up to anything.
• Start Easy Data Transform. Make sure the Auto Run button is pressed in.

• Drag the Excel .xls or .xlsx file you wish to convert onto Easy Data Transform. If there are multiple sheets in the Excel file, choose the one you want to convert. A pink input item will be added.
• Ensuring the pink input item is selected, click the To File button in the Left pane (scroll to the bottom of the Left pane).

• A window will appear. Set the new file name and location. Select YAML file as the file type.

• A green output item is added and selected.

• The YAML file is created immediately, no need to ‘run’ anything.
• You can change the YAML file Encoding in the Right pane.

Example Excel input:

Example YAML output:

--
-
  CustomerID: ALFKI
  CompanyName: Alfreds Futterkiste
  ContactName: Maria Anders
-
  CustomerID: ANATR
  CompanyName: Ana Trujillo Emparedados y helados
  ContactName: Ana Trujillo
-
  CustomerID: ANTON
  CompanyName: Antonio Moreno Taquería
  ContactName: Antonio Moreno

If you have many files to convert you can do it using the batch processing feature.

As well as changing file format, Easy Data Transform also allows you to combine 66 transforms (such as join, filter and dedupe) to quickly and easily create a wide range data transformations.