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 (including nested 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 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 .xlsx or .xls file you wish to convert onto Easy Data Transform. If there is more than 1 worksheet with data, you will be asked which worksheets to import - choose the one you wish 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 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.

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"
  }
]

To output values as nested JSON see the JSON documentation.

If you have lots of 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 61 transforms (such as join, filter and dedupe) to quickly and easily create complex data transformations.