Product Introduction
JSON to Excel by WTSolutions is a powerful tool that can quickly convert JSON data into Excel format. The tool offers two usage methods: as a Microsoft Excel add-in or as an online web application, catering to the needs of different users. Whether dealing with simple flat JSON or complex nested JSON structures, this tool can handle them effortlessly and supports export to the standard XLSX file format.
Main Features and Uses
Core Features
- Dual Format Support: Supports both Flat JSON and Nested JSON conversion
- Cross-Platform Usage: Can be used as an Excel add-in on Windows, Mac, and Excel Online, and also accessible directly through the web application
- Flexible Configuration: Provides various conversion settings, such as the selection of key separators for nested JSON, control over the maximum depth of nested structures, etc.
- Data Preview: Allows previewing JSON data before conversion and viewing the generated Excel table after conversion
Applicable Scenarios
- Data analysts need to convert JSON data returned by APIs into Excel for further analysis
- Developers need to process JSON-formatted configuration files or data and share them with non-technical personnel in Excel format
- Researchers need to convert research data in JSON format into a more manageable tabular form
- Any scenario that requires converting JSON data into a structured table
Latest Update: URL Batch Conversion Function
Feature Highlights
This update brings an important Pro version feature: batch conversion of JSON files to Excel via URLs. Users can now directly load JSON files from network URLs for conversion without first downloading them to the local device, greatly improving work efficiency.
Feature Characteristics
- Supports loading JSON files from multiple URLs simultaneously (up to 20 URLs)
- Each URL must point to a .json format file
- Supports batch input with one URL per line
- Processed files can be uniformly exported to XLSX format
Usage Method
- Select “Load JSON File(s) from URL [Pro]” in the “JSON Data Source” drop-down menu
- Enter one or more URLs of JSON files in the text box (one URL per line)
- Click the “Go” button to start the conversion
- After the conversion is completed, you can preview the data and export it to XLSX format
Pro Version Features and Pricing
The URL batch conversion function is part of the professional version (Pro). The Pro version also includes other advanced features:
- Multiple options for nested JSON key separators (dot, underscore, double underscore, slash)
- Control over the maximum depth of nested structures (levels 1-20)
- Batch import of local files (up to 20 files)
The Pro version offers a 7-day free trial.
How to Get Started
- Web Application: Directly visit the JSON to Excel Web Version to use it
- Excel Add-in: Sideload the application in Excel according to the Documentation Guide
- View Examples: Visit Examples and Documentation to learn more usage methods
Summary
JSON to Excel by WTSolutions is an efficient and flexible JSON data conversion tool. The newly added URL batch conversion function further enhances its practicality, making it especially suitable for users who need to process network JSON data. Both individual users and enterprise users can enjoy an efficient data processing experience from it.