Local Excel Add-in (JSON-to-Excel Localized 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
Localized Solutions
Localized App: Convert JSON to Excel in Localized App, works without Internet Connection
Localized Excel Add-in, Convert JSON to Excel in Localized Excel, works without Internet Connection.(<– You are here)
Localized WPS Add-in, Coming soon.
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 JSON data
In the Conversion Settings, select conversion mode etc.
Load your JSON data (Choose one of the following two ways)
Copy and Paste your JSON data in the text area, or
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