WPS Group on iOS: Introduction

WPS Group is a data grouping feature for Smart Spreadsheet on iOS; this guide covers 2 core tasks, with 2 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	2	Matches the number of rows in the How-to Index
Available without membership	2	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 built-in data organization feature in WPS Office for iOS Smart Spreadsheet. It helps you organize records by field values and display them in a clearer grouped structure.

Core capabilities include:

Add grouping conditions to organize records by a selected field.
Remove grouping conditions to return to a regular view.
Add multiple grouping conditions for layered organization.
Keep grouped views visible to collaborators in shared tables.

This feature is useful for project tracking, customer list organization, task status review, and similar data management scenarios.

System Requirements

Item	Requirement
Operating system	An iPhone or iPad that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	A network connection is recommended when opening online or collaborative spreadsheets
Other	You need an editable table and permission to access the target spreadsheet

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open a Smart Spreadsheet in WPS Office, then confirm that the Group entry is available in the bottom Tools panel

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In iOS Smart Spreadsheet, you can open Tools > Group to add grouping conditions, choose a field, set the sort order, and apply multiple grouping conditions.	Excel supports outlining worksheet data by rows or columns, with expand and collapse controls for grouped levels.	Google Sheets supports grouping rows or columns and lets users expand or collapse grouped sections with plus or minus controls.	Notion supports grouping database items by property and also supports sub-groups, but it works in database views rather than a traditional cell-based spreadsheet.	Acrobat focuses on collecting and exporting PDF form data to spreadsheet formats, but it does not provide native spreadsheet row or column grouping.
WPS Advantages	Advantage: grouping conditions and sort order are available directly inside the mobile table workflow. Distinct: multiple grouping conditions help organize records in layers on iOS.	Compared with WPS: Excel provides mature outline controls, but the cited workflow is centered on worksheet outlining rather than an iOS-first grouped table workflow.	Compared with WPS: Google Sheets supports grouping and expand or collapse behavior, but the cited help flow is mainly documented for desktop Sheets.	Compared with WPS: Notion grouping is designed for database views, not for native spreadsheet cells and table editing.	Compared with WPS: Acrobat does not offer an equivalent spreadsheet grouping workflow and is oriented toward PDF data collection and export.
Official Source	—	Outline group data in Excel	Freeze, group, hide, or merge rows and columns in Google Sheets	Views, filters, sorts & groups	Collect and manage PDF form data

Overall Conclusion
WPS Group fits mobile spreadsheet organization on iOS well because grouping controls are available directly inside the Smart Spreadsheet workflow. Excel and Google Sheets also support grouping, but their official guidance is more centered on worksheet or desktop-style flows. Notion and Adobe address adjacent scenarios rather than the same spreadsheet grouping task.

Use Cases

No.	Scenario	Suitable For	Main Challenge	How Group Helps
1	Customer list review	Sales teams, operations teams	Large customer lists are hard to scan by region or status	Group records by a selected field to gather similar customers together
2	Project task organization	Project managers, team members	Mixed task states make progress hard to review	Group by status or owner to create a clearer layered view
3	Inventory or asset review	Admin teams, warehouse staff	Similar items are scattered across the table	Group by category or location for faster checking
4	Shared table review	Collaborators	Team members may see the same table in different ways	Use visible grouping states so collaborators can review the same structure
5	Temporary analysis and reset	Everyday office users	You may want a grouped view without changing the raw data	Remove grouping when finished and return to a regular view

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Smart Spreadsheet grouping	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available
Cloud storage	1 GB	20 GB or more depending on the plan shown on the pricing page
Advanced PDF and some advanced tools	Partially limited	More tools are available
AI tools	Some limits apply	More usage or features are available depending on plan details

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
You mainly need grouping in Smart Spreadsheet	Free	The Group feature itself is available for everyday mobile table organization
You also need more cloud storage, PDF tools, or broader advanced features	WPS Premium	A membership is more suitable when your workflow includes multiple office tasks beyond grouping

WPS membership center: Subscribe now