{"id":5690,"date":"2021-12-13T10:25:55","date_gmt":"2021-12-13T10:25:55","guid":{"rendered":"https:\/\/helptest.mainbrainer.com\/knowledge-base\/how-to-import-contacts-into-the-mainbrainer-crm\/"},"modified":"2022-06-20T09:22:51","modified_gmt":"2022-06-20T09:22:51","slug":"how-to-import-contacts-into-the-mainbrainer-crm","status":"publish","type":"ht_kb","link":"https:\/\/www.mainbrainer.com\/hc\/en_GB\/popular\/how-to-import-contacts\/","title":{"rendered":"How to Import Contacts into the MainBrainer CRM"},"content":{"rendered":"<div class=\"aricle_container\">\n<div class=\"aricle_container\">\n<p>As you <a href=\"\/hc\/en_GB\/crm\/manage\/create-contact-list\/\" target=\"_blank\" rel=\"noopener noreferrer\">create a new Contact List<\/a> or choose to run a secondary <a href=\"\/hc\/en_GB\/crm\/manage\/import-existing-list\/\" target=\"_blank\" rel=\"noopener noreferrer\">import for an existing Contact List<\/a>, you will be redirected to the Contacts Import Screen.<\/p>\n<p>In this article, we take you through the various steps involved in the import process and explain how import rules impact the data you import into the MainBrainer CRM.<\/p>\n<div style=\"padding: 14px 0;\"><\/div>\n<h2>Step 1<\/h2>\n<h2>Upload a CSV file<\/h2>\n<p>The MainBrainer CRM supports Contact imports via CSV files. Drag and drop the .csv file you wish to import to the area highlighted in the screenshot below. Or, click the icon to upload the .csv file.<\/p>\n<div style=\"padding: 14px 0;\"><\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2424\" title=\"CRM import upload section\" src=\"https:\/\/www.mainbrainer.com\/hc\/wp-content\/uploads\/2021\/11\/crm-import-contacts-upload-1.png\" alt=\"MainBrainer CRM import contacts. The upload section is highlighted\" width=\"640\" height=\"546\"><\/p>\n<div style=\"padding: 24px 0;\"><\/div>\n<h2>Step 2<\/h2>\n<h2>Preview your Import data<\/h2>\n<p>The subsequent screen will display a preview of the first 100 Contacts from the CSV file that you are importing. In case the first row of the file that you are importing contains header data, remember to mark the checkbox <em>(as highlighted in the screenshot below).<\/em><\/p>\n<div style=\"padding: 14px 0;\"><\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2426\" title=\"CRM import preview\" src=\"https:\/\/www.mainbrainer.com\/hc\/wp-content\/uploads\/2021\/11\/import-crm-contacts-preview.png\" alt=\"MainBrainer CRM import contacts, preview tab. Consider first row box is highlighted\" width=\"640\" height=\"558\"><\/p>\n<div style=\"padding: 24px 0;\"><\/div>\n<p>Click <strong>Continue<\/strong> to proceed with the import.<\/p>\n<div style=\"padding: 14px 0;\"><\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2432 size-full\" title=\"Contacts import preview button\" src=\"https:\/\/www.mainbrainer.com\/hc\/wp-content\/uploads\/2021\/11\/import-contacts-preview-button.png\" alt=\"MainBrainer CRM import contacts, preview tab. The continue button is highlighted\" width=\"476\" height=\"212\"><\/p>\n<div style=\"padding: 24px 0;\"><\/div>\n<h2>Step 3<\/h2>\n<h2>Map the Imported Data to appropriate CRM columns<\/h2>\n<p>On the <strong>Mapping<\/strong> screen, you will be prompted to map the columns in your import file to the relevant field in the MainBrainer CRM. The entries under the heading <strong>Column Name<\/strong> represent the columns in your import file. The entries under the heading <strong>Map to field<\/strong> represent the fields available in the MainBrainer CRM.<\/p>\n<div style=\"padding: 14px 0;\"><\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2434\" title=\"CRM import mapping\" src=\"https:\/\/www.mainbrainer.com\/hc\/wp-content\/uploads\/2021\/11\/crm-import-contacts-upload.png\" alt=\"MainBrainer CRM import contacts, mapping tab. List of default fields is highlighted\" width=\"640\" height=\"464\"><\/p>\n<div style=\"padding: 20px 0;\"><\/div>\n<p>Here, you need to specify which columns in your import file correspond to the relevant field in the MainBrainer CRM. To do that, use the dropdown under the heading <strong>Map to Field<\/strong> corresponding to that field <em>(as highlighted in the screenshot above)<\/em>. The dropdown will display all the CRM fields available for mapping. In case you wish to map the data to a custom field, click the <strong>Create Custom Field<\/strong> button in the dropdown. If you wish to skip the import of any column, use the option <strong>Don&#8217;t import this column<\/strong> in the dropdown menu.<\/p>\n<p>In case you wish to skip the import of multiple columns from your import file, you can skip mapping those fields and mark the <strong>Do not import data in unmapped fields<\/strong> checkbox <em>(highlighted in the screenshot below)<\/em> to skip their import.<\/p>\n<div style=\"padding: 14px 0;\"><\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2436\" title=\"Do not import unmapped fields\" src=\"https:\/\/www.mainbrainer.com\/hc\/wp-content\/uploads\/2021\/11\/crm-do-not-import.png\" alt=\"MainBrainer CRM import contacts, mapping tab. Do not import unmapped fields box\" width=\"640\" height=\"464\"><\/p>\n<div style=\"padding: 20px 0;\"><\/div>\n<p>Subsequently, click <strong>Continue<\/strong> to proceed.<\/p>\n<div style=\"padding: 14px 0;\"><\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2438 size-full\" title=\"CRM import mapping continue button\" src=\"https:\/\/www.mainbrainer.com\/hc\/wp-content\/uploads\/2021\/11\/crm-mapping-continue-button.png\" alt=\"MainBrainer CRM import contacts, mapping tab. The continue button is highlighted\" width=\"476\" height=\"212\"><\/p>\n<div style=\"padding: 20px 0;\"><\/div>\n<p>In case you map the Email address\/mobile number field, you also need to specify the respective opt-in\/opt-out status. In case you don&#8217;t, you will be prompted to do so on the next screen.<\/p>\n<blockquote class=\"elevio-box-success\"><p>By default, the values for the opt-in status fields (i.e., the fields &#8211; SMS Marketing and Email Marketing) need to be passed as:<\/p>\n<ul style=\"list-style-type: circle;\">\n<li><strong>True\/Yes<\/strong> for Contacts who have opted in, and<\/li>\n<li><strong>False\/No<\/strong> for Contacts who have opted out.<\/li>\n<\/ul>\n<\/blockquote>\n<blockquote class=\"elevio-box-info\"><p><strong>Note:<\/strong> We understand that the data you wish to import might contain the opt-in status with different terminology, say <strong>OptIn<\/strong> for Contacts who have opted in and <strong>OptOut<\/strong> for those who have opted out. In such cases, you can <a href=\"\/hc\/en_GB\/crm\/contact-import\/custom-opt-in\/\" target=\"_blank\" rel=\"noopener noreferrer\">edit the field settings of the CRM&#8217;s opt-in status fields in accordance with your data<\/a>.<\/p><\/blockquote>\n<div style=\"padding: 14px 0;\"><\/div>\n<h2>Step 4<\/h2>\n<h2>Specify the Import rules<\/h2>\n<p>On the subsequent <strong>Import Rules<\/strong> screen, you&#8217;ll need to specify the import rules, i.e., the basis on which data you would like to identify and handle duplicates.<\/p>\n<div style=\"padding: 14px 0;\"><\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2441\" title=\"CRM import duplicates\" src=\"https:\/\/www.mainbrainer.com\/hc\/wp-content\/uploads\/2021\/11\/duplicates-crm-import.png\" alt=\"MainBrainer CRM import contacts, import rules tab. Duplicate handling options are highlighted\" width=\"640\" height=\"453\"><\/p>\n<div style=\"padding: 20px 0;\"><\/div>\n<ul style=\"list-style-type: circle;\">\n<li>\n<h4>Use my uploaded file as the master data<\/h4>\n<\/li>\n<\/ul>\n<p style=\"margin-left: 20px;\">Check the box highlighted in the following screenshot if you want to treat the file being imported as the master data. If you do so, any duplicate data in the CRM will be updated as per the imported data.<\/p>\n<div style=\"padding: 14px 0;\"><\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2444\" title=\"Master data rules\" src=\"https:\/\/www.mainbrainer.com\/hc\/wp-content\/uploads\/2021\/11\/master-data-import-rules.png\" alt=\"MainBrainer CRM import contacts, import rules. Use file as the master data \" width=\"650\" height=\"259\"><\/p>\n<div style=\"padding: 20px 0;\"><\/div>\n<ul style=\"list-style-type: circle;\">\n<li>\n<h4>Use my existing data as the master data<\/h4>\n<\/li>\n<\/ul>\n<p style=\"margin-left: 20px;\">Check the following highlighted box if you want to treat the pre-existing data in the CRM as the master data. If you do so, any duplicate data in the import file will not be updated in the CRM. New data fields if any <em>(that is, the fields which previously did not contain any data in the CRM)<\/em> will be added to the CRM.<\/p>\n<div style=\"padding: 14px 0;\"><\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2446\" title=\"CRM import existing data\" src=\"https:\/\/www.mainbrainer.com\/hc\/wp-content\/uploads\/2021\/11\/existing-data-crm-master.png\" alt=\"MainBrainer CRM import contacts, import rules. Use existing data as master data \" width=\"640\" height=\"255\"><\/p>\n<div style=\"padding: 20px 0;\"><\/div>\n<p>Next, you&#8217;ll need to specify the field(s) you wish to use as the primary and secondary keys for the import.<\/p>\n<div style=\"padding: 14px 0;\"><\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2449\" title=\"Unique data field identifier\" src=\"https:\/\/www.mainbrainer.com\/hc\/wp-content\/uploads\/2021\/11\/unique-data-field-identifier.png\" alt=\"MainBrainer CRM import contacts, import rules. Select unique data field identifier\" width=\"640\" height=\"453\"><\/p>\n<div style=\"padding: 20px 0;\"><\/div>\n<p><strong>Primary key<\/strong> &#8211; It is the field that uniquely identifies a record in the CRM. This key will be used to identify if a record is a duplicate at the time of import. It is mandatory to select a primary key for executing an import.<\/p>\n<p><strong>Secondary key<\/strong> &#8211; You can also specify a secondary key for determining duplicate entries. In case you specify a secondary key, it will be used for determining duplicates in case no duplicate matches are found with the primary key.<\/p>\n<p>Click <strong>Continue<\/strong> to proceed.<\/p>\n<div style=\"padding: 14px 0;\"><\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2451 size-full\" title=\"CRM import continue button\" src=\"https:\/\/www.mainbrainer.com\/hc\/wp-content\/uploads\/2021\/11\/import-rules-button.png\" alt=\"MainBrainer CRM import contacts, import rules. The continue button is highlighted\" width=\"538\" height=\"264\"><\/p>\n<div style=\"padding: 24px 0;\"><\/div>\n<h2>Step 5<\/h2>\n<h2>Accept Compliance Conditions<\/h2>\n<p>On the <strong>Compliance<\/strong> screen, you need to confirm that you have read and understood the GDPR and TCPA regulations for sending SMS and Emails to people in the EU and US.<\/p>\n<div style=\"padding: 14px 0;\"><\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2452\" title=\"CRM import compliance\" src=\"https:\/\/www.mainbrainer.com\/hc\/wp-content\/uploads\/2021\/11\/gdpr-consent-mainbrainer-compliance.png\" alt=\"MainBrainer CRM import contacts, compliance tab. GDPR consent section is highlighted\" width=\"640\" height=\"402\"><\/p>\n<div style=\"padding: 24px 0;\"><\/div>\n<h2>Step 6<\/h2>\n<h2>Review Import Settings<\/h2>\n<p>The next screen will summarise all the settings you have chosen for the import. Review the settings and click the <strong>Import<\/strong> button at the bottom of the <strong>Import Summary<\/strong> to execute the import.<\/p>\n<div style=\"padding: 14px 0;\"><\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2454\" title=\"CRM import summary\" src=\"https:\/\/www.mainbrainer.com\/hc\/wp-content\/uploads\/2021\/11\/summary-crm-import-contacts.png\" alt=\"MainBrainer CRM import contacts, summary tab. Upload, preview and mapping overview\" width=\"640\" height=\"498\"><\/p>\n<div style=\"padding: 20px 0;\"><\/div>\n<p>As the import starts, it will be displayed under the <strong>Draft<\/strong> tab <em>(as highlighted in the screenshot below)<\/em>:<\/p>\n<div style=\"padding: 14px 0;\"><\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-2457\" title=\"CRM import draft status\" src=\"https:\/\/www.mainbrainer.com\/hc\/wp-content\/uploads\/2021\/11\/crm-import-draft-status.png\" alt=\"MainBrainer CRM import contacts, import status. Draft tab is highlighted\" width=\"640\" height=\"303\"><\/p>\n<div style=\"padding: 20px 0;\"><\/div>\n<p>Once the import is successfully completed, it will be visible under the <strong>Completed<\/strong> tab. In case the import failed, it would be visible under the <strong>Failed<\/strong> tab along with the reasons behind the failure.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>The various steps involved in the contact import process and how import rules impact the data you import into the MainBrainer CRM.<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"ht-kb-category":[346,319],"ht-kb-tag":[],"class_list":["post-5690","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-contact-import-en_gb","ht_kb_category-popular-searches-en_gb"],"_links":{"self":[{"href":"https:\/\/www.mainbrainer.com\/hc\/en_GB\/wp-json\/wp\/v2\/ht-kb\/5690","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mainbrainer.com\/hc\/en_GB\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.mainbrainer.com\/hc\/en_GB\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mainbrainer.com\/hc\/en_GB\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mainbrainer.com\/hc\/en_GB\/wp-json\/wp\/v2\/comments?post=5690"}],"version-history":[{"count":8,"href":"https:\/\/www.mainbrainer.com\/hc\/en_GB\/wp-json\/wp\/v2\/ht-kb\/5690\/revisions"}],"predecessor-version":[{"id":10600,"href":"https:\/\/www.mainbrainer.com\/hc\/en_GB\/wp-json\/wp\/v2\/ht-kb\/5690\/revisions\/10600"}],"wp:attachment":[{"href":"https:\/\/www.mainbrainer.com\/hc\/en_GB\/wp-json\/wp\/v2\/media?parent=5690"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mainbrainer.com\/hc\/en_GB\/wp-json\/wp\/v2\/ht-kb-category?post=5690"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mainbrainer.com\/hc\/en_GB\/wp-json\/wp\/v2\/ht-kb-tag?post=5690"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}