{"id":15034,"date":"2022-03-11T11:35:56","date_gmt":"2022-03-11T16:35:56","guid":{"rendered":"https:\/\/www.centrix.one\/?post_type=docs&#038;p=15034"},"modified":"2024-06-04T16:54:14","modified_gmt":"2024-06-04T20:54:14","password":"","slug":"import-contacts","status":"publish","type":"docs","link":"https:\/\/www.centrix.one\/en\/faq\/data-import\/import-contacts\/","title":{"rendered":"How do I import contacts?"},"content":{"rendered":"\n<div class=\"wp-block-group faq-frame\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading has-medium-font-size\" id=\"h-introduction\"><strong>Introduction<\/strong><\/h2>\n\n\n\n<p>In most cases, you&#8217;ll need to import contacts into your CentrixOne account. These contacts may come from different sources, such as your email inbox, cell phone, old CRM, accounting system or other software.<\/p>\n\n\n\n<p>Note that if you decide to sync your Acomba or QuickBooks software with CentrixOne, your contacts will automatically be visible in the CRM.<\/p>\n\n\n\n<p>Before importing, you must consolidate your contact lists into a single Excel file and standardize your data format. Take this opportunity to clean up your contacts and import an up-to-date database!<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group faq-frame faq\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading has-medium-font-size\" id=\"h-step-1-prepare-the-excel-file\"><strong>Step # 1: Prepare the Excel file<\/strong><\/h2>\n\n\n\n<p><a href=\"\/wp-content\/uploads\/crm-centrixone-data-import-template.zip\"><span style=\"text-decoration: underline;\">Click here<\/span><\/a> to download the pre-formatted Excel template for CentrixOne CRM. Then, copy and paste your data into the template as plain text (keyboard shortcut &#8220;CTRL + SHIFT + V&#8221; or right mouse button). You&#8217;ll soon understand the purpose of the &#8220;Custom field&#8221; columns in the template.<\/p>\n\n\n\n<p>CentrixOne only allows you to import contacts. However, to import accounts that don&#8217;t have contacts, simply add contact information, such as an email address or telephone number\u2014and you&#8217;re done! Incidentally, since an email campaign can only be sent to contacts, this tip will be very handy.<\/p>\n\n\n\n<p><strong>Check the configuration of your Excel file:<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>The file must be saved in <strong>.xlsx<\/strong> format using Excel or Google Sheets software (The Numbers software from Apple is not compatible)<\/li>\n\n\n\n<li>Ensure there is only one contact per line<\/li>\n\n\n\n<li>For contacts belonging to the same company, all fields relating to the company (name, street address, etc.) must be written exactly the same way (with no added spaces before or after the information) to avoid creating several separate companies<\/li>\n\n\n\n<li>Each piece of information must be separated in a separate column (first name, last name, street address, city, province, etc.)<\/li>\n\n\n\n<li>No line feeds (except for notes), forced line feeds or tabs<\/li>\n\n\n\n<li>IIt is strongly recommended that your data be standardized (e.g.: Montr\u00e9al, Montreal, MTL \/ 514 444-3333, 5144443333, 514-444-3333)<\/li>\n\n\n\n<li>Dates must be in the following format: YYYYMMDD (e.g. 20200709)<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group faq-frame faq\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading has-medium-font-size\" id=\"h-step-2-create-custom-fileds-in-crm\"><strong>Step # 2: Create custom fileds in CRM<\/strong><\/h2>\n\n\n\n<p>By default, CentrixOne CRM lets you import data into a wide range of basic fields. However, you may need to import additional data that is not part of the default fields. To do this, before importing, <a href=\"\/en\/faq\/crm-account-management\/how-do-i-create-a-custom-field-2\/\" target=\"_blank\" rel=\"noreferrer noopener\"><span style=\"text-decoration: underline;\">follow this guide<\/span><\/a> to create your own custom fields in CentrixOne.<\/p>\n\n\n\n<p>Once the fields have been created in CentrixOne, in your Excel file, rename the &#8220;custom field&#8221; columns with the name of your fields and make sure to use the correct formatting:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>For a <strong>Drop-down list<\/strong> field, write the value in exactly the same way as in CRM<\/li>\n\n\n\n<li>For a <strong>Multiple-choice<\/strong> field, to add a single value, write the value exactly the same way as in the CRM, and to write two or more values, separate them with two &#8220;;&#8221; (e.g.: Blue;;Green;;)<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-group faq-frame faq\"><div class=\"wp-block-group__inner-container is-layout-flow wp-block-group-is-layout-flow\">\n<h2 class=\"wp-block-heading has-medium-font-size\" id=\"h-step-3-import-the-data\"><strong>Step # 3: Import the data<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Click on the <strong>Settings<\/strong> module<\/li>\n\n\n\n<li>Click on the <strong>Data import<\/strong> sub-module<\/li>\n\n\n\n<li>Click on <strong>Choose a document<\/strong><\/li>\n\n\n\n<li>Click on <strong>Upload file<\/strong><\/li>\n\n\n\n<li>Select the list where you want to import your data or create a new list<\/li>\n\n\n\n<li>Click on <strong>Next step<\/strong><\/li>\n\n\n\n<li>Check the association of contact fields<\/li>\n\n\n\n<li>Check the association of account fields<\/li>\n\n\n\n<li>Click on <strong>Import data<\/strong><\/li>\n\n\n\n<li>Choose between <strong>Use email<\/strong>* or <strong>Do not use email<\/strong><\/li>\n\n\n\n<li>Once the data import is complete, click on <strong>Ok<\/strong><\/li>\n<\/ol>\n\n\n\n<p><strong>* Important<\/strong><\/p>\n\n\n\n<p>The &#8220;Use email&#8221; option helps you avoid duplicates. However, all your contacts must have a separate email address to use it. You can&#8217;t use this option if a contact has no email address or two contacts have the same email address.<\/p>\n\n\n\n<p>If this option is used and the contact already exists in your CentrixOne account (but is not part of the list into which you import your data), then the system will create a copy of this contact. When you update the information in this copy, it will also be updated in the original contact.<\/p>\n\n\n\n<div><figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe title=\"How to import data | CentrixOne CRM\" width=\"1200\" height=\"675\" src=\"https:\/\/www.youtube.com\/embed\/r3l1MKxF4XE?feature=oembed&#038;enablejsapi=1&#038;origin=https:\/\/team.centrix.one\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Introduction In most cases, you&#8217;ll need to import contacts into your CentrixOne account. These contacts may come from different sources, such as your email inbox, cell phone, old CRM, accounting system or other software. Note that if you decide to sync your Acomba or QuickBooks software with CentrixOne, your contacts will automatically be visible in &#8230; <a title=\"How do I import contacts?\" class=\"read-more\" href=\"https:\/\/www.centrix.one\/en\/faq\/data-import\/import-contacts\/\" aria-label=\"Read more about How do I import contacts?\">Read more<\/a><\/p>\n","protected":false},"author":34,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"doc_category":[944],"doc_tag":[],"class_list":["post-15034","docs","type-docs","status-publish","hentry","doc_category-data-import"],"year_month":"2026-11","word_count":635,"total_views":"463","reactions":{"happy":"0","normal":"0","sad":"0"},"author_info":{"name":"Louis-Philippe Frenette","author_nicename":"lpfrenette","author_url":"https:\/\/www.centrix.one\/en\/author\/lpfrenette\/"},"doc_category_info":[{"term_name":"Data import","term_url":"https:\/\/www.centrix.one\/en\/faq\/data-import\/"}],"doc_tag_info":[],"jetpack_sharing_enabled":true,"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/www.centrix.one\/en\/wp-json\/wp\/v2\/docs\/15034","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.centrix.one\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.centrix.one\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.centrix.one\/en\/wp-json\/wp\/v2\/users\/34"}],"replies":[{"embeddable":true,"href":"https:\/\/www.centrix.one\/en\/wp-json\/wp\/v2\/comments?post=15034"}],"version-history":[{"count":27,"href":"https:\/\/www.centrix.one\/en\/wp-json\/wp\/v2\/docs\/15034\/revisions"}],"predecessor-version":[{"id":40410,"href":"https:\/\/www.centrix.one\/en\/wp-json\/wp\/v2\/docs\/15034\/revisions\/40410"}],"wp:attachment":[{"href":"https:\/\/www.centrix.one\/en\/wp-json\/wp\/v2\/media?parent=15034"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.centrix.one\/en\/wp-json\/wp\/v2\/doc_category?post=15034"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.centrix.one\/en\/wp-json\/wp\/v2\/doc_tag?post=15034"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}