Following on from a previous example, we can use Excel to update records in Dynamics 365 by exporting the records to an Excel file. To do this, select the records you would like to export in Advanced Find:
Export:
Open the downloaded spreadsheet and make an update to an account:
Save the Excel file. Create a new Import in Dynamics 365 under Data Management->Imports:
Select No to Allow Duplicates:
Click Submit to run the import. It will show the one updated record as successful:
Confirm in Dynamics 365 the record has been updated:
Keep learning. Keep building.
Explore AI, agents & Microsoft technology.
I share practical ideas, tutorials, and videos about AI, AI agents, Microsoft technologies, and the Power Platform.
Subscribe on YouTube →Carl de Souza Enterprise Architect at Microsoft · AI Technology Expert
[…] Please refer to this: https://carldesouza.com/updating-dynamics-365-records-using-export-and-import-with-excel/ […]
Thank you Carl, very helpful.
Could the Excel worksheet be corrupted if I use a formula (like VLOOKUP) to update the data?
is possible update a related record (N:1), with excel?