# How to Import Contacts in Bulk via CSV Sheet ?

![](/files/meCiCgzM7a9tXcyCsK5r)

### 1. Click on Go To CRM

![](/files/LCBJIOgk9rlyWccbNavJ)

### 2. Click on Custom Fields

![](/files/3ihQF8rj7IpyIssorKbR)

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

![](/files/q0pv1G7lm7mdYOWNbisf)

### [4. Go to contacts – Google Sheets](https://docs.google.com/spreadsheets/u/0/create?usp=sheets_home\&ths=true)

### 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.

![](/files/Tz3Gywhi2O8ZKa7s9vFk)

### 6. Example Columns

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

![](/files/Rtv5X3LjLE70SvRTUxDd)

### 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.

![](/files/kRMf7ucnx5qC95kuOxkY)

### 8. Click on 123

![](/files/9bnCBjNF94ueqmuaUMWv)

### 9. Click on Plain text

![](/files/EDcFy8S0Z3ilPp5nqyBB)

### 10. Click on File

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

![](/files/MSaiVxaa2QC1CIPGqOdK)

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

![](/files/M320FIJBX1CUGot2DfgL)

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

### 13. Click on Contacts

![](/files/CXRIjhclHJ7B3EaB91ea)

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

![](/files/9VJoqQrtt9Xd8vu8KZ03)

### 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

![](/files/Z7pEiFr9FFHN5DenlaIg)

### 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 !

![](/files/48HpwlETDQFcwvPIugL0)

### 17. Click on Start Import

![](/files/ExNXsytSC6XYzHNV6PDD)

### 18. Click on OK

![](/files/3LKVPlzspQ80sfc2Wydf)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.wanode.io/crm-platform/how-to-import-contacts-in-bulk-via-csv-sheet.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.