# How to Import Contacts in Bulk via CSV Sheet?
Published: 2022-07-09
Tags: crm, template messages, D2C for whatsApp, #whatstoolapi, #whatstool, #whatsappapi, whatstool business, whatsapp cloud api, whatstool business api, multiple agents, whatsapp marketing, whatsapp api, whatstool business app, chatbots, crm tools, whatapp action button
Tag URLs: crm (https://blog.whatstool.business/tag/crm), template messages (https://blog.whatstool.business/tag/template-messages), D2C for whatsApp (https://blog.whatstool.business/tag/d2c-for-whatsapp), #whatstoolapi (https://blog.whatstool.business/tag/whatstoolapi), #whatstool (https://blog.whatstool.business/tag/whatstool), #whatsappapi (https://blog.whatstool.business/tag/whatsappapi), whatstool business (https://blog.whatstool.business/tag/whatstool-business), whatsapp cloud api (https://blog.whatstool.business/tag/whatsapp-cloud-api), whatstool business api (https://blog.whatstool.business/tag/whatstool-business-api), multiple agents (https://blog.whatstool.business/tag/multiple-agents), whatsapp marketing (https://blog.whatstool.business/tag/whatsapp-marketing), whatsapp api (https://blog.whatstool.business/tag/whatsapp-api), whatstool business app (https://blog.whatstool.business/tag/whatstool-business-app), chatbots (https://blog.whatstool.business/tag/chatbots), crm tools (https://blog.whatstool.business/tag/crm-tools), whatapp action button (https://blog.whatstool.business/tag/whatapp-action-button)
URL: https://blog.whatstool.business/how-to-import-contacts-in-bulk-via-csv-sheet

![](https://prod.superblogcdn.com/site_cuid_cl42o8cru128221np38sipih76/images/how-to-import-contacts-in-bulk-via-csv-sheet-1659684229997-compressed.png)

## 1\. Click on Go To CRM

![Click on Go To CRM](https://images.tango.us/public/screenshot_decec007-c9f1-44d6-ad5f-fdf3fc2848f1.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.4750&fp-y=0.5165&fp-z=2.1239&w=1200&ar=2880%3A1452)

## 2\. Click on Custom Fields

![Click on Custom Fields](https://images.tango.us/public/screenshot_2625ccb1-3528-4e4a-b1d0-da3223114f08.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.0632&fp-y=0.3413&fp-z=2.7692&w=1200&ar=2880%3A1452)

### 3\. See all the custom fields you have, If Required you can create a new field.

![See all the custom fields you have, If Required you can create a new field.](https://images.tango.us/public/screenshot_1685d1fb-0fd4-4f71-ada0-77086052534f.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.5781&fp-y=0.4580&fp-z=1.2075&w=1200&ar=2880%3A1452)

### 4\. Go to contacts – Google Sheets

### 5\. There is No Fixed Format For Google Sheet

you need to have at least 1 column for an identifier ( like WhatsApp number or email id ),

you can add more columns based on the custom fields you want to import

it is not compulsory to import all custom fields with a contact

![Their is No Fixed Format For Google Sheet](https://images.tango.us/public/screenshot_d13960b0-329a-4b90-830c-017fe2f994a0.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.4905&fp-y=0.5864&fp-z=1.0416&w=1200&ar=2880%3A1452)

### 6\. Example Columns

Here we have made 3 columns,

1) WhatsApp Number – Identifier

2) Alias:- Custom Field

3) Custom fields:- Custom Field

![Example Columns](https://images.tango.us/public/screenshot_1f173482-c21d-49f1-9b68-7029da42a3f4.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.4905&fp-y=0.5864&fp-z=1.0416&w=1200&ar=2880%3A1452)

### 7\. Format Settings for WhatsApp Numbers

WhatsApp numbers need to be entered in this format: –

country code and number

like

919999999999

919944556677

There should be no plus sign, bracket, space or dashes.

Times, While exporting the sheet WhatsApp numbers don't come in the correct format.

To ensure they are precisely in the same format as you entered them

kindly select the full column and set the format as Plain text as shown in the next steps.

![Format Settings for WhatsApp Numbers](https://images.tango.us/public/screenshot_7f873255-24a8-4f80-82b7-a5861b812b87.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.4757&fp-y=0.5761&fp-z=1.0000&w=1200&ar=2880%3A1452)

### 8\. Click on 123

![Click on 123](https://images.tango.us/public/screenshot_f423e8c8-d745-4b2e-8a90-0a8837c9e443.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.3200&fp-y=-1.5090&fp-z=1.0000&w=1200&ar=2880%3A1452)

### 9\. Click on Plain text

![Click on Plain text](https://images.tango.us/public/screenshot_152897e8-da29-4551-b508-2b4493b82d2d.png?fm=png&crop=focalpoint&fit=crop&w=1200&ar=2880%3A1452)

### 10\. Click on File

Once your Sheet is ready with data, you have to download it in CSV Format

![Click on File](https://images.tango.us/public/screenshot_d681650c-cff7-4d0e-bd4d-5626846cae30.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.0715&fp-y=0.0833&fp-z=2.8947&w=1200&ar=2880%3A1452)

### 11\. Click on Comma Separated Values (.csv)

![Click on Comma Separated Values (.csv)](https://images.tango.us/public/screenshot_1ec75fbe-8ec0-4dcd-b640-c709cd410232.png?fm=png&crop=focalpoint&fit=crop&w=1200&ar=2880%3A1452)

### 12\. Go to CRM – Custom Fields \| WhatsApp Business API & Team Inbox

### 13\. Click on Contacts

![Click on Contacts](https://images.tango.us/public/screenshot_9f998529-5357-422b-bd0b-0a44ba56bf89.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.0517&fp-y=0.3068&fp-z=2.9569&w=1200&ar=2880%3A1338)

### 14\. Click on Import Contacts and Select your file

![Click on Import Contacts and Select your file](https://images.tango.us/public/edited_image_8f95178d-6377-41f3-83e9-e7f19f399e1b.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.5000&fp-y=0.5000&fp-z=1.0000&w=1200&ar=2880%3A1338)

### 15\. Map CSV Data

on the left-hand side, you will see column headers from your CSV file and on your right-hand side you will see System Identifiers and Custom Fields.

You have to Click on DO NOT Import and Map each column from your CSV to a Field from the Platform

![Map CSV Data](https://images.tango.us/public/screenshot_4534f545-3096-4b17-85e0-7e50ebf6c207.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.4993&fp-y=0.4880&fp-z=1.6364&w=1200&ar=2880%3A1338)

### 16\. Example Mapping

For WhatsApp Number, You have to Select the option WhatsApp Number

for other Columns, you can select any Custom field or choose not to import any Individual Column!

![Example Mapping](https://images.tango.us/public/screenshot_051114bf-289e-46d2-bf38-0de237526ee6.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.5203&fp-y=0.4861&fp-z=2.2948&w=1200&ar=2880%3A1338)

### 17\. Click on Start Import

![Click on Start Import](https://images.tango.us/public/screenshot_f37c06e5-7a8f-4dab-a3ac-afb01d41c17f.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.6139&fp-y=0.6319&fp-z=2.7961&w=1200&ar=2880%3A1338)

### 18\. Click on OK

![Click on OK](https://images.tango.us/public/screenshot_35c5f1f1-b756-4591-84ab-8ff5515b4e4f.png?fm=png&crop=focalpoint&fit=crop&fp-x=0.4982&fp-y=0.5267&fp-z=1.7155&w=1200&ar=2880%3A1338)

Read Other Blogs -  [view](https://blog-business.whatstool.in/tag/crm/) ​


---
This blog is powered by Superblog. Visit https://superblog.ai to know more.
---