How to Find Duplicate Values in Excel

When preparing your cold email campaigns, sometimes the data that you want to import might include multiple contacts at the same company. If your cold emailing strategy is to send outreach emails to only one prospect, then you will need to deduplicate some of the columns.

  1. Open your CSV file in Excel and select the column that you want to find duplicates for. For example, company or email or website.
  2. Click on the Conditional Formatting icon and select Highlight Cell Rules then Duplicate Values
  3. On the New Formatting Rule dialog box, click on the Ok button

Now your duplicate values will be highlighted in red. If your data provider has provided you with generic email addresses such as info@somecompany.com then you should also check for duplicate values on the email column.