web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

Excell contacts imported to Microsoft Dynamics

(0) ShareShare
ReportReport
Posted on by
I exported my sugar crm contacts into excel. Now I want to import them from excel to dynamics crm. 
 
please helped 
I have the same question (0)
  • Suggested answer
    RudyZhang Profile Picture
    Microsoft Employee on at
    Hi,
     
    According to the official documentation, to import data into a Dynamics 365 entity, you can follow these steps.
    1.Prepare the data to be imported, you can download the Excel template or prepare the Excel file yourself but note that the maximum file size allowed is 8MB.
     
    2.Open the application and then select a table from the left navigation bar, on the command bar, select the type of file you want to import from it.

    3. You also need to pay attention to the data mapping, i.e. the correspondence between the Excel columns and the entity's columns, and there are additional steps to be done for the option sets and lookup columns.
     
    Please refer to the official documentation in the link below.
    https://learn.microsoft.com/en-us/power-apps/user/import-data
     
     
     
    I hope my answer is helpful to you! If you have any other questions, please feel free to contact me.
     
    Best Regards,
    Rudy Zhang

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Martin Dráb Profile Picture

Martin Dráb 45 Most Valuable Professional

#2
iampranjal Profile Picture

iampranjal 36

#3
Satyam Prakash Profile Picture

Satyam Prakash 31

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans