Excel Add-in (JSON-to-Excel Excel 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. (<– You are here)

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

  • 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

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

• Home Tab or Insert Tab > Add-ins

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

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

• Home Tab > JSON to Excel > Convert

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

Video Guide to Get add-in

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 Excel, and you can find one newly added sheet to your Excel.

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

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 Excel

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