WPS Group on macOS: Introduction

Last updated:July 21, 2026

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

At a Glance

MetricValueNotes
Core tasks4Matches the number of rows in the How-to Index
Available without membership4Matches the number of Free rows in the index
Membership-related items0Matches the number of membership-related rows in the index

About This Feature

Overview

Group helps you organize records in a data table by field value so similar items appear together for faster review, lookup, and comparison.

Core capabilities include:

  • Automatically grouping records by field value for category-based browsing.
  • Supporting nested multi-level grouping for layered data structures.
  • Letting you expand or collapse groups for overview and detail views.
  • Changing only the display structure without modifying or deleting records.

This feature fits project trackers, customer lists, task tables, and categorized data reviews.

System Requirements

ItemRequirement
Operating systemA Mac device that can run WPS Office for Mac
App versionIt is recommended to use the latest version of WPS Office for Mac
NetworkNo mandatory network connection is required for local grouping; sign-in, sync, or online collaboration needs internet access
OtherOpen a Smart Table data table first and make sure the table contains fields that can be used for grouping

Download & Installation

ItemDetails
Official downloadWPS Office Free Download
Post-install checkLaunch WPS Office for Mac, open a Smart Table data table, and confirm that the Group entry is available on the toolbar

Source: WPS download page

Compare with Alternatives

DimensionWPSMicrosoftGoogleNotionAdobe
Capability SummaryGroups data-table records by field value, supports nested multi-level grouping, and lets you expand or collapse groups.Microsoft Lists can group list views by column value and supports grouping on one or two columns in a view.Google Sheets supports grouping rows or columns and lets users expand or collapse grouped sections.Notion database views can group by property and also support sub-groups.Adobe's official Acrobat guidance focuses on table structure and accessibility settings rather than native data-table grouping views.
WPS AdvantagesAdvantage: Built for record-based data tables with field grouping, nested grouping, and all-group expand or collapse in one workflow.Compared with WPS: Microsoft's official workflow is centered on list-view grouping, with one-column quick grouping and up to two columns in a saved view.Compared with WPS: Google's official grouping is oriented to spreadsheet rows and columns rather than record-based data-table grouping.Compared with WPS: Notion also supports property grouping and sub-groups, but it depends on database view settings.Compared with WPS: Adobe's official capability is closer to PDF table structure handling than to interactive data-table grouping.
Official SourceUse grouping to modify a list or library viewFreeze, group, hide, or merge rows & columnsViews, filters, sorts & groupsComplex tables

Overall Conclusion
WPS Group is more directly aligned with record-based data-table organization on macOS. If you need field-based grouping, nested levels, and quick switching between overview and detail, it provides a more focused workflow than row-outline grouping or PDF table structure tools.

Use Cases

No.ScenarioSuitable forMain challengeHow Group helps
1Reviewing customer lists by categorySales teams, operations staffRecords are mixed together and hard to review by region or statusGroup records by region, status, or other fields
2Managing layered project tasksProject managers, team membersLarge task sets are hard to read without hierarchyBuild multi-level groups by project, owner, or stage
3Checking inventory or assetsAdmin teams, warehouse staffSimilar items are scattered across the tableGroup by category or location for faster review
4Organizing class or event rostersTeachers, organizersLarge lists take time to scan manuallyGroup by class, team, or status
5Switching between overview and detailsAll table usersUsers need both a summary structure and record detailsExpand or collapse groups as needed

Membership & Benefits

Free vs WPS Premium

CapabilityFree usersWPS Premium
Writer, Spreadsheet, and Presentation core componentsAvailableAvailable
Basic PDF features and PDF readingAvailableAvailable
Advanced PDF editing and conversionLimitedAvailable
Cloud storage1 GB20 GB
AI toolsLimited access for some toolsMore access and advanced capabilities

Source: WPS Office pricing page

Recommendations

Usage scenarioRecommended planWhy
You mainly use Group for everyday table organization and record reviewFreeThe Group feature itself has no membership restriction in this workflow
You also need more PDF tools, cloud storage, or AI featuresWPS PremiumBetter for broader document workflows and expanded office capabilities

How to Subscribe

Source: WPS Office pricing page