Excel Add-in (Excel to JSON in Excel)

中文

Excel to JSON by WTSolutions is a series of tools which can convert Excel to JSON, both Flat and Nested JSON can be converted. It offer a full-scenario solution for “Converting Excel to JSON”, including Excel add-ins, web applications, open APIs, and enterprise-grade MCP tools:

• Web Based Solutions

  • Web App: Convert Excel to JSON directly in Web Browser.

  • Excel add-in: Convert Excel to JSON in Excel, works with Excel environment seamlessly. (<– You are here)

  • WPS add-in: Convert WPS workbook to JSON in WPS, works with WPS environment seamlessly.

  • API: Convert Excel to JSON by HTTPS POST request.

  • MCP Service: Convert Excel to JSON by AI Model MCP request.

• Localized Solutions

  • Local App: Convert Excel to JSON directly in Local Computer, works without Internet Connection.

  • Local Excel add-in: Convert Excel to JSON in Local Excel, works with Local Excel environment seamlessly without Internet Connection.

  • Local WPS add-in: Convert WPS workbook to JSON in Local WPS, works with Local WPS environment seamlessly without Internet Connection.

Requirements

• Excel 2013 Service Pack 1 or later,

• Excel 2016 for Mac,

• Excel 2016 or later,

• Excel Online,

• Office 365 etc.

Access

• Open a new datasheet in Excel 2013/2016 or Excel Online or Office 365 etc.

• Home Tab or Insert Tab > Add-ins

• In the search box, type in “Excel to JSON”

• Follow the instructions on the screen to install the add-in, and you will see an button “Convert” with Excel to JSON logo added to your Home Tab.

• Home Tab > Excel to JSON > Convert

• Now you are ready to use this add-in.

Video Guide to Get Excel add-in (side-load in Excel)

Usage

• Prepare your Excel sheet

• Click on “Convert” with Excel to JSON logo on the Home Tab

• Choose Excel DataSource

  • Manually select your data directly from Excel worksheet, or

  • Let Excel to JSON to convert all visible sheets from Excel, or

  • Let Excel to JSON to convert all sheets from Excel.

• Set Conversion Settings

• Click on “Go” button

• You will later see the converted JSON below the “Go” button. 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 a textarea, and you can simply copy and paste them anywhere you want.

  • Copy to Clipboard. Once JSON generated, you can find the “Copy to Clipboard” button, click on the button, and you will have JSON on your clipboard.

  • Save to File.(Not available to Excel for Mac users) Once JSON generated, you can find the “Save As” button, click on the button, and you will be prompted to save the JSON to a file.

Conversion Settings

Refer to Conversion Settings for details.

Video Guide to Use Excel add-in and Web App