How to convert JSON to Excel

JSON and Excel are both extensively used for storing and exchanging data. They are very different in structure (JSON is text structured as a tree and Excel is proprietary data structured as one or more tables). But you can easily convert JSON to Excel with Easy Data Transform:

Auto run on

JSON to Excel

convert JSON TO Excel

JSON to Excel converter

Example JSON input:

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

Example Excel output:

Excel from JSON

The dot (‘.’) character is used to show nesting of JSON values. For example:

    "name": "Avocado Dip",
    "carb": "2",
    "cholesterol": "5",
    "fiber": "0",
    "minerals": {
      "ca": "0",
      "fe": "0"
    "protein": "1",
    "sodium": "210",
    "vitamins": {
      "a": "0",
      "c": "0"

Will be ‘flattened’ into Excel as:

flatten nested JSON

Use the Rename Cols transform before output if you want to rename any of the columns.

If you have a large number of files to convert you can do it using the batch processing feature to do it in one operation.

As well as changing file format, Easy Data Transform also allows you to combine 66 transforms (such as merge, filter and de-dupe) to quickly and easily create complex data transformations.

JSON to Excel

Try it free now!

Windows Logo Windows Download

v1.46.5 for Windows 11 / 10 / 8 / 7 (47 MB)
Zip file version

Apple Logo Mac Download

v1.46.5 for Mac 14.x to 10.13 (79 MB)

No commitments.
You can uninstall any time.
You don't even have to give us your email address.

Questions or problems?