Skip to main content
Microsoft Dynamics CRM forum
Suggested answer

Bulk upload contacts with fuzzy match to organisation

editSubscribe (0) ShareShare
ReportReport
Posted on by
Is it possible to do a bulk upload of contacts with a fuzzy/ approximate match to the organisation?
For example;
I have 10 contacts in an excel file csv/xls with first name, key name, job title & email address. I also have the organisation they work for but as it is free text it can vary as below;
 
Name in Dynamics - Tesco
 
Name client has filled in as organisation - tesco , teco, Tesco PLC, Tesco store northside (etc)
 
I have tried to bulk upload a single contact with the organisation mapped to 'Teco' but as its not an exact lookup match it throws up an error message and fails. Is there anyway of having it fuzzy match to organisation?
Or any fast work-arounds for this? Current process is either fuzzy lookup within excel to then exact match organisation before importing. Or importing without organisation and manually linking. Both of which take a considerable amount of time.
 
Thanks, 
  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju on at
    Bulk upload contacts with fuzzy match to organisation
    Hi Partner,
    The organization column you mention is a record on another table in dynamics, the lookup column on contacts, right?
    When mapping fields through the Import Data Wizard, exact match fields are used.
    If you want to use fuzzy matches to map fields, perhaps try using the following tool:
    https://syncratec.com/importing-contacts-into-dynamics-365/
    I hope you can mark my answer verified if it answer your question! If you have any questions, please feel free to contact me.
    Regards,
    Leah
     

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 282,978 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans