Usage

This documentation is written for Excel-to-JSON version 1.4.0.0

Reading Get Started section first is strongly recommended.

Line break in an Excel cell will be rendered as <br>

Conversion

	Note that you should select at least two rows as the first row will be considered as header.

• This add-in will first collect all selected data in the active sheet.

• The first row will be interpreted as header.

• The following rows will be mapped with header as you can see in the following example.

Example Excel sheet

Name	Age	Company
David	27	WTSolutions
Ton	26	WTSolutions
Kitty	30	Microsoft
Linda	30	Microsoft
Joe	40	Github

Example JSON

[
    {
        "Name": "David",
        "Age": 27,
        "Company": "WTSolutions"
    },
    {
        "Name": "Ton",
        "Age": 26,
        "Company": "WTSolutions"
    },
    {
        "Name": "Kitty",
        "Age": 30,
        "Company": "Microsoft"
    },
    {
        "Name": "Linda",
        "Age": 30,
        "Company": "Microsoft"
    },
    {
        "Name": "Joe",
        "Age": 40,
        "Company": "Github"
    }
]

JSON Output

There are several ways for you to save the generated JSON to your local computer.

• Copy and Paste. Once JSON generated, you will see them in the add-in, and you can simply copy and paste them anywhere you want.

• Copy to Clipboard.(Not applicable to Mac users) Once JSON generated, you can find the “Copy to Clipboard” button, click on the button, and you will have JSON on your clipboard.