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 :
Microsoft Dynamics CRM (Archived)

Update Records using import

(0) ShareShare
ReportReport
Posted on by 1,680

Hello,

We have a requirement, which is very very minute one. Client sent updated information for accounts(which already exists in system) in the excel sheet. Is it possible to update data from excel sheet, without using the export for re-import? Just want to avoid the manual work.

Thanks

Drew

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Mahendar Pal Profile Picture
    45,095 on at

    No, you can't if you want to update data through import you have to export and merge your changes and re-import it.

  • Drew Inc. Profile Picture
    1,680 on at

    I found workaround, but i might not go with this. Here is the link

    www.powerobjects.com/.../updating-records-in-microsoft-dynamics-crm

  • Verified answer
    Community Member Profile Picture
    on at

    Hi,

    There is no out of the box way for your requirement (you have to export, make changes and then re-import to update records). However, you can create a small console application that can read the excel file, match the record based on some unique identifier and update the records in CRM.

  • Anneke DB Profile Picture
    215 on at

    Hi all
    How can I re-import with updating the existing records? I don't have a "enrich data" checkbox...

    I'm working in CRM online.

    Thank you,

    KR,

    Anneke

  • Community Member Profile Picture
    on at

    I tried merging and importing but it shows 0 in the Success, Partial Failures and Errors section.

  • Community Member Profile Picture
    on at

    Yes , even i faced the same issue . I updated a record in PriceListItem and imported it back to CRM 2011 , Looks like its taking that import as "Import Create"phase but not "Update Import " . How to update records and import in MS CRM 2011?

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)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans