How to convert Excel to YAML

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

• 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 fuctional free trial and you don’t have to give us your email or sign up to anything.
• Start Easy Data Transform.
• Drag the Excel .xls or .xlsx file you wish to convert onto Easy Data Transform. 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

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