How to Use WPS Data Comparison on macOS

Use WPS Data Comparison through 8 task topics; all 8 are membership-related, and you can choose the matching entry from the How-to Index below.

How-to Index

How-to Guide

1. Smart Toolbox - Mark Duplicate Data

Feature entry: Premium tab → Smart Toolbox → Data Comparison → Mark Duplicate Data

1. Select the data range that you want to compare.
2. Click the Premium tab.
3. Click Smart Toolbox.
4. Under Data Comparison, select Mark Duplicate Data.
5. Set the comparison parameters and comparison range.
6. Click Confirm to Mark.
7. Review the highlighted duplicate entries.

Success Criteria

• Interface result: Duplicate entries are highlighted in the current sheet.
• Next action available: You can continue filtering, editing, or copying the results.

Tips While Using

• Membership: This task requires WPS Premium.
• Environment: Make sure the selected range contains comparable data before you start.

2. Smart Toolbox - Extract Duplicate Data

Feature entry: Premium tab → Smart Toolbox → Data Comparison → Extract Duplicate Data

1. Select the data range that you want to compare.
2. Click the Premium tab.
3. Click Smart Toolbox.
4. Under Data Comparison, select Extract Duplicate Data.
5. Set the comparison parameters and comparison range.
6. Click Export to New Worksheet.
7. Review the extracted duplicate entries in the new worksheet.

Success Criteria

• Interface result: A new worksheet is created.
• Next action available: You can organize, save, or export the extracted results.

Tips While Using

• Membership: This task requires WPS Premium.
• Common mistake: If no range is selected first, the extraction result may not match your expectation.

3. Smart Toolbox - Mark Different Data

Feature entry: Premium tab → Smart Toolbox → Data Comparison → Mark Different Data

1. Select the data range that you want to compare.
2. Click the Premium tab.
3. Click Smart Toolbox.
4. Under Data Comparison, select Mark Different Data.
5. Set the comparison parameters and comparison range.
6. Click Confirm to Mark.
7. Review the highlighted different entries.

Success Criteria

• Interface result: Different entries are highlighted.
• Next action available: You can continue checking or correcting the data.

Tips While Using

• Membership: This task requires WPS Premium.
• Common mistake: If the compared structures differ too much, the result may be harder to review directly.

4. Smart Toolbox - Extract Different Data

Feature entry: Premium tab → Smart Toolbox → Data Comparison → Extract Different Data

1. Select the data range that you want to compare.
2. Click the Premium tab.
3. Click Smart Toolbox.
4. Under Data Comparison, select Extract Different Data.
5. Set the comparison parameters and comparison range.
6. Click Export to New Worksheet.
7. Review the extracted different entries in the new worksheet.

Success Criteria

• Interface result: A new worksheet containing different entries is created.
• Next action available: You can save the result separately or continue analyzing the differences.

Tips While Using

• Membership: This task requires WPS Premium.
• Environment: Confirm the comparison scope before extraction to avoid unexpected results.

5. Data Tab - Mark Duplicate Data

Feature entry: Data tab → Data Comparison → Mark Duplicate Data

1. Select the data range that you want to compare.
2. Click the Data tab.
3. Click the Data Comparison drop-down menu.
4. Select Mark Duplicate Data.
5. Set the comparison parameters and comparison range.
6. Click Confirm to Mark.
7. Review the highlighted duplicate entries.

Success Criteria

• Interface result: Duplicate entries are marked in the sheet.
• Next action available: You can continue filtering, copying, or editing the results.

Tips While Using

• Membership: This task requires WPS Premium.
• Common mistake: An incomplete selection may cause some duplicate entries to be missed.

6. Data Tab - Extract Duplicate Data

Feature entry: Data tab → Data Comparison → Extract Duplicate Data

1. Select the data range that you want to compare.
2. Click the Data tab.
3. Click the Data Comparison drop-down menu.
4. Select Extract Duplicate Data.
5. Set the comparison parameters and comparison range.
6. Click Export to New Worksheet.
7. Review the duplicate entries in the new worksheet.

Success Criteria

• Interface result: A new result worksheet is created.
• Next action available: You can save or process the extracted results further.

Tips While Using

• Membership: This task requires WPS Premium.
• Common mistake: Before extraction, make sure you can easily locate the generated result sheet in the workbook.

7. Data Tab - Mark Different Data

Feature entry: Data tab → Data Comparison → Mark Different Data

1. Select the data range that you want to compare.
2. Click the Data tab.
3. Click the Data Comparison drop-down menu.
4. Select Mark Different Data.
5. Set the comparison parameters and comparison range.
6. Click Confirm to Mark.
7. Review the highlighted different entries.

Success Criteria

• Interface result: Different entries are highlighted.
• Next action available: You can continue checking where the two datasets differ.

Tips While Using

• Membership: This task requires WPS Premium.
• Environment: Keep the compared data structures as consistent as possible for easier review.

8. Data Tab - Extract Different Data

Feature entry: Data tab → Data Comparison → Extract Different Data

1. Select the data range that you want to compare.
2. Click the Data tab.
3. Click the Data Comparison drop-down menu.
4. Select Extract Different Data.
5. Set the comparison parameters and comparison range.
6. Click Export to New Worksheet.
7. Review the different entries in the new worksheet.

Success Criteria

• Interface result: Different entries are output to a new worksheet.
• Next action available: You can archive the result separately or share it with collaborators.

Tips While Using

• Membership: This task requires WPS Premium.
• Common mistake: If the comparison scope is set incorrectly, the extracted result will differ from your expectation.