The Microsoft Business Applications Practice at HCLTech is thrilled to be at HIMSS23 in April. That’s right, we’re back in person and excited to be one of the select partners to share a booth with Microsoft.
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:
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!
Very informative Article,but I didn't find any option to set the format of template, actually wanted to change order of the columns is Data Template feature can I use if here template is not allowed to define. Please response Thanks.
Very informative Article,but I didn't find any option to set the format of template, actually wanted to change order of the columns. Can I use Data Template feature if here template is not allowed to define. Please response Thanks.