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 :
Service | Customer Service, Contact Center, Fie...
Answered

Data import updates existing values instead of creating new

(0) ShareShare
ReportReport
Posted on by 80

Hello everyone,

I noticed some strange and fatal bug while importing data to dynamics 365. When I import contacts from excell system updates existing records that has nothing in common with the new ones. I tried importing data with and without duplicate detection but it still updates. How can it be fixed or turned. This bug is really stopping and it ruins data and imports. Help please

Best regards,

Bohdan

pastedimage1605794672961v1.png

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at

    Hi Bohdan,

    The excel you used to import data is export from dynamics 365.

    pastedimage1605864847160v1.png

    If so, once you’ve opened the file for editing, you’ll see that columns A, B, and C are hidden. These contain pertinent data about existing records, so if you modify all data that shown in the excel, it will update records not create new records.

     pastedimage1605864864837v2.png

    After importing the modified excel:

    pastedimage1605864926035v3.png

    So you need go Settings > Data Management > Templates for data import to create blank excel template for entity that you need, download it and fill data,

    then click Imports to import it.  

    pastedimage1605865087911v4.png

    For more information, you can refer following link:

    https://www.youtube.com/watch?v=ROs06RqTIhk

    Also, you can try to use the new feature ‘Edit data in Excel’ to create and update records in Dynamics 365 CRM.

    https://www.inogic.com/blog/2020/02/new-way-for-creating-and-updating-records-in-dynamics-365-crm/

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

  • Verified answer
    Community Member Profile Picture
    on at

    Hi Partner,

    Has the problem been solved? Any updates?

    Please click Yes under "Did this answer your question?" to close this thread.

    pastedimage1605866287331v1.png

    Thanks. 

    Regards,

    Leah Ju

    Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

  • Bohdan_Y Profile Picture
    80 on at

    Thank you very much, this is what I was looking for!

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
NeerajPawar Profile Picture

NeerajPawar 31

#2
Tom_Gioielli Profile Picture

Tom_Gioielli 19 Super User 2026 Season 1

#3
11manish Profile Picture

11manish 18

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans