I have a spreadsheet in which I suspect there are duplicate email IDs. Does Zoho CRM automatically prevent import of these duplicates?

I have a spreadsheet in which I suspect there are duplicate email IDs. Does Zoho CRM automatically prevent import of these duplicates?

No. Zoho CRM does not prevent duplicates during import if they are within your import spreadsheet.

However, Zoho CRM provides duplicate check during import on email addresses with records that already exist in the CRM database. When this feature is enabled, the CRM matches the email addresses in your spreadsheet with those in the database and throws out an alert if it finds duplicates. On the other hand, if you are making an import for the first time and there are duplicates within your spreadsheet, enabling this feature will not remove those duplicates. The only way to prevent this is to make sure your import sheet is free from duplicates.

To enable the feature

  1. Click Setup > Customization > Modules and Fields.
  2. In the Modules page, select the Leads/Contacts module.
    You need to enable it separately for the Leads and Contacts modules.
  3. Select the Do not allow duplicates values for the Email field. This option is available in the Module layout for all unique fields such as Email, Phone Number, Mobile Number, Company etc. When you enable this option in the module layout, you can select the module for which you want the duplicate check to work while you're importing.  
  4. Click Save.
    You can disable this feature by clearing the Do not allow duplicates in Email field check box.                                                                                                                           
    Alternatively, you can merge duplicates after you import your leads. Zoho CRM offers two ways by which you can merge duplicate records.

  1. Find and Merge Duplicates
  2. Deduplicate tool (available only in the Professional, Enterprise editions and above). 

Related Links

How to merge duplicates

    • Related Articles

    • De-duplicate records (Auto-merge duplicates)

      In case you are not sure which records have been duplicated, you can let CRM run a check on modules using the De-duplicate tool. CRM will automatically find and merge exact matches. In case of conflicts in field values, you must manually resolve the ...

    • Checking Duplicate Records in Zoho CRM

      When you have hundreds and thousands of records in your CRM, as your business grows, it becomes a very difficult task to check for duplicates. Zoho CRM helps you arrest duplicates even before they can be created, with the help of what we call "unique ...

    • Merging Duplicate Records

      When you work with a significant volume of data, it gets quite challenging to keep your database free from duplicates. As the avenues to create records in CRM increase, the chances of duplicate entries increase as well. For example, the same lead may ...

    • Identify duplicates between leads and contacts modules

      Edition: Enterprise | Industry: Travel | Feature: Workflow rule and Functions Scenario Joshua Baker is a sales manager at an online travel agency that offers customized tour packages. The agency has a webform on its website through which interested ...

    • How do I avoid creating duplicate records while importing?

      While importing records, you can identify the duplicate records based on a unique field for each type of record. These are the fields for each type of record based on which you can check for duplicates: Leads - Email Contacts - Email Accounts - ...