A duplicate lookup reference was found while importing data to CRM 2011/2013/2015


Today I got the below error when I imported a contact csv file.

A duplicate lookup reference was found

In the .csv file there are only two columns FirstName and Account Lookup. Opened CRM and checked in Account and found that multiple accounts has the same name  and CRM while creating the records was unable to find the exact record and failing by throwing an error.

The fix for it is very simple, we need to find out one value which is unique. When I say unique, the one that comes to our mind is GUID of the record. Well, we can use this too but most of the cases we won’t be having the GUID while importing then we can consider Account Number field or some other field which is unique.

After finding the unique field, fill the .csv with the respective values and import it using the wizard. In the wizard while mapping the fields we have a chance of the changing the mapping criteria. Map the unique field and we are done.

Hope this helps.

Happy CRM’ing

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s