Split Table

Split Table helps you split data in a WPS Spreadsheet collaborative workbook into separate sheets or independent cloud documents. It provides the tools you need to divide summary data by condition or by worksheet, making it easier for collaborators to view and edit only the data they are responsible for. With Split Table, you can split a selected range by the values in a chosen column, keep header rows in each result, save outputs as new sheets or new cloud documents, split selected worksheets into separate documents, and include hidden worksheets when needed. Whether you're distributing grouped records to different collaborators or separating multiple worksheets such as sales and inventory into standalone files, Split Table helps you stay productive and complete tasks efficiently across different devices and work environments. Choose the documentation below that best matches your needs to learn more.