I am trying to update and insert data in one of my custom entity using oob export and import. However while doing so, it fails if we use excel as source format, because rowchecksum keeps changing. And .CSV format fails for update and succeeds for insert. This error is received while trying to update records using .csv file. And .xlsx file error is because of Rowchecksum this error is received-
Hello Smita B,
Please refer below article which will help you to resolve your issue.
carldesouza.com/.../
Thank you,
Amit Katariya
Hi Amit Katariya007 ,
Thank You for the suggestion. Yes we were using the same method to do so for insert records and update, if for small data. But our current data comes in bulk (2K+) records we need to do one time update from .csv/excel file to our custom entity.
Can you share important excel issue.... So that it will help to understand better.
Hi Smita B,
Share the details of the error when it is failing to update.
Since the data may have been updated since the data was exported, is it possible to export the latest data, edit the Excel data, and import it?
We tried that as well, but still it doesnot work. Which is why asking the question, if I am missing something here.
We tried using.csv format, which lets us control the mapping and ignore the rowchecksum and modified on date, but the sheet only works for the new records in the sheet, whereas fails to update, even when primary key is mapped.
Can you check duplicate detection rules for that entity?
blog.magnetismsolutions.com/.../dynamics-365-partial-failures-with-excel-online-export-import
The question is:
Are you performing the steps in the sequence written below?
To answer your question - .csv because its lets you control the mappings.
And for .xlsx format, yes we have followed the exact format as you have shown.
Also have tried to get the template from the DataManagement -> Templates for Import as well. But .xlsx format throws error saying every time invalid format, as shown above, and we find, even if no data has been changed, rowchecksum ,even when row modified on remains the same, changes from time to time.
Can you try to check if u have duplicate detection rules on that entity.
Also try to upload 1 or 2 sample record only then check if issue is persistent.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Rishabh Kanaskar 149
MVP-Daniyal Khaleel 132
Tom_Gioielli 123 Super User 2025 Season 2
