WPS Split Table helps you split an online collaborative workbook by content or by worksheet; 3 core tasks are covered, 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 data organization feature in WPS Sheets collaboration scenarios. It helps you split data from one workbook into multiple separate results so different collaborators can review, distribute, or continue editing their own parts more easily.
Core capabilities include:
- Open the Split Table panel from the Data tab and switch between different split methods.
- Split by content based on different values in a selected column, while keeping header rows if needed and saving results to new worksheets or new documents.
- Split by worksheet so multiple sheets in the current workbook become separate cloud documents, with an option to include hidden worksheets.
This feature is useful for department-based distribution, project handoff, owner-based data splitting, and worksheet-based document organization.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A Windows device using a browser or WPS Office to access online collaborative spreadsheets |
| App version | It is recommended to use the latest version of WPS Office |
| Network | A stable internet connection is needed to open collaborative files and save split results |
| Other | Sign in to a WPS account and make sure the current file has editing permission |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Post-install check | Launch WPS Office, open a spreadsheet, and confirm that the Data tab is available |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | Supports splitting an online collaborative workbook by content or by worksheet, with output to new worksheets or separate cloud documents. | Word can split one table into two or more tables for document layout, but it does not provide batch data splitting by column values. | Google Docs supports table editing such as splitting cells, moving rows and columns, and pinning header rows, but it does not provide batch output by column value or worksheet. | Notion provides multiple database views with filters, sorts, and groups for the same data source, which is closer to view management than generating separate split files. | Acrobat can split PDFs by number of pages, file size, or top-level bookmarks, which is designed for document pages rather than spreadsheet data. |
| WPS Advantages | Advantage: supports both split-by-content and split-by-worksheet workflows. Distinct: results can be created as new worksheets or separate cloud documents for collaboration handoff. | Compared with WPS: better suited to splitting a single table inside a document layout, with fewer data-oriented split options. | Compared with WPS: focuses on table structure editing and cell operations rather than generating multiple result files for data distribution. | Compared with WPS: useful for viewing the same database in different ways, but it does not directly split results into multiple worksheets or cloud documents. | Compared with WPS: splits PDF pages instead of spreadsheet data grouped by fields. |
| 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 collaborative spreadsheet data by field or by worksheet, WPS Split Table is closer to that workflow. The other products also provide split or organization features, but they focus on document layout, table structure editing, database views, or PDF page handling.
Use Cases
| No. | Scenario | Suitable For | Main Challenge | How Split Table Helps |
|---|---|---|---|---|
| 1 | Distribute data by owner | Team leads, project managers | One master sheet contains data for many people | Use Split by Content and split by the owner column |
| 2 | Archive data by department | Admin, operations, finance teams | Different departments only need their own records | Select the split column, keep headers, and generate separate results |
| 3 | Send worksheets separately | Data coordinators | One workbook contains multiple topic-based sheets that need separate sharing | Use Split by Worksheet to create separate cloud documents |
| 4 | Include hidden worksheets when needed | Advanced spreadsheet users | Some worksheets are hidden and still need to be processed | Turn on Include hidden worksheets during worksheet splitting |
| 5 | Prepare separate files before collaboration | Collaboration teams | A large master workbook is hard to assign directly | Split it into new worksheets or new documents before assigning work |
Membership & Benefits
Free vs WPS Premium
This feature itself has no membership restriction. The WPS Office pricing page also shows a free plan and paid plans, with paid plans offering more advanced capabilities and larger cloud storage.
| Capability | Free Users | WPS Premium |
|---|---|---|
| Basic Split Table usage | ✅ Available | ✅ Available |
| Cloud storage | 1 GB | 20 GB or more depending on the plan |
| Advanced PDF and extended tools | Partially limited | More advanced tools are included |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended Plan | Why |
|---|---|---|
| Everyday collaborative spreadsheet splitting | Free plan | This feature can be used directly without an added membership requirement |
| More cloud storage and broader advanced tools | WPS Premium | Better for users who manage more files and need more advanced tools |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page