News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Excell contacts import...

Microsoft Dynamics 365 | Integration, Dataverse...

Suggested answer

Excell contacts imported to Microsoft Dynamics

(0) Share

Report

Report

Posted on by Community member

I exported my sugar crm contacts into excel. Now I want to import them from excel to dynamics crm.

please helped

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

RudyZhang Microsoft Employee on at

Like (0)

Report

Excell contacts imported to Microsoft Dynamics

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

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,095 Super User 2025 Season 1

#2

Martin Dráb 232,866 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans