ColurianCOLURIAN
← All free tools Free tool

CSV duplicate finder

Find and remove duplicate rows in a contact or company list before you import it. Match on email, name, phone or any column, ignore case and punctuation, and download a clean file.

Free, no sign-up · Runs in your browser · Updated

Find duplicate rows in a contact list

Choose a CSV file, pick the columns that identify a person or company, and download a copy with the duplicates removed. The file is read in your browser and never uploaded.

No file handy?

The first row of the file must be the column headings. The first copy of each duplicate is the one kept.

In Colurian, duplicate rules stop a duplicate being saved, imports can skip rows that match existing records, and Merge combines two records into one.Book a demo

In short: pick a CSV file, choose the columns that identify a person or company (usually email), and the tool groups the rows that match. Download a copy with the duplicates removed, or just the duplicates so you can review them. The file is read in your browser and never uploaded.

How matching works

  • Every ticked column must match. Ticking Email alone finds rows with the same email. Ticking First Name, Last Name and Company finds the same person when the email differs.
  • Loose matching is on by default. Upper and lower case, spaces and punctuation are ignored, so "Acme, Inc." matches "acme inc" and "Maria@Northpeak.com" matches "maria@northpeak.com".
  • Phone numbers compare by digits. "(415) 555-0134", "415-555-0134" and "+1 415 555 0134" all count as the same number. A leading US country code is ignored.
  • Blank values never match. Two rows that both have an empty email aren't treated as duplicates of each other.
  • The first copy is kept. In each group, the row nearest the top of the file is kept and the rest are removed. Sort the file first if you'd rather keep the newest or most complete row.

Before you import

  • Clean the list first, then import. Removing duplicates in the file is much faster than merging records one by one after they're in your CRM.
  • Check matches on email and on name. People often appear twice with a work and a personal address. Run the tool once on Email and once on First Name + Last Name + Company.
  • Look at the duplicates file. If a removed row holds details the kept row doesn't (a phone number, a note), copy them across before importing.
  • Keep the original. The tool never changes your file; it downloads new ones.

Frequently asked questions

Is my file uploaded anywhere?

No. Your browser reads the file and does the matching itself. Nothing is sent to Colurian or anyone else.

How big a file can it handle?

Up to 50 MB, which is hundreds of thousands of rows on a typical laptop. Very large files take a few seconds to read.

Does it work with Excel files?

Save the sheet as CSV first (File → Save As → CSV). The first row must be the column headings.