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:

Excel to JSON

convert Excel to JSON

Excel to JSON converter

Example Excel input:

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 large number 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 45 transforms (such as join, filter and dedupe) to quickly and easily create complex data transformations. See our quick start guide for more details.

convert Excel to JSON

Try it free now!

Windows Logo Windows Download

v1.8.2 for Windows 10 / 8 / 7 (49 MB)

Apple Logo Mac Download

v1.8.2 for Mac 10.15 to 10.12 (23 MB)


Questions or problems?

Email support@easydatatransform.com


Do you have a question?
We would love to help.

This pop-up will not be shown again