How to convert Excel to JSON

Excel and JSON are very different formats, but you can quickly convert Excel .xlsx or .xls files to JSON 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 .xlsx or .xls 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 JSON file as the file type.

• A green output item is added and selected.

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

Example Excel input:

Example JSON 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 complex data transformations.