json-to-excel

How to Convert JSON to Table in WPS Office - JSON-to-Excel WPS Add-in Complete Guide

In daily data processing work, JSON has become the universal standard for data exchange. However, when we need to analyze, filter, edit, or share JSON data, converting it to a tabular format like Excel or CSV is often the most practical approach. WPS Office, one of the most popular office suites worldwide, offers a great environment for working with tabular data. Many users want to directly convert JSON to tables within WPS.

This comprehensive guide will walk you through using the WTSolutions JSON-to-Excel WPS Add-in to effortlessly convert JSON to tables in WPS Office — including JSON to Excel, JSON to CSV, and how to open and process JSON files.

Why Convert JSON to Tables?

JSON format is widely used for its simple structure and excellent readability in Web APIs, mobile applications, and data storage. But in practice, we often need to convert JSON data to tabular formats to:

  • Analyze and visualize data: Use WPS spreadsheet features for sorting, filtering, and charting
  • Generate financial reports: Transform JSON financial data into standard Excel reports
  • Migrate and share data: Deliver JSON data in tabular format to non-technical stakeholders
  • Process batches: Handle multiple JSON files at once for improved efficiency
  • Export to CSV: Convert JSON to CSV format for compatibility with more applications

JSON-to-Excel Toolkit Overview

WTSolutions JSON-to-Excel is a powerful toolkit for converting JSON to Excel, supporting both flat and nested JSON structures. It provides a full-scenario solution:

Method Best For
Web App Casual use, cross-platform operations
Excel Add-in Users primarily using Microsoft Excel
WPS Add-in Users primarily using WPS Office
API Service Developer automation and integration
MCP Service AI model integration
Local App Offline environment usage

WPS Add-in Features

The WPS add-in is specially designed for WPS Office users, providing seamless integration:

  • ✅ Supports Windows and Linux WPS platforms
  • ✅ Convert JSON data directly within WPS spreadsheets
  • ✅ Supports both flat and nested JSON structures
  • ✅ Flexible conversion modes (Flat / Nested)
  • ✅ Multiple delimiter options (Dot, Underscore, Double Underscore, Forward Slash)
  • ✅ Customizable max nesting depth (1-20 levels)
  • ✅ Batch processing of multiple JSON files
  • ✅ Load remote JSON files via URL

Step 1: Get the WPS Add-in

System Requirements

  • WPS for Windows: Latest version
  • WPS for Linux: Latest version

Installation Steps

Getting the WPS add-in requires a side-load operation:

  1. Visit the official release page: https://json-to-wps-workbook.wtsolutions.cn/publish.html
  2. Follow the detailed steps on the page to complete installation
  3. After installation, you’ll see the JSON-to-Excel button in WPS

Video Tutorial

Watch the video below for a quick overview of the add-in installation process:

Video guide available in Simplified Chinese on the official page

Step 2: How to Open and Convert JSON Files in WPS

After installing the add-in, you can convert JSON data to WPS tables through three methods:

Method 1: Copy & Paste JSON Data

This is the simplest and fastest approach, ideal for single medium-sized JSON datasets:

  1. Prepare JSON data: Ensure your JSON data follows the correct format (array or object structure)
  2. Open WPS Spreadsheet: Create a new blank WPS spreadsheet document
  3. Launch Add-in: Click the JSON-to-Excel button in WPS
  4. Paste Data: Copy and paste your JSON data into the add-in’s text area
  5. Configure Conversion Settings (optional):
    • Select conversion mode: Flat or Nested
    • Set delimiter (nested mode): Dot ., Underscore _, Double Underscore __, or Forward Slash /
    • Set max nesting depth (1-20, default: unlimited)
  6. Click “Go” Button: Wait for conversion to complete
  7. View Results: After conversion, you’ll see a new sheet in WPS containing the converted data

Method 2: Load Local JSON Files

Ideal for larger JSON files or batch conversion:

  1. Prepare JSON Files: Save your JSON data as .json files
  2. Open Add-in: Launch the JSON-to-Excel add-in in WPS
  3. Select Files: Click the “Load JSON File(s)” button and select one or more JSON files from your computer
  4. Batch Processing: Load up to 20 JSON files at once for batch conversion
  5. Click “Go” Button: All selected files will be converted sequentially
  6. View Report: After conversion, a report is generated including:
    • Filename
    • Conversion result (success/failure)
    • Corresponding sheet name
    • Error message (if any)

Method 3: Load JSON Files from URL

Ideal for JSON data stored on remote servers:

  1. Prepare JSON URL: Ensure the JSON file is accessible via a public URL
  2. Open Add-in: Launch the JSON-to-Excel add-in in WPS
  3. Enter URL: Fill in the URL of the JSON file in the URL input field
  4. Batch Processing: Load up to 20 URLs at once
  5. Click “Go” Button: The add-in will automatically download and convert the data

Conversion Modes Explained

Flat Mode

Suitable for simple JSON objects where all properties map directly to columns:

Input JSON:

1
2
3
4
5
[
  {"name": "John", "age": 25, "occupation": "Engineer"},
  {"name": "Alice", "age": 30, "occupation": "Designer"},
  {"name": "Bob", "age": 28, "occupation": "Product Manager"}
]

Output Table:

name age occupation
John 25 Engineer
Alice 30 Designer
Bob 28 Product Manager

Nested Mode

Suitable for JSON with nested structures, automatically expanding nested properties into multi-level columns:

Input JSON:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
[
  {
    "id": 1,
    "student": {
      "name": "Mike",
      "familyname": "Smith",
      "age": 12
    }
  },
  {
    "id": 2,
    "student": {
      "name": "Emma",
      "familyname": "Johnson",
      "age": 15
    }
  }
]

Output with Different Delimiters:

Dot (.) Delimiter:

id student.name student.familyname student.age
1 Mike Smith 12
2 Emma Johnson 15

Underscore (_) Delimiter:

id student_name student_familyname student_age
1 Mike Smith 12
2 Emma Johnson 15

Max Nesting Depth Setting

When JSON contains multiple levels of nesting, you can set the max nesting depth to control conversion behavior. Nested objects exceeding the max depth will be converted to strings.

How to Convert JSON to CSV

The JSON-to-Excel WPS add-in’s core functionality converts JSON to WPS spreadsheets (.xlsx format). If you need CSV format, you can achieve it through these methods:

Method 1: Save As CSV in WPS

  1. Convert JSON to WPS spreadsheet using the add-in
  2. In WPS, click File → Save As
  3. Select CSV File (*.csv) as the save type
  4. Click Save

Method 2: Use the Web App

If you don’t need to edit data in WPS, use the JSON-to-Excel Web App:

  1. Open the web app
  2. Paste JSON data or upload JSON files
  3. Select conversion settings
  4. Click “Go” button
  5. After conversion, click “Download” to get the Excel file
  6. Open the downloaded Excel file in WPS and save as CSV

Supported Data Types

JSON-to-Excel supports the following JSON data type conversions:

JSON Type Example WPS Table Output
String "text" Display text directly
Number 123, 45.67 Numeric value
Boolean true, false Text “true”/“false”
Null null Blank cell
Array [1, 2, 3] Converted to string “[1,2,3]”
Object {"x": 1} Flat mode → string; Nested mode → expanded

Real-World Use Cases

Scenario 1: API Data Export

JSON data from Web APIs typically needs conversion to tables for analysis:

1
2
3
4
5
6
7
8
{
  "status": "success",
  "data": [
    {"product": "Laptop", "price": 999, "stock": 150},
    {"product": "Wireless Mouse", "price": 15, "stock": 2000},
    {"product": "Mechanical Keyboard", "price": 89, "stock": 500}
  ]
}

Simply extract the data array and paste it into the add-in to quickly generate a product inventory table.

Scenario 2: Log Data Processing

Server logs are typically stored in JSON format. The add-in can quickly convert them to tables for troubleshooting and analysis.

Scenario 3: Batch Data Consolidation

When you need to process multiple JSON files and merge them into a single Excel workbook, the batch processing feature greatly improves efficiency.

Free vs. Pro Version

Feature Free Pro
Max rows per conversion 6 rows Unlimited
All advanced features ✅ ✅
Batch processing (local files) ✅ ✅
Batch processing (URL) ✅ ✅
Multiple delimiters ✅ ✅
Custom max nesting depth ✅ ✅
Ads displayed Yes No ads

💡 Pro subscription applies to both JSON-to-Excel and Excel-to-JSON tools!

Frequently Asked Questions

Q1: What format should my JSON data be in?

JSON data can be in either of these formats:

  • Array of objects: [{"key": "value"}, {"key": "value"}]
  • Single object: {"key1": "value1", "key2": "value2"}

Each object supports up to 100 properties, and arrays support up to 1000 objects.

Q2: Can I edit the converted table data?

Absolutely! The converted data is regular WPS spreadsheet data, so you can perform any editing operation including formatting, adding formulas, creating charts, etc.

Q3: What size JSON files are supported?

Each conversion supports up to 1000 rows and 100 columns. For larger datasets, consider using the API or MCP service for batch processing.

Q4: Is my data safe?

When using the WPS add-in, your data is processed directly within WPS without being uploaded to servers. For offline users, the Local App version is also available.

Q5: How do I batch convert multiple JSON files?

Click the “Load JSON File(s)” button in the add-in to select up to 20 JSON files for batch conversion. Each file will be converted to a separate sheet.

Summary

The JSON-to-Excel WPS add-in provides WPS Office users with a complete solution for converting JSON to tables. Whether you need JSON to Excel or JSON to CSV, whether your JSON data is flat or has complex nested structures, this tool handles it all with ease.

Through the methods described in this guide, you can:

  • ✅ Open and convert JSON files directly in WPS
  • ✅ Quickly transform JSON data into WPS spreadsheets
  • ✅ Batch convert JSON to CSV format
  • ✅ Handle complex nested JSON structures
  • ✅ Enable automated conversion through APIs

Start using the JSON-to-Excel WPS add-in today and make your data processing work more efficient!

Related Resources: