How to Import Contacts in Bulk via CSV Sheet ?

1. Click on Go To CRM

2. Click on Custom Fields

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

4. Go to contacts – Google Sheets

5. Their is No Fixed Format For Google Sheet

You need to have atleast 1 column for 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.

6. Example Columns

Here we have made 3 columns, 1. WhatsApp Number – Identifier 2. Alias :- Custom Field 3. Custom field s :- Custom Field

7. Format Settings for WhatsApp Numbers

WhatsApp numbers needs to be entered in this format : – country code and number like 919999999999 919944556677 Their should be no plus sign, bracket, space or dashes. Some Times, While exporting the sheet WhatsApp numbers dont come in correct format. To ensure they are exactly in the same format as you entered them kindly select the full column and set the format as Plain text as shown in next steps.

8. Click on 123

9. Click on Plain text

10. Click on File

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

11. Click on Comma Separated Values (.csv)

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

13. Click on Contacts

14. Click on Import Contacts and Select your file

15. Map CSV Data

on the left hand side you will see columns headers from your CSV file and in 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

16. Example Mapping

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

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

17. Click on Start Import

18. Click on OK