# 1. How to import CSV to add Contacts ?

### How to create the CSV file to import the Contacts along with the Labels, Custom Field and assigning the Team member.

1. Please open the Google Sheets [click here](https://docs.google.com/spreadsheets/u/0/)
2. In the First Column enter the number of the customer.
3. In the Second Column enter the name of the customer.
4. In the Third Column you can enter label you want to assign and Custom field and also assigning the Team member

### Follow below guidelines  to import the Labels

Predefined Labels : All labels should be created in advance to ensure the system recognizes them.

Exact Spelling : Ensure the spelling and format of labels match exactly with those in the system to avoid errors.

Comma Separation : If multiple labels apply to a single entry, separate them with a comma.

**Example:**\
1\. If you are using labels like Hot Lead and Cold Lead, these labels must first be created in the 'Labels' section of the system.\
2\. During import, you should include the labels in the 'Lead' field in the following format:\
3\. Hot Lead, Cold Lead

### Follow below guidelines to Import the Status

Predefined Status: Status should be created in advance to ensure the system recognizes them.

Exact Spelling: Ensure the spelling and format of labels match exactly with those in the system to avoid errors.\
\
**Example:**\
If you are setting status "Open" this status must first be created in the "Status" section of the system

### Follow below guidelines for Assigning by importing

Predefined Agent with email id: Agent email should be added in advance to ensure the system recognizes them.

Exact Spelling: Ensure the spelling and format of email match exactly with those in the system to avoid errors.\
\
**Example:**\
If you are setting assignment to "<example@gmail.com>" then this email id must first be created in the "Team" section of the system.

## Steps to Import the contacts through CSV

1. Kindly go to Contacts & CRM&#x20;
2. Click on Import Contacts&#x20;
3. Chose the CSV file
4. Select the contacts column and name column
5. If you've any Labels, custom field data in the CSV file, kindly select the column for that.
6. And, click on Finish Mapping then Import now.

{% hint style="info" %}
Kindly refer below video for better understanding
{% endhint %}

{% embed url="<https://www.loom.com/share/66bcda92eb9e48b6b69ea6306e509c5c?sid=121afef1-76fb-4e80-ace6-623ef5057000>" %}
Importing the Contacts through CSV File
{% endembed %}


---

# 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.whatstool.business/contacts-and-crm/q-and-a-best-practices/1.-how-to-import-csv-to-add-contacts.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.