Using Excel to remove duplicates? There's an easier way!

All posts
March 17, 2017

Excel remove duplicates

We all know that the most valuable asset your business owns is your customer data. So it’s really in your best interests to keep the data quality of your customer database high.

What’s the worse thing that can happen to your database, next to it deletion? Duplicates!

Many businesses rely on Excel to remove duplicates in their customer databases.

How many millions of hours do you think it’ll take to transfer all your customer data to an Excel spreadsheet and manually de-dupe the whole lot? Seriously, you don’t even want to get started on that!

Is Excel the only way to remove duplicates? Nope!

Duplicates are really the worst. But you’re not alone. 51% of businesses had problems with duplicate data in their databases.

Even if your database isn’t over-run by this bane to good business practice, it’s still a good idea to do regular checks for duplicates. It’s essential if you want to sync your contacts with another cloud app using PieSync. After all, who wants two corrupt databases?

Here are our top picks of de-duping apps that will banish duplicates from your customer database, all without having to resort to Excel.


DeDuply helps you remove duplicates from your CRM. You’re able to use ten different filters to get really granular and ensure they’re removing the correct duplicates from your system.

It also flags possible duplicates and allows you to do a final manual check on these, just in case they’re not duplicates at all.

They currently de-dupe Nimble, Insightly, Agile CRM, Salesforce, Nutshell, Capsule, Pipedrive, PipelineDeals, HubSpot, OnePageCRM, Batchbook, and Highrise.

Price: from $29 per month up to 30,000 contacts.


FullContact offers automatic de-duping and merging in Google Contacts and Outlook. They use “smart scanning” to hone in on duplicates that aren’t obvious and get rid of them.

For example

You may have two entries for the same Susan Jones with different email address. Rather than just relying on the similar name, FullContact’s algorithms will go to work to find other clues about each contact in order to avoid merging two entries that aren’t duplicates.

What sort of clues do they look for?

Your contact Susan Jones ( lives in Los Angeles and works as a Digital Marketing Manager at Acme Corp, according to her Twitter profile.

Your contact Susan Jones ( is the same person, but the email address is different. However, other clues such as location or job title could be tied to this entry. If FullContact sees that information and it matches the other Susan Jones entry, then chances are very good that the contacts are duplicates. They would then merge the two contacts, combining information from both entries into a Unified Contact.

Price: from $0 per month up to 1,000 personal contacts.

If you’re working in Google Contacts you can also do a free duplicate search and delete them manually. Take a look at this blog post for in-depth instructions: No More Google Contacts Duplicates.

About Vanessa Rombaut

Vanessa is a wordsmith extraordinaire. Originally from Australia, she has travelled the world and the seven seas to write scintillating content for you to enjoy.

She likes books, travel, vintage films and sushi (not necessarily in that order).