Convert Excel to JSON within Excel

In this blog post, a free solution for converting Excel to JSON is presented.

Excel-to-JSON add-in

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

Works with

1. Excel 2016 or higher, or
2. Office 365, or
3. Excel Online

Advantage

1. Free
2. No download
3. No installation
4. Load only when needed
5. Load within Excel
6. No need coding in Python/JavaScript (for example)

Excel-to-JSON add-in

How to load this add-in

Documentation

Video guide

Steps

1. Go to Excel 2016, Office365 or Excel Online.
2. Insert Tab > My Add-ins.
3. In the popup window, go to Office Store
4. Search “Excel-to-JSON”.
5. Add this add-in
6. After loading, go to the “Excel-to-JSON” tab.
7. Now you are ready to use this add-in.

How to use this add-in

Documentation

Video guide

Example

Example Excel sheet - Source

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

Example JSON - Output

[
    {
        "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"
    }
]