Import records from a file.

This task requires permissions that are found in all default security roles (Defined sets of privileges. The security role assigned to a user determines which tasks the user can perform and which parts of the user interface the user can view. All users must be assigned at least one security role in order to access the system.).

More information about specific permissions and performing this task while offline:

Common Task Permissions
To ensure a successful import, be sure to follow the steps in Prepare a file for import.

In the Navigation Pane, click Workplace, and then under My Work, click Imports.

– OR –

On the Tools menu, click Import Data.
On the Actions toolbar, click New.
Click Browse to find the file to import.
If you are not using the default delimiters, which for data are double quotation marks (" ") and for fields are commas (,), you can select other symbols as the delimiters.
Other recognized delimiters for data include: single quotation marks (' ') and none.
Other recognized delimiters for fields include: colons (:), tabs, and semicolons (;).
Click Next.
Select the record type to import the records to.
Determine how the source data will be mapped to Microsoft Dynamics CRM data:
If the column headings ( Text used in the first row of a spreadsheet or file that labels the data in each column. ) in your file exactly match Microsoft Dynamics CRM display names ( Labels that are used by default when attributes are displayed on a form, in a list, or in a report. The Display Name for each attribute can be changed in the Customization area by a user with an appropriate security role. ) , an automatic data map will be used, and the word Automatic will be entered in the Data map box.
If the Data map box remains empty, check your data file to make sure the column headings are actual display name values from the selected record type, or click the Lookup button to select a data map ( A file that contains information about how data from a source system corresponds to data in Microsoft Dynamics CRM. ) . If you do not yet have a data map, you need to create one, and then return to the wizard. More information: Work with Data Maps
In the Mapping Results section, if there are any unmapped columns or errors, click View Details.
If you have columns that cannot be imported, you will see Ignored columns: Count.
Two types of columns are ignored ( Data in the source file will not be imported. ) : computed columns, such as Full Name in the contact record type, and columns for attributes that cannot be created and updated, such as Created On, Created By, Modified On, and Modified By in all record types.
If you have not mapped all business-required ( Attributes that are required before a record can be saved. Required fields are marked with an asterisk. ) columns, you will see Unmapped required columns: Count. After reviewing the details, if none of them need to be fixed, click OK.

– OR –

If you need to fix your source file, open your source file and fix the problems, click Back, and return to step 3 to select your source file.
Click Next.
In the Assign To section, to assign all the records in this import to a different user, click Lookup, and select the user.
This option is not available for organization-owned ( Records that everyone in the organization needs to access, such as products or sales literature items. Access to this type of record can be set at one of two levels: None , or Organization . ) record types such as Product.
By default, if duplicate detection is enabled for this record type, duplicate records are not imported.
If you want to import duplicates, select Import duplicate records.
This option is not available if duplicate detection is not enabled or not available for the record type you are importing.
Click Next.
Rename the import job if needed, change the notification options if needed, and then click Import.
An import job is started in the background. You can continue to work in Microsoft Dynamics CRM while the import runs.
Tips

The direct import of Microsoft Office Outlook contacts is not supported in Microsoft Dynamics CRM. However, you can export your Outlook contacts to a comma separated value (.csv) file, and then import them into Microsoft Dynamics CRM by using the Import Data Wizard. For more information about how to export items in Outlook, see the Help information in Outlook.
To pause or postpone an import:
In the Navigation Pane, click Settings, and then click System Jobs.
Select the scheduled import job, and then on the More Actions menu, click Pause or Postpone.
Note

By default, the maximum size of the file that you can upload is 4 megabytes (MB).