WPS Split Table on macOS: Introduction

WPS Split Table is a spreadsheet-splitting feature in WPS Spreadsheet on macOS; it includes 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	3	Matches the number of rows in the How-to Index
Available without membership	3	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

Split Table helps you split data in one workbook into multiple separate results so different collaborators can review and handle only the data they need. In WPS Spreadsheet on macOS, you can split by content or by worksheet, then save the results as new worksheets in the current file or as separate cloud documents.

Core capabilities include:

Split by content: group and split data based on different values in a selected column.
Split by worksheet: turn selected worksheets into separate result documents.
Choose how to save results: save to new worksheets or separate documents, and adjust the save path when needed.

System Requirements

Item	Requirement
Operating system	A Mac device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office for Mac
Network	An internet connection is needed when saving results as separate cloud documents
Other	Signing in to a WPS account is recommended for cloud access and saving

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Spreadsheet, open a file, and confirm that the Split Table entry appears on the Data tab

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	On macOS, WPS provides Split Table from the Data tab. It supports splitting by content or by worksheet, and it can save results as new worksheets or separate cloud documents.	Excel official guidance covers moving or copying worksheets within or across workbooks. That page does not document a native command for splitting a table by column values.	Google Sheets official developer documentation covers adding, copying, and deleting sheets through sheet operations. It does not document a built-in end-user Split Table command.	Notion databases organize information as pages, properties, and views. This is different from a spreadsheet-style workflow for splitting worksheet data into separate sheets or files.	Adobe Acrobat officially supports splitting PDF pages into separate files, which is a different workflow from splitting spreadsheet tables by content or worksheet.
WPS Advantages	Advantage: one entry point includes both Split by Content and Split by Worksheet. Distinct: results can be saved directly to new worksheets or separate cloud documents.	Compared with WPS: the official page focuses on copying or moving whole worksheets rather than grouping table data by selected column values.	Compared with WPS: the official capability is centered on sheet operations through the API, not a built-in spreadsheet command for everyday table splitting.	Compared with WPS: Notion is better aligned with database pages and multiple views than with native worksheet-area splitting.	Compared with WPS: Adobe focuses on PDF page splitting rather than spreadsheet table splitting.
Official Source	—	Move or copy worksheets or worksheet data	Sheet operations	Intro to databases	How to split PDF files

Overall Conclusion
If you need to split spreadsheet data by column values or turn multiple worksheets into separate results from one workflow, WPS offers a more direct path in its spreadsheet interface. The official materials for the other products mainly describe adjacent capabilities or different content models rather than the same spreadsheet-splitting workflow.

Use Cases

No.	Scenario	Suitable for	Main challenge	How Split Table helps
1	Split a master sheet by department	Team leads, admins	One master table needs to be sent to different departments	Use Split by Content and choose the department column
2	Separate project sheets for filing	Project members, operations teams	One workbook contains multiple sheets that need separate filing	Use Split by Worksheet to create separate results
3	Prepare separate data for collaboration	Cross-functional teams	Each person only needs the data they are responsible for	Save results as separate documents and share them individually
4	Keep headers in every split result	Data coordinators	Split results still need field names for reading and review	Turn on Data contains header during content-based splitting
5	Save split results to the cloud	Remote workers	Results need to be stored in one cloud location for later access	Save as separate cloud documents and adjust the save path

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Split Table entry	Available	Available
Basic spreadsheet editing	Available	Available
Advanced PDF editing and more advanced tools	Availability depends on the pricing page and may be limited	Includes more advanced tools and higher allowances
Cloud storage	1 GB	Higher cloud storage allowance
Templates and AI-related features	Some features are limited	More advanced templates and AI-related features are included

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Occasional table splitting and daily data handling	Free	Split Table is available directly and fits basic spreadsheet-splitting needs
More cloud storage, advanced PDF tools, or broader advanced features	WPS Premium	Better for users who work across multiple document types and need more extended capabilities

WPS membership: Subscribe now