WPS Merge Tables on Windows: Introduction

WPS Merge Tables helps you combine data from multiple worksheets or documents into one 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
Version limit	None specified	No version threshold is stated for this feature

About This Feature

Overview

Merge Tables is a spreadsheet feature in WPS that combines data from multiple worksheets or documents into one worksheet. It is useful for cross-sheet consolidation, collaborative summaries, and repeated refreshes of combined results.

Core tasks include:

Open the Merge Tables entry: go to the Data tab and view the options for first-time merge and re-merge.
Merge multiple worksheets for the first time: select one or more worksheets, then set header handling, duplicate removal, output location, source labels, and auto-update options.
Re-merge an existing result: refresh the combined result after source worksheet data changes, without setting the sources again.

System Requirements

Item	Requirement
Operating system	A Windows PC that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	A stable internet connection is recommended for online collaborative documents
Other	You need access to the related worksheets or documents and permission to view the source data

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Spreadsheet, go to the Data tab, and confirm that the Merge Tables entry is available

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Combines data from multiple worksheets or documents into one worksheet, with options for header handling, removing duplicate rows, marking data sources, auto-updating data, and re-merging.	Excel provides Consolidate for summary results and also documents ways to combine or append data with VSTACK or Power Query for ongoing data consolidation.	Google Sheets documents IMPORTRANGE for importing ranges from another spreadsheet, including refresh behavior, permissions, and chained updates.	Notion supports adding multiple data sources to one database or linking an existing data source, which fits database-level information aggregation.	Acrobat combines Excel and other files into one PDF for sharing, but it does not merge spreadsheet rows into a single worksheet.
WPS Advantages	Advantage: the workflow is built directly for worksheet data merging from the Data tab. Distinct: it combines duplicate removal, source labeling, auto-update, and re-merge in one feature flow.	Compared with WPS: Excel emphasizes separate methods such as Consolidate, formulas, or queries, so the workflow varies by method.	Compared with WPS: Google Sheets focuses more on importing ranges and managing permissions than on a single merge wizard in one entry point.	Compared with WPS: Notion is better suited to database source management than cell-based worksheet merging.	Compared with WPS: Adobe focuses on combining files into PDF rather than consolidating worksheet data.
Official Source	—	Combine data from multiple sheets	IMPORTRANGE	Data sources and linked databases	Combine files into one PDF in Acrobat

Overall Conclusion
WPS Merge Tables is closer to a day-to-day worksheet consolidation workflow because it keeps source selection, duplicate handling, source labels, and refresh actions in one place. Excel and Google Sheets can achieve similar outcomes, but they rely more on separate consolidation, formula, or import methods. Notion and Adobe are better suited to database aggregation or file-level combination rather than worksheet data merging.

Use Cases

No.	Scenario	Suitable for	Main challenge	How this feature helps
1	Multi-team data consolidation	Admin, finance, and operations staff	Data is spread across many worksheets and manual copy-paste is error-prone	Use Merge Tables to combine multiple worksheets into one result sheet
2	Refreshing collaborative summaries	Team collaborators	Source sheets keep changing and the summary needs repeated updates	Use Re-merge to refresh the result with the previous settings
3	Duplicate cleanup after merging	Data organizers	Combined results may contain repeated records	Turn on Remove duplicate rows during the first merge
4	Tracking where data came from	Project managers and reviewers	It is hard to tell which source sheet each row came from after merging	Turn on Mark data source during the merge
5	Maintaining a dynamic summary sheet	Teams that monitor changing data	The result sheet is costly to maintain when source data changes often	Turn on Data auto update during the first merge

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Core Writer, Spreadsheet, and Presentation apps	✅ Available	✅ Available
Merge Tables feature	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available
More advanced PDF and extended tools	Partially limited	✅ Available
Cloud storage	1 GB	20 GB

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Everyday spreadsheet summaries and occasional Merge Tables use	Free plan	Merge Tables itself is available for regular data consolidation tasks
Users who also need more PDF tools, more cloud storage, or shared plans	WPS Premium	Better suited to broader office needs and subscription benefits

WPS membership center: Subscribe now