Search rowmedic

Remove DuplicatesFix Date FormatRepair CSVClean TextCSV ValidatorCSV to ExcelRemove Empty RowsClean Excel DataToolsUse CasesPricingBlogHelpWhich columns make a record unique?Read a broken CSV one record at a timeStandardize dates without swapping the month and day
rowmedic
โ† All tools

Remove Duplicates

Two rows can describe the same customer and still contain different details. Start with exact matches. Use key columns when you know which fields identify one record.

Open Remove Duplicates โ†’

How to use this tool

  1. Open your file and inspect the duplicate records. Check the source row numbers to see where each copy appeared.
  2. Choose exact duplicates or select key columns. An order with several line items may need both an order ID and a line number.
  3. Choose which occurrence to keep, review the proposed removal count, and apply the repair. Export the result to a new file.

Worked examples

Original dataAfter review
Two identical rows for invoice INV-1042One copy of invoice INV-1042
Order 1042, lines 1 and 2Both 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.

Try this tool with the customer demo โ†’

Browse all tools ยท Import and export help