How to use this tool
- Open your file and inspect the duplicate records. Check the source row numbers to see where each copy appeared.
- Choose exact duplicates or select key columns. An order with several line items may need both an order ID and a line number.
- Choose which occurrence to keep, review the proposed removal count, and apply the repair. Export the result to a new file.
Worked examples
| Original data | After review |
|---|---|
| Two identical rows for invoice INV-1042 | One copy of invoice INV-1042 |
| Order 1042, lines 1 and 2 | Both rows kept with Order ID + Line as the key |
Frequently asked questions
Can I match duplicates by email?
Yes. Select the email column as your key and compare the matching rows. Shared inboxes and blank addresses can belong to different people, so review the groups before applying the repair.
Does keeping the last row mean keeping the newest record?
Last refers to the current row order. If recency matters, verify the timestamps and sort the records into the intended order first.
