Importing data using the templates within CRM makes the import process very smooth and easy. You are able to see all of the required information that needs to be filled in prior to importing the data. You are able to import data to appropriate fields within CRM since the fields also get mapped automatically to the desired fields.
Templates are available for all entities.
You are able to access these download templates by following the steps below:
- You can find the template on the ribbon of the entity itself
- Or you can click on SettingsàData Managementà Templates for Data Import
- You are able to select the entity you want to import the data for
- The file saves as a .xml file on your computer
- Open the file and fill in the appropriate information
- All the fields that are bolded are required fields
- You just need to fill in the information that you want to see in your CRM form when you open the entity
- As for the lookup fields, such as the Primary Contact and Parent Account, you can add them there only if they already exist in CRM
Save the file – keep the xml format because it automatically maps the correct fields
The file formats that are supported by CRM are Comma-separated values (.csv), Text (.txt) , Compressed (.zip), and Excel Spreadsheet 2003 (.xml)
You can import the file by clicking the import button from the ribbon or by digging into the settings area:
Click on the import button on the ribbon
Click on Settingsà Data Managementà Importsà Import Data
Select the file – if you do the .xml format, the entity and the fields will map automatically
You can find your imported file within the imports section
You can now import your files rather than entering endless amount of data manually one by one.
I hope you found this blog helpful! Check out out our other Dynamics CRM resources like our CRM Book for even more great information!