WPS Split Table on Windows: Introduction

WPS Split Table is a spreadsheet feature for splitting data in a smart spreadsheet 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 data organization feature in WPS Office for Windows Spreadsheet. It helps you split data from one workbook into multiple separate worksheets or separate documents, so different teams, departments, projects, or worksheet groups can be reviewed and handled independently.

Core capabilities include:

Split Table entry: open the panel from the Data tab and switch between Split by Content and Split by Worksheet.
Split by Content: group rows automatically by different values in a selected column, keep the header row if needed, and save results to different new worksheets or different new documents.
Split by Worksheet: split multiple worksheets in the current file into separate documents, with an option to include hidden worksheets.

Common use cases include splitting department lists, separating project data, and turning a multi-sheet workbook into individual files.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	A network connection is needed when saving to cloud documents or opening online locations
Other	You need access to a smart spreadsheet file and permission to save to the target location

Source: WPS Office Windows page

Download & Installation

Before using Split Table, install WPS Office for Windows and confirm that you can open spreadsheet files.

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Office, open a smart spreadsheet, and check whether the Split Table entry is available on the Data tab

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In a smart spreadsheet, WPS can split data by selected column values with Split by Content, or split by worksheet, and save results as new worksheets or separate new documents.	Excel officially supports moving or copying worksheets and worksheet data into another worksheet or workbook. Public official guidance does not show a matching native one-click workflow for automatically splitting a table by column values.	Google Sheets official help covers creating, deleting, moving, and organizing sheets. Public official help does not show a matching native one-click workflow for automatically splitting a table by column values.	Notion databases organize information with views, properties, and pages, but they are not cell-based spreadsheet splitting tools.	Adobe Acrobat officially supports splitting PDF pages into separate files, which is different from splitting spreadsheet data or worksheets.
WPS Advantages	Advantage: one entry combines both Split by Content and Split by Worksheet. Distinct: results can be saved directly as new worksheets in the current file or as separate new documents.	Compared with WPS: Excel guidance focuses more on copying, moving, or saving worksheets, and does not show the same native batch split-by-column workflow.	Compared with WPS: Google Sheets guidance focuses more on sheet management than on a same-component split-table workflow.	Compared with WPS: Notion is better suited to database views and page organization than batch splitting spreadsheet rows by column values.	Compared with WPS: Acrobat splits PDF pages, not spreadsheet data or worksheets.
Official Source	—	Move or copy worksheets or worksheet data	Create, delete, and move sheets and worksheets	Intro to databases	Split PDFs

Overall Conclusion
If you need to split spreadsheet data directly by column values or by worksheet in a spreadsheet workflow, WPS provides a more centralized entry and a more direct path for this task. Other products can cover part of the surrounding workflow, but fewer same-component official pages describe a fully matching native split process.

Use Cases

No.	Scenario	Suitable For	Main Pain Point	How Split Table Helps
1	Split a list by department	HR and admin teams	One master sheet needs to be shared with multiple departments	Use Split by Content and split by the department column into new worksheets or new documents
2	Separate project data	Project managers and operations teams	One table contains records for multiple projects	Select the project column as the split basis and generate separate results automatically
3	Break up a multi-sheet workbook	Finance teams and data organizers	One workbook contains many worksheets that need separate filing	Use Split by Worksheet to create separate documents
4	Keep headers in every result	Team collaborators	Each split result still needs the same header structure	Turn on Data contains header so each result keeps the header row
5	Save results to cloud documents	Remote collaboration teams	Split results need to be stored in a shareable location	Save results as separate new documents and choose the target path

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Writer, Spreadsheet, and Presentation core apps	Available	Available
Split Table	Available	Available
Some advanced PDF and extended tools	May be limited	Broader access
Cloud storage	1 GB	20 GB or more depending on the plan shown on the pricing page
Templates and AI-related tools	Basic or limited access	More advanced templates and AI-related tools

Source: WPS Office pricing page

Source: Why do I need to pay for WPS Office?

Recommendations

Scenario	Recommended Plan	Why
Everyday spreadsheet splitting and occasional data cleanup	Free	Split Table itself is available for regular office work
More cloud storage, PDF tools, or broader extended features	WPS Premium	Suitable if you also need more advanced office capabilities
Team sharing and multi-user collaboration	Sharing or higher-tier subscription plans	Better for teams that need multiple accounts and more storage

Membership page: Subscribe to WPS Premium
You can compare Free, Pro+, and sharing plans on the pricing page before subscribing.