If you want to import data from external sources into Microsoft Dataverse, you can use the data import feature. Data import lets you upload data from various customer relationship management systems and data sources into Dataverse. You can import data into standard and customized columns of most business and custom tables. You can also include related data, such as notes and attachments.
Dataverse includes a web application tool called Import Data Wizard. You use this tool to import data rows from one or more comma-separated values (.csv), XML Spreadsheet 2003 (.xml), or text files.
For more information about the Import Data Wizard, see Dataverse Help.
The Dataverse web services provide the following additional capabilities that aren’t available in the Import Data Wizard:
Create data maps that include complex transformation mapping, such as concatenation, split, and replace.
Define custom transformation mapping.
View source data that is stored inside the temporary parse tables.
Access error logs to build custom error reporting tools with improved error logging views.
Run data import by using command-line scripts.
LookupMapXML tags in the data map to indicate that the data lookup will be initiated and performed on a source file that is used in the import.
OwnerMetadataXML tags in the data map to match the user rows in the source file with the rows of the user (system user) in Dataverse.
Use optional validation checks.
Validation isn’t optional in the Import Data Wizard.
To implement data import, you typically do the following:
Create a comma-separated values (CSV), XML Spreadsheet 2003 (XMLSS), or text source file.
Create a data map or use an existing data map.
Associate an import file with a data map.
Upload the content from a source file to the associated import file.
Parse the import file.
Transform the parsed data.
Upload the transformed data into the target Dataverse server.
You can import data from one source file or several source files. A source file can contain data for one table type or multiple table types.
Parsing, transforming, and uploading of data is done by the asynchronous jobs that run in the background.
By default, all custom tables are enabled for import. To determine if a business table is enabled for import, see the metadata for the specific table. If the table is enabled for import, the definition property
IsImportable is set to
true. The value of this property can’t be changed for the out-of-the-box business tables.
Prepare source files for import
Create data maps for import
Add transformation mappings for import
Configure data import
Run data import
Data import tables
Sample: Export and import a data map
Sample: Import data using complex data map