WTSolutions Blog

WTSolutions provides solutions for water and wastewater technologies

JSON to Excel Documentation

Introduction

JSON to Excel is a Microsoft Excel add-in which can convert JSON to Excel.

Requirements

This add-in works in: Excel 2013 Service Pack 1 or later, Excel 2016 for Mac, Excel 2016 or later, Excel Online.

Quick Started

Get add-in

  • Get it from Office Store link https://store.office.com/en-001/app.aspx?assetid=WA104381080
  • Click on the above link and, you will see the webpage of JSON to Excel on Office Store.
  • Click on the “Free Trial” button.
  • The next page you will see will show that you can open the add-in in Excel/Excel Online.
  • Now go to Excel 2013/2016 or Excel Online.
  • JSON-to-Excel Tab > Launch JSON to Excel
  • Now you are ready to use this add-in.

Use add-in

  • Prepare your JSON data
  • Fill the text area of JSON-to-Excel with your JSON data
  • Select conversion mode

Simple Mode

Note, for the simple mode, only regular JSON data can be handled. Only the keys in the first element of JSON will be interpreted as header.
Apart from the above box, nothing should be worried.

[
    {
        "name":"David",
        "age":20
    },
    {
        "name":"Lily",
        "age":22
    }
]

Advanced Mode

Note, for the advance mode, you must fill in the “headers for advanced mode”

  • If you would like to have “id”,”detail.name” and “detail.sex” included , then fill in id,detail.name,detail.sex
  • If you would like to have “detail.name” and “detail.age” included, then fill in detail.name,detail.age
  • Click on one and ONLY one cell of the target datasheet
  • Click on “Go” button

Example JSON

[
    {
        "id":1,
        "detail":{
            "name":"David",
            "age":10,
            "sex":"male",
            "contact":{
                "cell":139,
                "landline":10
            }
        }
    },
    {
        "id":2,
        "detail":{
            "name":"May",
            "age":20,
            "sex":"female",
            "contact":{
                "cell":158,
                "landline":20
            }
        }
    },
    {
        "id":3,
        "detail":{
            "name":"Harry",
            "age":30,
            "sex":"male",
            "contact":{
                "cell":189,
                "landline":10
            }
        }
    }
]

Privacy

This Add-In will not collect and/or transmit user information. Baidu Tongji (similar to Google analytics) scripts is added for website analytics.

Disclaimer

Backup your documents before using this add-in.

About

JSON-to-Excel is an Excel add-in that convert JSON to Excel. It is maintained by he.yang@wtsolutions.cn from WTSolutions.