# Import Contacts

If you need to import a single contact or a group of contacts from a different CRM or marketing campaign, you can upload your spreadsheet by selecting this button.

<figure><img src="https://3379043218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhRoDQv6gyGL2CyFV4Oob%2Fuploads%2FBGULZsi8C5EEXP7TClLA%2Fspaces_SpDxRsrRdNpxcuWtIMiA_uploads_git-blob-60fbae6794c8ce7c8d2b399e2f7ea89e4848e1bb_Import.webp?alt=media&#x26;token=b6a0b6c4-67de-466b-975a-52faa1c98576" alt=""><figcaption></figcaption></figure>

## **Importing Contacts**

Your spreadsheet will need to have column headers that match the fields in this CRM.\\

### **Column Values Format**

<figure><img src="https://3379043218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhRoDQv6gyGL2CyFV4Oob%2Fuploads%2FPPsiexgtd0VoNkjMj4CO%2Fspaces_SpDxRsrRdNpxcuWtIMiA_uploads_git-blob-70ea775afdc718b65f85b8c70d9ffc102922fdfc_Import%20-%20Coulmn.png?alt=media&#x26;token=cb37cd5f-b16b-4fc1-8cc1-4f733f31f347" alt=""><figcaption></figcaption></figure>

Depending on the records you are importing, your file could include the following columns:

**Contact Owner**

* To assign an owner to your contacts during the import, include the name of the 'User'
* Acceptable formats:\
  •  FirstName LastName (e.g. Logan Paul or logan paul)\
  •  LastName FirstName (e.g. Paul Logan or paul logan)

> **Note:** Unless the user has both FirstName and Last Name, the system will not recognize it during upload.

#### **Phone Number**

* For the vast majority of cases, as long as you format the phone numbers in E.164 (Ex: +1 1234567890) our system will recognize it as valid, irrespective of the default Country picked at the sub-account level
* Additionally, if you have set the Country to the US, the following would work perfectly fine as well\
  • 123-456-7890\
  • (123) 4567890\
  • 1234567890

#### **Email Address**

* Note: While the default unique identifier is "Email", the system allows you to choose fields other than Email for de-duplication purposes during the Bulk CSV Upload

**Date Picker**

* Acceptable formats:\
  • mm/dd/yyyy (e.g. 10/28/2020) \
  • yyyy/mm/dd (e.g. 2020/10/28)\
  • You can also replace '/' with '-' or '.' and it'll recognize the uploaded fields as a Date field.

#### **Tags**

* Acceptable formats-\
  • Value 1, Value 2, Value 3 ...... (e.g. Blue, Yellow, \*\*\*\* Green or Blue, Yellow, Green or Blue,\
  &#x20;   Yellow, Green)\
  • You can also replace ', ' with '; ' or ' . ' and it'll recognize the uploaded fields as the\
  &#x20;   aforementioned field.

<table><thead><tr><th width="369.3333333333333">Tags (example formats)</th><th></th><th data-hidden></th></tr></thead><tbody><tr><td>lowercase</td><td>ok</td><td></td></tr><tr><td>UPPERCASE</td><td>ok (will be lowercased)</td><td></td></tr><tr><td>ProperCase</td><td>ok (will be lowercased)</td><td></td></tr><tr><td>with a space</td><td>ok</td><td></td></tr><tr><td>With A Space</td><td>ok (will be lowercased)</td><td></td></tr><tr><td>pre-existing tag</td><td>ok (maps successfully)</td><td></td></tr></tbody></table>

## Steps for Importing Contacts

<figure><img src="https://3379043218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhRoDQv6gyGL2CyFV4Oob%2Fuploads%2FQBudblTxu7GcV13MSUd5%2Fspaces_SpDxRsrRdNpxcuWtIMiA_uploads_git-blob-d76a148e5d701ffc55e6b73caf8cf977d5bf3b98_Import%20-%20Steps.webp?alt=media&#x26;token=41617932-8ae8-4e5e-ae82-bc7242b714d3" alt=""><figcaption></figcaption></figure>

There are three (3) steps you take when importing contacts to your CRM; Upload, Map, and Details.

## Upload

<figure><img src="https://3379043218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhRoDQv6gyGL2CyFV4Oob%2Fuploads%2FfGfKKMT4IZ6kAc5AUYsK%2Fspaces_SpDxRsrRdNpxcuWtIMiA_uploads_git-blob-2198df8f0b47f9f96bd1ce13d743debf30a0448f_Import%20-%20Upload11.webp?alt=media&#x26;token=e5d5f267-08b0-4be8-b4a9-e16f9cfd7957" alt=""><figcaption></figcaption></figure>

The first step is uploading the contacts from your device but before you upload the contact, make sure your file is ready to be imported;\
\
All files being imported into the system must:

* Be a .csv file
* Have only one spreadsheet
* Be smaller than 50MB (tip: a typical .csv file with 4 columns and 10,000 records will be \~500kb in size)
* Include a header row in which at least one column header corresponds to a field in the system (i.e the First and last name, Phone number, Email et.c.) for;
* Uploading ONLY New Records in the system
* Choose 'Add New Records' in Step 3 of the Import Flow
* Updating ONLY Existing Records in the system
* Choose 'Update Contact Records' in Step 3 of the Import Flow. Or,
* Both
* Choose 'Both' in Step 3 of the Import Flow

## Map

<figure><img src="https://3379043218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhRoDQv6gyGL2CyFV4Oob%2Fuploads%2FebdKmiT589yHYiQS5K3w%2Fspaces_SpDxRsrRdNpxcuWtIMiA_uploads_git-blob-25ca637d26a16839ee3959311f65ff2f7b5c73ab_Import%20-%20map.webp?alt=media&#x26;token=a14e2243-9b5c-4c01-b1d9-d6729ab3a029" alt=""><figcaption></figcaption></figure>

Here you can match your column from your imported file with the corresponding contact field in the system. You can also preview your matched information in the preview column.

> **NOTE:** If you have an unmatched column(s), you have to tick the "Don't import data in unmatched column" box in other to be able to move to the next step. You won't be able to move to the next step without ticking on it.

<figure><img src="https://3379043218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhRoDQv6gyGL2CyFV4Oob%2Fuploads%2FuZO6GjJCFzGU6L5vEVtN%2Fspaces_SpDxRsrRdNpxcuWtIMiA_uploads_git-blob-eef2e79530f7a4956c8c24e98a47410b24add711_Import%20-%20map2.webp?alt=media&#x26;token=70084747-51b6-48be-acd6-c0dc5265e8c9" alt=""><figcaption></figcaption></figure>

## Details

This is the last step for importing contacts.

### Import Name

<figure><img src="https://3379043218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhRoDQv6gyGL2CyFV4Oob%2Fuploads%2FAGdIfsKn3axIfFKolAU9%2Fspaces_SpDxRsrRdNpxcuWtIMiA_uploads_git-blob-29c61be5d2621d204eb494f6e5da1dd4e6caae2f_Import%20-%20Detail%20-%20import%20name.webp?alt=media&#x26;token=70c16712-3d8e-42b1-9048-464979fc40cf" alt=""><figcaption></figcaption></figure>

You can edit the import name\
\
You can also create a new contact list with your import by ticking this box.

<figure><img src="https://3379043218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhRoDQv6gyGL2CyFV4Oob%2Fuploads%2FjR6KDxI2vey2vXe3wMa4%2Fspaces_SpDxRsrRdNpxcuWtIMiA_uploads_git-blob-fb1de18df14543bb8748eb4e40d586ca392a9451_Import%20-%20Detail%20-%20create%20new%20contact.png?alt=media&#x26;token=e3481715-3a41-4d01-a2d5-c5acbc4e5b75" alt=""><figcaption></figcaption></figure>

### Advance

In the Advanced Settings, you can decide what you want to do with the contact in the .CSV file, you can either;

#### Add New and Update Existing Contact Records

<figure><img src="https://3379043218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhRoDQv6gyGL2CyFV4Oob%2Fuploads%2FWbvlkipncJW6W3d4B7yA%2Fspaces_SpDxRsrRdNpxcuWtIMiA_uploads_git-blob-f7e2368694b2511a4b2d0227bd4833096da40c1f_Import%20-%20Detail%20-%20Add%20new%20and%20existing.webp?alt=media&#x26;token=01cdd626-e87a-4580-80be-905704d6c49f" alt=""><figcaption></figcaption></figure>

Here you can decide to add the new contacts to a new list and also update the existing contact list in your CRM with these new contacts. Or

#### Add New Contact Records

<figure><img src="https://3379043218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhRoDQv6gyGL2CyFV4Oob%2Fuploads%2FjqiWPlRBMM1J6LFkgQeE%2Fspaces_SpDxRsrRdNpxcuWtIMiA_uploads_git-blob-244f5bf49ce4ebfc554dc761edcf125df70afd25_Import%20-%20Detail%20-%20Add%20new.webp?alt=media&#x26;token=bc22cfa4-b777-4b43-9f60-fa7a74c7128a" alt=""><figcaption></figcaption></figure>

You can also add the contacts to a new list only. Or

#### Update Existing Contact Records

<figure><img src="https://3379043218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhRoDQv6gyGL2CyFV4Oob%2Fuploads%2Fgn8eo7Qsqe0SC9w13U1O%2Fspaces_SpDxRsrRdNpxcuWtIMiA_uploads_git-blob-b592315650d49b7685159c0fd7ede411409ec330_Import%20-%20Detail%20-%20mergee%20contact.webp?alt=media&#x26;token=866ae071-c292-4527-966f-b6984d0ab6a0" alt=""><figcaption></figcaption></figure>

You can only merge the new contacts with the existing contacts.

#### Find Existing Contacts Based on (Primary)

<figure><img src="https://3379043218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhRoDQv6gyGL2CyFV4Oob%2Fuploads%2Foi7wSC103vMRLkX4q9ja%2Fspaces_SpDxRsrRdNpxcuWtIMiA_uploads_git-blob-27df87f51f1960ad0253ce65427388290569977a_Import%20-%20Detail%20-%20Find%20existing.webp?alt=media&#x26;token=2a4de988-ed0c-43b1-8990-2492b36ac350" alt=""><figcaption></figcaption></figure>

You can also decide to skip existing contacts based on the phone (Primary) when you merge or update your contact list or don't skip.\
\
You can tick the box to not update empty values for existing records.

<figure><img src="https://3379043218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhRoDQv6gyGL2CyFV4Oob%2Fuploads%2FOmSRwT52ihYLhGtAmE32%2Fspaces_SpDxRsrRdNpxcuWtIMiA_uploads_git-blob-be039938b594786da34b5310bdcc111dd176b19e_Import%20-%20Detail%20-%20Not%20update%20(1).png?alt=media&#x26;token=85420038-d7c9-49e4-a072-8b9def424436" alt=""><figcaption></figcaption></figure>

### Tags

<figure><img src="https://3379043218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhRoDQv6gyGL2CyFV4Oob%2Fuploads%2FFvy3ioP3vwNRVvzRMfHV%2Fspaces_SpDxRsrRdNpxcuWtIMiA_uploads_git-blob-5ad221122e86897dc1e0816b3a49a5fa16cfa11a_Import%20-%20Add%20tag.webp?alt=media&#x26;token=8cd476fb-81bd-4991-a332-097fdbf71d53" alt=""><figcaption></figcaption></figure>

You can add tags to the contacts here by searching for existing tags here or adding new ones.

### Add to workflow

<figure><img src="https://3379043218-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FhRoDQv6gyGL2CyFV4Oob%2Fuploads%2FNDhek0UjtoL5nSvlNTkk%2Fspaces_SpDxRsrRdNpxcuWtIMiA_uploads_git-blob-a56f94a08f8eeab389ef5dd516fd34932e4c9535_Import%20-%20Add%20workflow.webp?alt=media&#x26;token=5752505c-1e9a-479c-b81d-df61b580a528" alt=""><figcaption></figcaption></figure>

You can add these contacts to workflow/campaigns here by toggling on the option and selecting the workflow or campaign you would like to add it to.
