Remove Duplicate Email Addresses from the Exported Excel File

One of the most read articles on the blog is still the old favourite: Extracting Email Address from Outlook 2007 folder post which I wrote in 2008. When you follow the steps there it results in an Excel file being created which contains all your email address.

Today, I received an email from Sithan Kanna who writes the following:

Let’s face it Liron, your 2008 article on Extracting E-mail addresses from Outlook, is…is….is……..[Take your favourite synonym for "Awesome", times it by 2 and insert here]

A popular question that comes up in the comments section is about removing duplicate e-mail addresses.

To help your readers, I’ve written an article for your site titled: “Removing Duplicate Email Addresses from the Exported Excel File (Excel 2007)” as an extension for your previous article.

wow – I am humbled by the email and by Sithan taking the time to assist other and share his knowledge.

so follow these steps to:

Remove Duplicate Email Addresses from the Exported Excel File

In a previous article you learnt how to export the e-mail addresses from an Outlook folder to Excel. Unfortunately, in the .csv file you will notice duplicates of the same e-mail addresses.

Here is what you do to remove the duplicates:

1. In Excel 2007, you will see a list of all the e-mail addresses that you exported from Outlook

Remove duplicate email address

2. To remove the duplicates, select (highlight) the list

o Excel Shortcut: Ctrl + Shift + Down_Arrow

Remove duplicate email address

3. Under the ‘Data’ section of the Ribbon click on ‘Remove Duplicates’

Remove duplicate email address

4. A dialog box titled ‘Remove Duplicates’ will appear. Click on OK

Remove duplicate email address

5. Excel will remove the duplicates and tell you the number of unique addresses

Remove duplicate email address

6. Click on OK and you’re done!

Remove duplicate email address

One Comment

on “Remove Duplicate Email Addresses from the Exported Excel File
One Comment on “Remove Duplicate Email Addresses from the Exported Excel File
  1. Pingback: Extracting Email Address from Outlook 2007 folder « The Techie Guy – Liron Segev

Add your comment