Updating Dynamics 365 Records using Export and Import with Excel

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:

THANKS FOR READING. BEFORE YOU LEAVE, I NEED YOUR HELP.

I AM SPENDING MORE TIME THESE DAYS CREATING YOUTUBE VIDEOS TO HELP PEOPLE LEARN THE MICROSOFT POWER PLATFORM.

IF YOU WOULD LIKE TO SEE HOW I BUILD APPS, OR FIND SOMETHING USEFUL READING MY BLOG, I WOULD REALLY APPRECIATE YOU SUBSCRIBING TO MY YOUTUBE CHANNEL.

THANK YOU, AND LET'S KEEP LEARNING TOGETHER.

CARL

https://www.youtube.com/carldesouza

ABOUT CARL DE SOUZA