WPS Group on Windows: Introduction

WPS Group is a data grouping feature for smart tables; it includes 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

Group is a data grouping feature in WPS Office for Windows smart tables. It helps organize records by field value so you can review similar entries more efficiently.

Its main capabilities include:

Automatically grouping records by field value for faster category-based review.
Adding multiple grouping conditions to build nested group levels.
Expanding or collapsing all groups for quick switching between summary and detail views.
Changing only the display structure without modifying or deleting the original records.

This feature is useful for project trackers, customer lists, task tables, and categorized data reviews.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	No mandatory internet connection is required for local grouping actions; sign-in, sync, or online collaboration needs a network connection
Other	An editable data table with fields that can be used for grouping

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, open a data table in smart tables, and confirm that the Group entry is available on the toolbar

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Groups data table records by field value, supports nested grouping, and lets you expand or collapse all groups.	Microsoft Lists can group a view by column value, including quick grouping on one column and view-based grouping on one or two columns. Grouping changes display only.	Google Sheets can group rows or columns and lets users expand or collapse grouped sections with plus or minus controls.	Notion databases can group items by property and also support sub-groups for a second grouping layer.	Adobe Acrobat focuses on PDF table structure and accessibility tagging, such as header scope and span, rather than interactive record grouping in a data view.
WPS Advantages	Advantage: Built for record-level grouping in a data table, with multiple grouping conditions and all-group expand or collapse in one workflow.	Compared with WPS: Supports grouped views, but the official guidance centers on list or library views and documents one- or two-column grouping in that context.	Compared with WPS: Focuses on structural row or column grouping in a worksheet instead of grouping records into a field-based category view.	Compared with WPS: Offers flexible database grouping and sub-grouping, but its model is centered on database properties and page-based records.	Compared with WPS: Better suited to PDF table structure work than to ongoing record grouping inside a live data table.
Official Source	—	Use grouping to modify a list or library view	Freeze, group, hide, or merge rows & columns	Views, filters, sorts & groups	Complex tables

Overall Conclusion
WPS Group is well suited to users who want to organize data table records by field and switch quickly between grouped summaries and detailed entries. Other products cover adjacent needs such as list-view grouping, worksheet structure grouping, database property grouping, or PDF table tagging.

Use Cases

No.	Scenario	Suitable for	Main challenge	How Group helps
1	Reviewing customer lists by category	Sales teams, operations teams	Records are mixed together and hard to review by region or status	Group by region, owner, or follow-up status
2	Organizing project tasks in layers	Project managers, team members	Large task sets are hard to scan by category	Add multiple fields to create nested groups
3	Checking inventory or asset records	Admin teams, warehouse teams	Large record sets are slow to review manually	Group by category, location, or status
4	Switching between summary and detail views	Analysts, managers	Users need both a high-level overview and record details	Expand or collapse all groups as needed
5	Reviewing categories without changing source records	All data table users	Users want a cleaner view without changing the original data	Use grouping to change display only

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Basic grouping in smart tables	✅ Available	✅ Available
Core Writer, Spreadsheet, and Presentation apps	✅ Available	✅ Available
Some advanced PDF and advanced tools	Depends on the feature	✅ Broader access
Cloud storage and additional benefits	Basic quota	More benefits and higher quota

Source: WPS Office pricing page

Source: Why do I need to pay for WPS Office?

Recommendations

Scenario	Recommended plan	Why
Daily data review and table organization	Free plan	The core Group workflow is available for regular category-based browsing
Workflows that also need more PDF tools, cloud space, or broader advanced office features	WPS Premium	Better fit for users who need expanded office capabilities and added benefits

Subscribe here: Get WPS Premium