Deduping an email list using Excel is easier than you think.
Since we are asked quite often about removing duplicates in an email list, we thought it might be time to post a simple “How To” guide explaining how easy it really is to dedupe an email list using Excel.
Using Excel to remove, view or hide duplicates in 3 steps or less.
3. Click OK in the selection box. As you can see in the image below, Excel will tell you how many duplicates it found as well as how many unique values remain. The duplicates will be removed with only the first instance of the records remaining.
This will treat the first instance of the records as the master value and delete all others.
What if you want the first instance of the duplicate record to not be in your list either? Or, you are interested in viewing each duplicate instance and determining for yourself if you want to keep it? Luckily this is made simple with conditional formatting.
If your email list is larger, follow these steps to sort your formatted list for easy viewing.
The previous two options were easily done, but maybe you don’t want to delete the duplicates from your list – Maybe you just want to hide them. Here is way to quickly dedupe your data by hiding the rows that contain duplicate data.
Now that was pretty easy – Wasn’t it?
Remember, even if you have a list of unique emails, you should consider using Purelist to scrub and clean your emails or have your email list cleaned and validated before sending to it. Having undeliverable emails in your list or sending to complainers, spam seeds or dead domains will only cause your IP Reputation to be damaged. Keeping your email list clean, valid, deliverable and free from spam seeds or BOTS will help you deliver your marketing emails to your users inbox on a more consistent basis.