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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / import / export contac...
Microsoft Dynamics CRM (Archived)

import / export contacts from an excel "model" file

(0) ShareShare
ReportReport
Posted on by Community Member

Hello everybody,

I want to find a solution to a problematic about the contacts in CRM. I would like to manage a lot of contacts in an other application. This contacts have been imported from CRM in a excel file, no problem so far. All this contacts can be modify, added, deleted by all the users of our group, in our application. I would like to create a "referent" excel file (or another type of file), that could be used by CRM to update himself time after time, and when new contacts will be added in CRM, it should be also in capability to update this file. What kind of solution can help me? Thanks a lot,

JohanD

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    ScottDurow Profile Picture
    ScottDurow 21 on at

    Hi,

    If you want to periodically clean/create new contacts you can use the export/reimport feature. This way you can export your contacts, edit them in excel online and then re-import. Any changes will be made and new rows will be added.

    It really is a neat feature!

    See www.microsoft.com/.../analyze-your-dynamics-365-data-in-excel-online.aspx

    Hope this helps

  • Community Member Profile Picture
    Community Member on at

    Hi Scott, thanks for your reply. I know this fonction, I search something similar but entirely automatic...

  • Community Member Profile Picture
    Community Member on at

    Hi Johan

        I think you can use Scribe to implement this function, create two DTS package.  One use The Excel file as the source ,CRM as the target. Use opposite setting in other DTS.

        Then you can event based or create publisher for your integration package to make it update time after time. 

  • Community Member Profile Picture
    Community Member on at

    Hi Yu,

    Thanks for your reply. I'm gonna study that but there wouldn't be an intern solution in CRM for this kind of problematic?

  • Community Member Profile Picture
    Community Member on at

    As far as I know, export the data into an Excel dynamic/pivot worksheet is the closest out of box function to your requirement, which will provide the update to date data from CRM in the Excel.

    Check below link which may give you some idea how to integrate excel and CRM.

    www.dynamicscrmpros.com/using-microsoft-excel-as-a-data-entry-tool-for-microsoft-dynamics-crm

  • Suggested answer
    ScottDurow Profile Picture
    ScottDurow 21 on at

    An alternative to Script would be Kingswaysoft's SSIS toolkit - www.kingswaysoft.com/.../ssis-integration-toolkit-for-microsoft-dynamics-crm

    You can use the Upsert function.

    I really think that the Export to Excel and re-import is going to be the most efficient mechanism for you!

    Let us know how you get on!

  • Community Member Profile Picture
    Community Member on at

    Thanks to Yu Tian and Scott for your replies. I'm gonna study your interresting solutions and I come back to you ! Thanks again.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
JS-09031509-0 Profile Picture

JS-09031509-0 3

#2
AS-17030037-0 Profile Picture

AS-17030037-0 2

#2
Mark Eckert Profile Picture

Mark Eckert 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans