JSON to Excel Documentation

JSON to Excel Documentation

Note: This documentation could be updated at any time, visit  http://blog.wtsolutions.cn/archives/522 for the latest 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 “add” 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

1. Prepare your JSON data

2. Fill the text area of JSON-to-Excel with your JSON data

3. Select conversion mode

3.1 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.
3.2 Advanced Mode

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

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

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

4. Click on one and ONLY one cell of the target datasheet

5. Click on “Go” button

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 byhe.yang@wtsolutions.cn from WTSolutions.

© 2017, WTSolutions Blog. All rights reserved. 本文如未特别注明，均为原创文章，如需转载请注明出处。