WPS Split Table on macOS helps you split collaborative spreadsheet data by content or by worksheet; 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 is a spreadsheet collaboration feature in WPS Office for macOS. It helps you split data from one workbook into multiple separate worksheets or separate cloud documents, so different collaborators can review and handle only the data they need.
Core tasks include:
- Open the Split Table entry from the Data tab.
- Split by content based on the values in a selected column.
- Split by worksheet to turn multiple sheets into separate cloud documents.
This feature is useful for department-based distribution, project-based data handoff, inventory and sales breakdowns, and other scenarios where one master sheet needs to be divided into smaller results for different people.
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 |
| Network | A stable internet connection is recommended when opening collaborative files or saving results to cloud documents |
| Other | Sign in to your WPS account and make sure the current file is editable |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Check after installation | Open WPS Spreadsheet, open a collaborative file, and confirm that the Split Table entry is available on the Data tab |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | In collaborative spreadsheets, WPS can split data by content based on column values, or split worksheets into separate cloud documents. | Microsoft Word officially supports splitting one table into two tables for document layout, rather than batch-splitting spreadsheet data by field values. | Google Docs officially supports table editing such as splitting cells, sorting rows, and moving rows or columns, but its help page does not describe splitting one table into multiple outputs by column values. | Notion officially supports database views, filters, sorts, and groups for presenting the same data in different ways, rather than splitting one table directly into separate worksheets or files. | Adobe Acrobat officially supports splitting PDFs by page count, file size, or top-level bookmarks, which is aimed at document pages instead of spreadsheet data distribution. |
| WPS Advantages | Advantage: WPS combines split-by-content and split-by-worksheet workflows, and can save results as new worksheets or new cloud documents for team distribution. | Compared with WPS: the official workflow focuses on document table layout and does not describe field-based batch splitting for spreadsheet data. | Compared with WPS: the official workflow focuses on editing table structure and cells, not on generating multiple independent results from one data range by condition. | Compared with WPS: the official workflow focuses on database views and grouped presentation, not on exporting split results as separate worksheets or files from one spreadsheet operation. | Compared with WPS: the official workflow focuses on PDF page-level splitting, which serves a different document type and use case. |
| Official Source | — | Split a table in Word | Add and edit tables | Views, filters, sorts & groups | Split PDFs in Acrobat |
Overall Conclusion
If you need to distribute spreadsheet data to different collaborators by field value or by worksheet, WPS Split Table is closer to that workflow. The other products listed here also provide split or organization features, but they focus on document layout, database views, or PDF page handling instead.
Use Cases
| No. | Scenario | Suitable for | Main challenge | How WPS helps |
|---|---|---|---|---|
| 1 | Split a master sheet by department | Admin teams, operations teams | One summary sheet must be sent to multiple departments | Use Split by Content and choose the department column |
| 2 | Split collaborative data by project | Project managers, team leads | Each project member only needs a subset of the data | Use Split by Content and group by the project column |
| 3 | Archive worksheets separately | Finance teams, sales teams | Multiple sheets in one workbook need separate files | Use Split by Worksheet to create separate cloud documents |
| 4 | Include hidden worksheets when splitting | Data coordinators | Hidden sheets may be missed during file distribution | Turn on Include hidden worksheets when needed |
| 5 | Prepare files before team sharing | Collaborators | Manual copy-and-paste into many files is slow | Generate multiple target files in one split workflow |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| Basic Split Table usage | Available | Available |
| PDF editing and conversion | Basic PDF features | More advanced PDF features |
| Cloud storage | 1 GB cloud space | 20 GB cloud space |
| Template resources | Limited template downloads | More template benefits |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| Occasional spreadsheet splitting | Free | The Split Table workflow itself is available for light data organization tasks |
| Frequent cloud collaboration and broader office needs | WPS Premium | More cloud space and broader premium office benefits fit heavier daily use |
How to Subscribe
- WPS membership page: Subscribe now
Source: WPS Office pricing page