Localized Excel Add-in (Excel to JSON in Excel Offline Conversion)

中文

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

  • 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. (<– You are here)

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

Note

Currently, Excel-to-JSON Localized Excel addin is in public test. 
If you have difficulties using it, email he.yang@wtsolutions.cn

Requirements

System Requirements

• Windows 10 or above

• MacOS 11 or above

Excel Requirements

• Excel 2013 Service Pack 1 or later,

• Excel 2016 for Mac,

• Excel 2016 or later,

• Office 365 etc.

Download, Installation and Access

• For Windows User, please refer to Usage Guide

• For MacOS User, please refer to Usage Guide

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