Use Excel to create, update, upsert or delete records in Dataverse. Now with better logging, the ability to save and re use data maps, and faster data entry.
Latest version release notes
Adds record state as a lookup field, enables letters and tasks to be marked as completed after creation, adds support for PartyList on Activities. Thanks to @mattc-ri for these updates! V2 of DataImport++ added a new log table, the ability to save / load data maps, smoother mapping functionality, bug fixes and UI improvements.
Can't use this tool. Presents with a wix.com Error page.
Ibrahim Jbeily () - version 1.2019.2.44
Charles Toolbox () - version 1.2019.2.44
This plugin just saved me hours for a one shot import! Very useful tool especially for upserts or updates based on multiple keys.
Nipper Napp () - version 1.2019.2.44
Solid concept. Especially for upsert. But unfortunately doesn't work at all. Locks up every time. IE: Stays spinning on x%. The highest I got was 67% before lockup. Doesn't matter what type of connectivity is used.
No logs anywhere.
Plus, selection on the grid takes 4-clicks per item to get the list to come up.
Also, "Blank EXCEL CELL" default's to "Clears CRM value" rather than leaving the original value. That's a significant design flaw; Deletion should certainly not be the default. Ever.
And, again, it takes 4 clicks on each line to flip the item to "Keeps CRM value".
An abysmal UX overall.
4-Years since last updates. I guess we shouldn't expect much. But if it's buggy, then it shouldn't be a part of the offering until it's updated.
I wish I had time to branch & modify to contribute rather than just appear to complain. I just don't. I look forward to an update someday.
Mark Pitts () - version 1.2019.2.44
There is a flaw when using this tool for update. When identifying the 'is key' column, the tool should automatically make/validate the 'CRM Field' is populated. Failure to do so, will take the first row, in the import Excel file, and try to update every record, without considering a key field.
Tool author answer ()
Hello Mark,
Thank you for your feedback! Indeed while choosing a column as being your key field (in update or upsert cases) you should always make sure that it contains data, otherwise the tool will try mapping to an "empty key" in order to find CRM data (and would then capture wrong unexpected records)
Michael Cai () - version 1.2019.2.44
Awesome plugin! Really handy for importing data using fields as a unique key to update and/or create new records. I've been looking for a resource like this for a long time. Previously I've had a custom entity created with a lookup field to the entities I want to update to perform this task. Now it can be done with ease.
Note that it does take a bit of time if you're trying to update big rows of data.
Tool author answer ()
Hi Michael,
Thanks a lot for your feedback!
Aymeric de Belizal () - version 1.2019.2.43
Awesome tools the simplify the import and allows us to do upserts and use several fields to ensure that a lookup to the intended record.
Helped me a lot.
Related information
Author: Joseph Merhej and Andrew HowesLatest version: 2.1.9303.20484Released on: 06/21/2025Nuget package Id: JosephMerhej.DataImportOpen Source: trueGo to project web site Ratings (all versions)5Average rating11Number of ratings Downloads132Latest version73993All versions4352.53Average per version TagsDataMigration
