Check out the latest Sales updates!Learn about the key capabilities and features of Dynamics 365 Sales and experience some of the new features.
Download overview guide | Watch Sales video
2020 release wave 1Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I need to update about 2,000 existing leads on my CRM. I'm currently using the latest Dynamics 365 update (2020). I've recently created a new field and need to add certain values for that field for every existing lead (different value for each lead). I've worked with other CRMs before, like Hubspot and Zoho, and I know you can just upload an Excel file (either a .csv, .xls or a .xlsx) and it would automatially identify each lead record and update their value.
Thanks for the help!
Yes, we can update existing Leads records by uploading Excel.
It is divided into three steps: ① export the data to an Excel file and download it, ② modify the data in the Excel file, ③ import the modified Excel file into D365.
For example, I want to modify the "Business Phone" field of Leads.
Here I share a quick way.
Open the Advanced Find, search for Leads, select a view, you can add new filters on the view, the purpose is to search out all records to be modified.
Click Edit Columns to add the fields you want to modify.
Click Result to view the search results. We can see that the fields to be modified have been added. Click Export Leads > Static Worksheet to download it.
Open the downloaded Excel file and modify records. All field values must conform to the field format.
Go to a Lead view, click Import form Excel. Upload the modified file.
After finishing import, go to Advanced Settings > Data Management > Imports to see the import result.
Dear Jose,Greetings of the day!In regards to your concerns, You should do this using Export to excel ->Open in Excel Online feature.For that you have to add your field in view & from entity list view, Go to Export to excel -> Open in Excel Online. It will open entity records list in excel,from that you have to add/ value of field which you have to update for all records & then click on "SAVE CHANGES TO DYNAMICS" (For unified interface click on "SAVE"). It will update all change to dynamics. You will also able to create records by adding row of data in excel & then save that. Also, kindly refer the link below for your reference.Link: https://www.marksgroup.net/blog/dynamics-365-use-excel-online-to-make-importing-or-editing-read-only-records-a-breeze/
I hope it helps! Kindly go through the link and feel free to let us know in case of any other concerns, we would be happy to assist you further for the same.
Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
DynamicsCRM Customer Portal for Wordpress
Dynamics CRM Customer Portal
This is the new way by which you can update data in Dynamics 365 using excel but without upload, you can refer below blog:
And in case you want to go with upload excel file process in Dynamics 365, you can refer below blog:
Business Applications communities