Find duplicate rows across selected sheets

Use Find duplicate rows across selected sheets to spot repeated data across tabs before consolidating or cleaning.

---

How it works

1. Open the tool
   Extensions → Text To Table Converter → Mega Tools → Find duplicate rows across selected sheets.

2. Pick sheets and columns

   • Choose two or more sheets to compare
   • Select the columns that define a duplicate (e.g., Email, User ID)

3. Run comparison
   Click Find duplicates to scan the selected sheets and list matches.

4. Review results
   The results table shows sheet names, row numbers, and matched keys. Use checkboxes to pick rows to act on.

5. Apply actions

   • Highlight duplicates in their source sheets
   • Copy matches to the clipboard or a new sheet
   • Delete or archive duplicates (if enabled in your build)

Tipp

If you have very large sheets, start with narrower column sets (like a unique ID) to improve performance.