How to Merge Workbooks in WPS on iOS

Last updated:July 16, 2026

Use Merge Workbooks in WPS on iOS with 4 how-to topics; 0 are available without membership and 4 are membership-related, matching the Introduction counts.

How-to Index

No.TopicMembership Requirement
11. Open the Merge Workbooks entryWPS Premium required
22. Select the sheets to includeWPS Premium required
33. Add files of the same type from cloud or local storageWPS Premium required
44. Start the merge and wait for completionWPS Premium required

How-to Guide

1. Open the Merge Workbooks entry

Feature entry: top menu bar in a spreadsheet → More → All Services → Merge Workbooks

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

Success Criteria

  • Interface result: the Merge Workbooks page opens.
  • Next step available: you can continue to choose the sheets to include.

Tips While Using

  • Membership: this feature requires WPS Premium.
  • Common mistake: open a spreadsheet first before trying to enter the feature.

2. Select the sheets to include

Feature entry: the sheet selection area on the Merge Workbooks page

  1. After opening the Merge Workbooks page, review the list of sheets in the current document.
  2. Select the sheets that you want to include in the merge.
  3. Confirm that the selected sheets match the content you want to consolidate.

Success Criteria

  • Interface result: the required sheets are selected.
  • Next step available: you can continue to add other files of the same type.

Tips While Using

  • Common mistake: if you choose the wrong sheets, the merged result may miss needed data.
  • Membership: this feature requires WPS Premium.

3. Add files of the same type from cloud or local storage

Feature entry: Add Document on the Merge Workbooks page

  1. Tap Add Document.
  2. Choose Cloud or Local as the file source.
  3. Add the files of the same type that you want to merge.
  4. Check whether the added file list is complete.

Success Criteria

  • Interface result: the new files appear in the pending merge list.
  • Next step available: you can start the merge.

Tips While Using

  • Environment: keep the network stable when adding files from cloud storage.
  • Common mistake: add files of the same type to keep later cleanup easier.
  • Membership: this feature requires WPS Premium.

4. Start the merge and wait for completion

Feature entry: Start Merge on the Merge Workbooks page

  1. Confirm that the sheets and files to merge have all been selected.
  2. Tap Start Merge.
  3. Wait for the merge process to finish.
  4. Review the merged result after completion.

Success Criteria

  • Interface result: the merge process finishes and a result is generated.
  • Next step available: you can review, verify, or edit the merged content.

Tips While Using

  • Common mistake: when many large files are involved, avoid triggering the merge repeatedly.
  • Membership: this feature requires WPS Premium.