WPS Add-in (WPS to JSON in WPS)

中文

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, WPS 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.

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

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

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

  • 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

• WPS Windows, latest version

• WPS Linux, latest version

Access

• There are several steps to get WPS add-in (side-load in WPS)

• Visit https://wps-workbook-to-json.wtsolutions.cn/publish.html for detailed steps. (avalibale only in Simplified Chinese)

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

Available only in Simplified Chinese.

Usage

• Click on “Launch Excel to JSON by WTSolutions WPS add-in” with Excel to JSON logo under the “Excel to JSON by WTSolutions WPS add-in” Tab

• Choose DataSource

  • Manually select your data directly from WPS worksheet

• 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. 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 WPS add-in

Refer to the following video (for Excel add-in). Using WPS add-in is similar to using Excel add-in.

Refer to the following video in simplified Chinese for simple demo of using WPS add-in.