How to Merge Workbooks in WPS on Android

Use Merge Workbooks with 4 how-to topics, all of them membership-related; choose a topic from the How-to Index and follow the steps to select files and complete the merge.

How-to Index

How-to Guide

1. Open Merge Workbooks from All Services

Feature entry: Spreadsheet top menu bar “☰” → “All Services” → “Merge Workbooks”

1. Open the spreadsheet document you want to work with.
2. Tap the “☰” icon in the top menu bar.
3. Tap All Services.
4. Select Merge Workbooks.

Success Criteria

• Interface result: The Merge Workbooks screen opens.
• Next action available: You can continue to choose files for the merge.

Tips While Using

• Membership: This is a membership-related feature.
• Common mistake: If you have not opened a spreadsheet first, the same entry path may not be available.

2. Open Merge Workbooks from More Output & Conversion

Feature entry: Spreadsheet top menu bar “☰” → “More Output & Conversion” → “Merge Workbooks”

1. Open the spreadsheet document you want to work with.
2. Tap the “☰” icon in the top menu bar.
3. Tap More Output & Conversion.
4. Select Merge Workbooks.

Success Criteria

• Interface result: The Merge Workbooks screen opens from the output and conversion tools area.
• Next action available: You can continue to add files for merging.

Tips While Using

• Membership: This is a membership-related feature.
• Common mistake: If you are not working inside a spreadsheet file, the menu grouping may differ.

3. Select cloud or local files for merging

Feature entry: Choose files after opening Merge Workbooks

1. In the Merge Workbooks screen, choose the file source you want to use.
2. Select spreadsheet files from cloud storage or local storage.
3. Confirm that all selected files are the ones you want to merge.

Success Criteria

• Interface result: The selected files appear in the current merge list.
• Next action available: You can start the merge.

Tips While Using

• Environment: Keep the network connected when selecting cloud files.
• Common mistake: Selecting the wrong files can affect the final result, so review the file list before continuing.

4. Start the merge and review the result

Feature entry: Tap Start Merge after file selection is complete

1. Confirm that the file list is correct.
2. Tap Start Merge.
3. Wait for the merge to finish.
4. Open the merged result and review the data.
5. Check complex formulas, pivot tables, and chart reference ranges.

Success Criteria

• Interface result: The merge finishes and a result workbook is generated.
• Next action available: You can continue to view, edit, or save the merged workbook.

Tips While Using

• Common mistake: Skipping the post-merge review may affect later analysis.
• Membership: This is a membership-related feature.