Skip to main content

Notifications

Dynamics 365 Community / Forums / Sales forum / 3rd party solution to ...
Sales forum
Unanswered

3rd party solution to bulk update 1000 Lead records using a list in Excel as input?

Posted on by 2,651

Hi all,

Is anyone aware of a utility (likely 3rd party) that would make it decently easy and quick (yeah, I know) to do a bulk update of various fields for an entity (Lead or Contact in this case) using a list of records in Excel as input?

To explain further: I have a list of non-consecutive Lead records (about 1000). Prod currently contains about 11K total Lead records.  The records in the Excel file span all the way across the full list in Prod and there is no field that has unique data that would identity these records in a query.  So, I need to use the Excel file as, basically, a list of 1000 parameters for a query to be able to pull down the GUID's for the 1000 records.  Once I have the GUID's, then I can obviously re-import.  Or, if the utility has some way of managing that directly, even better.

This is time sensitive and pretty critical so help is definitely appreciated!

  • AriaConsulting Profile Picture
    AriaConsulting 2,651 on at
    RE: 3rd party solution to bulk update 1000 Lead records using a list in Excel as input?

    Thanks Bipin, but this doesn't help.  It's just a more complicated way to import data from Excel.  I can import from Excel fine using the standard wizard approach but that isn't what I need.  I need to be able to UPDATE about 10% of the existing records.

  • Bipin D365 Profile Picture
    Bipin D365 28,962 Moderator on at
    RE: 3rd party solution to bulk update 1000 Lead records using a list in Excel as input?

    HI,

    You can use Data integration tool to import the data without any code. Check below article.

    carldesouza.com/.../

    Please mark my answer verified if i were helpful

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans