Update records using the Import Data Wizard
You can export existing records, add or change data in the exported records, and then import only those records with changes.
- Use Advanced Find to select the records that you want to update and the columns to export.
- Export the data to Excel. Make sure that you select the Make this data available for re-importing by including required column headings check box.
For more information, see Export to an Excel static worksheet to store unvarying data.
If you are using Microsoft Excel 2010, do not click Open. Clicking Open results in the error "The file is corrupt and cannot be opened." To avoid this, first save the file, and then open it. If the file still does not open, do the following:
- Add the Microsoft Dynamics CRM Online URL to your browser’s Trusted site security zone.
- Unblock the security in the downloaded Excel file.
- In Microsoft Excel 2010, enable Protected View for files originating from Internet.
- Open the Excel spreadsheet.
If you see an error message, The file you are trying to open 'Filename' is in a different format than specified by the file extension, click Yes.
- Add new data or change existing data in the spreadsheet.
Do not delete or modify the data in columns that are marked DO NOT MODIFY.
Some columns in the spreadsheet are kept hidden on purpose:
- Two hidden columns. One column contains the globally unique identifier (GUID) for the record. The other column contains the date and time the record was modified last.
- The column headings.
- Save the spreadsheet.
- On the File tab, click Tools, and then click Import Data.
- Select the spreadsheet file that you saved in step 5. Note that:
- You can only update the modified rows or create records from the inserted rows of the exported file. The Import Data Wizard does not recognize deleted rows from the exported file. That is, if you delete a row from the exported file and then reimport the file, the corresponding record in Microsoft Dynamics CRM Online will not be deleted.
- A record will not update if it was changed in Microsoft Dynamics CRM Online after it was exported.
- Click Next.
- To complete the import, follow the instructions in the Import Data Wizard. For more information, see Import records from a file.
- If necessary, rename the import job and change the notification options, and then click Import.
An import job is started in the background. You can continue to work in Microsoft Dynamics CRM Online while the import runs.
By default, in Microsoft Dynamics CRM Online, you cannot export a list of more than 10,000 records at a time to a static Excel worksheet. To work around this limitation, use Advanced Find to limit records in each export to fewer than 10,000 records, and then combine your exported spreadsheets. More information: Work with Advanced Find.