WPS Add-in (JSON-to-Excel WPS Add-in)

中文

JSON-to-Excel by WTSolutions is a toolkit of tools which can convert JSON to Excel, both Flat and Nested JSON can be converted to Excel. It offers a full-scenario solution for “Converting JSON to Excel”, including Excel add-ins, WPS add-ins, web applications, API service and MCP service.

• Web Based Solutions

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

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

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

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

  • MCP Server: Convert JSON to Excel in MCP Server

• Localized Solutions

  • Localized App: Convert JSON to Excel in Localized App, works without Internet Connection

  • Localized Excel Add-in, Coming soon.

  • Localized WPS Add-in, Coming soon.

Requirements

• WPS on Windows, Latest version

• WPS on Linux, Latest version.

Access

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

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

Video Guide to Get add-in

Available only in Simplified Chinese.

Usage

• Prepare your JSON data

• In the Conversion Settings, select conversion mode etc.

• Load your JSON data (Choose one of the following two ways)

  1. Copy and Paste your JSON data in the text area, or

  2. Click on the Load JSON File(s) file selector, and select your JSON file(s) from your local computer, for batch processing, max 20 files can be loaded at once.

• Click on Go button

• Your JSON data will be converted to WPS, and you can find one newly added sheet to your WPS.

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

Using WPS add-in is the same as using Excel add-in, refer to the following video guide.

Refer to the following video for a simple demo of using WPS add-in, available only in Simplified Chinese.

JSON Data and Conversion Settings

Refer to JSON Data and Conversion Settings for more details.

Limitations

• Maximum 1000 objects (rows) per conversion

• Maximum 100 unique properties (columns) per dataset

• Arrays in values will be converted to strings in WPS

• Maximum 20 loaded local JSON files can be converted at once