Skip to main content



No record found.

Dynamics 365 general forum
Suggested answer

Excell contacts imported to Microsoft Dynamics

Posted on by
I exported my sugar crm contacts into excel. Now I want to import them from excel to dynamics crm. 
please helped 
  • Suggested answer
    RudyZhang Profile Picture
    RudyZhang Microsoft Employee on at
    Excell contacts imported to Microsoft Dynamics
    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.
    I hope my answer is helpful to you! If you have any other questions, please feel free to contact me.
    Best Regards,
    Rudy Zhang

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

nmaenpaa Profile Picture

nmaenpaa 101,148


Featured topics

Product updates

Dynamics 365 release plans