JSON to Excel v3.0.0 from Excel addin to Web application

1. Introduction

JSON to Excel 3.0.0 is a major update that expands the original Excel add-in into a full-fledged web application. You can now use it directly in your browser without installing any plugins. All conversions are performed in the browser. After previewing, you can click the download button to export the file in xlsx format. Of course, we still recommend using it as an Excel add-in for better integration with other Excel features.

2. Key Features

2.1 Basic Features

• Convert JSON data to Excel format
• Supports both flat and nested JSON structures
• Automatic data type recognition

2.2 Professional Features

• Supports batch processing of multiple JSON files
• Custom nested delimiters: supports dot (.), underscore (_), double underscore (__), and slash (/)
• Maximum nesting depth: Set the maximum flattening depth for JSON objects, ranging from 1 to 20, or choose unlimited depth

3. How to Use

3.1 Web Version

• Open your browser and visit https://s.wtsolutions.cn/json-to-excel.html
• Paste JSON data or upload a JSON file
• Click the “Convert” button
• Download the Excel file if needed

3.2 Excel Add-in Version

• Open a new worksheet in Excel 2013/2016, Excel Online, or Office 365.
• Home tab or Insert tab > Add-ins
• In the search box, type “JSON to Excel”
• Follow the on-screen instructions to install the add-in. You’ll see a button named JSON-to-Excel in the Home tab.
• Home tab > JSON to Excel > Convert
• You’re now ready to use the add-in.

4. Video Examples

Video Recorded Based on Older Version

Video Demonstrating Batch Processing of Multiple JSON Files to Excel