How to avoid duplicate records while importing?

How to avoid duplicate records while importing?


While importing records, you can use the Skip or Overwrite option to avoid creating duplicate records. The duplicate records are identified based on a particular field for each type of record. Following are the fields for each type of record:

  • Leads - Email
  • Contacts - Email
  • Accounts - Account Name
  • Potentials - Potential Name
  • Cases - Subject
  • Solutions - Title
  • Campaigns - Campaign Name
  • Vendors - Vendor Name
  • Products - Product Name

Consider the scenario: You do not use the above mentioned fields and you want to update a list of records with additional details. While importing the file with the updated records, you want to check for duplicate records.   In such cases, you can use the Record ID to check for duplicate records. Each record in  CRM has a unique ID. When you export the records, you can get their individual Record IDs. To check for duplicate records while importing, do the following:

  1. Export the records that you wish to update. The exported file will include the Record IDs.
  2. Make the necessary changes to the records in the file.
  3. Import the file in  CRM with the Overwrite option.
    • Duplicates will be checked based on the record IDs.
    • When a duplicate record is found in CRM, it will be overwritten with the data in the import file.
    • Only the mapped fields will be overwritten.
    • If the Record ID field is not mapped, new records will not be created.
    • Related Articles

    • Merge Duplicate Records

      This feature helps you to find duplicate records in bulk and merge them as one record. With this you have an option to search all duplicate records in a module based on a selected field's value. You can choose any one from the 4 fields that are ...
    • Find & Merge Duplicate Records

      This feature gives you the option to specify criteria to find duplicate records. There are 6 fields in which you can specify the criteria in each module. The Find and Merge feature is available only in the Leads, Accounts, Contacts and Vendors ...
    • How to assign records to other users while importing data?

      In XLS or CSV file, ensure that users' CRM ID is specified so that the records will be automatically assigned to the corresponding users. Please note that, records with blank values for CRM ID will be assigned to the person who imports the data. In ...
    • On what basis are the duplicate records identified during import?

      While importing records, there are options to overwrite, skip and clone the duplicate records. All the duplicate records are identified based on some fields for each type of record. Following are the fields for each type of record: Leads - Email ...
    • What are the mandatory fields while importing data?

      While importing data, all the mandatory fields in CRM (for the record type) needs to be mentioned in the import file. For example, if Lead Name and Company details are mandatory to add a lead in CRM, you need to have these details mentioned in the ...