JSON-to-Excel Batch Conversion v2.1.2 New Features

Introduction

JSON-to-Excel is a powerful Excel add-in designed for users who need to process JSON data. The latest version (v2.1.2) introduces batch conversion functionality, making data processing more efficient and convenient. This article will detail three core features of this functionality.

Core Features

1. Privacy Protection: In-Excel Conversion

In today’s world where data security is increasingly important, JSON-to-Excel adopts a completely localized conversion solution:

• All data conversion processes occur entirely within Excel
• No internet connection required, no data transmission to external servers
• Ensures your sensitive data remains under your control

2. Efficient Batch Processing

A major highlight of the new version is its batch processing capability:

• Select multiple local JSON files at once (up to 20)
• Automatically process all selected files in sequence
• No repetitive operations, significantly improving work efficiency
• Ideal for scenarios involving large volumes of data files

3. Flexible Data Structure Support

JSON-to-Excel supports two conversion modes to meet different data structure requirements:

Flat JSON Mode

• Suitable for simple single-layer JSON data structures
• Directly maps JSON key-value pairs to Excel spreadsheets
• Simple operation, fast conversion

Nested JSON Mode

• Supports complex JSON structures with multiple nested levels
• Automatically expands nested levels while maintaining data relationships
• Customizable nested delimiters (dot, underscore, or forward slash)
• Configurable maximum nesting depth (0-20 levels)

Access the Plugin

You can obtain the JSON-to-Excel plugin following the guide in video below:

Video Demo

Converting 3 JSON example files to Excel, a video demo with JSON-to-Excel addin

How to Use

1. Access https://s.wtsolutions.cn/json-to-excel.html
2. Click “Load JSON File(s)” button in the Pro Features section
3. Select JSON files for conversion (multiple selection allowed, up to 20 files)
4. Choose appropriate conversion mode (Flat or Nested)
5. Configure conversion parameters as needed (delimiter and max depth for nested mode)
6. Click “Go” button to start conversion

Conclusion

The batch conversion functionality of JSON-to-Excel brings significant efficiency improvements to data processing work. Through local conversion ensuring data security, batch processing improving efficiency, and flexible mode selection adapting to different data structures, JSON data conversion becomes an effortless task. Whether you’re a data analyst, developer, or business professional, you can benefit from this functionality.

Learn More

• Official Documentation: JSON-to-Excel Documentation