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

  • Excel 2016 or higher, or
  • Office 365, or
  • Excel Online

Advantage

  • Free
  • No download
  • No installation
  • Load only when needed
  • Load within Excel
  • No need coding in Python/JavaScript (for example)

Excel-to-JSON add-in

How to load this add-in

  • 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.

Now you are ready to use this add-in.

How to use this add-in

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

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
[
    {
        "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"
    }
]