Mass Editing Dynamics CRM 2011 Records using Microsoft Excel

How do I accomplish this without using the Edit button in MSCRM 2011 which limits me to up to 250 records at a time? 

(http://www.powerobjects.com/2011/09/27/mass-editing-dynamics-crm-2011-records-using-microsoft-excel/)

How to Solve?

In Dynamics CRM 2011 you have the ability to export data to Excel, make changes to that data and then import them back into CRM. 

Here is how you do it……

First, find a view with data that you want to edit. In this example the view is Active Accounts. All the records in your view do not need to be displayed on the same page. For example if in the bottom left of your page you have something that looks like this:

No need to worry, we’ll include all the records from the View in the next step.

Next, select Export to Excel from the Ribbon

In the new window that opens, select Static worksheet with records from all pages in the current viewand select Make this data available for re-importing by including required column headings. Then select the Export button.

Save the export (It should save as an XML document) and then open the file.

The export will have the same columns as the view from CRM.

Now change your data. For example, if you want to change the lead source for records use the lead source drop down.

Make your changes and then save your file. Make sure you keep it in the same XML format.

Go back into CRM and select Import Data and then Import Data again.

Find your file using browse and then select next

Determine if you want to allow duplicates and who will be the owner of records if an owner is not already assigned. Then select Submit.

After you hit Submit you should see:

Then check back on your Active Accounts View ( it may take a minute to refresh depending on how many records are being edited) and the changes we made in Excel should be reflected in your CRM records.

Summary