> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.textit.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Importing Contacts


## Importing Contacts

Importing contacts allows you to add entire groups of contacts to our platform using a simple XLS (MS Excel) spreadsheet.  

![](https://storage.crisp.chat/users/helpdesk/website/-/7/a/9/f/7a9fc4558a9de000/screenshot-2026-08-05-at-13102_1w0tq75.png)

Note that you must have a channel connected to your account to import contacts. To import contacts, simply import an **XLS spreadsheet** containing:  

* **Address** columns corresponding to the addresses each contact may contain (a **Phone** column containing each contact's phone number in E164 format; and/or a **Telegram** column containing each contact's Telegram identifier; and/or an **Email** column containing each contact's email address). Once imported, our platform will display your contacts' phone numbers without the country code prefix.

* A **Name** column that contains the first and last name of each contact.

* (Conditional) A **UUID** column containing the universally unique identifier for each contact you import. This column may replace the **Name** column, and is necessary when importing a spreadsheet with the intention of adding a new address or address type to your contacts.

* (Optional) A **Language** column representing each contacts' preferred language that contains the [ISO 639-3](https://en.wikipedia.org/wiki/ISO_639-3) standardized nomenclature to classify the languages you're including.

*   (Optional) Any number of additional columns corresponding with custom attributes\* (contact fields) containing contact field values. Note that column names are limited to 36 characters, don't support special characters, and may not start with a number.

**Note** that when importing a date value into the platform without a time value, we will assign the date a time value of 00:00 (12 AM):  

![](https://storage.crisp.chat/users/helpdesk/website/d8c0f8c6cc362800/bde97da4-6b43-4668-808b-3874ab_1m2in7j.png)

Additionally, when manually adding only a date value to a contact field, we will replace the corresponding time value with the time at which you updated the field.

Group membership is determined in the contacts import page and not in your Excel file. Read on to see how it works!

## To Import Contacts

1. Navigate to the contacts tab.

2. Click the "Import" button at the top left of the page.

![](https://storage.crisp.chat/users/helpdesk/website/-/7/a/9/f/7a9fc4558a9de000/screenshot-2026-08-05-at-13113_m5vkg6.png)
  
3. Download and edit the template we provide (or choose a your own file) and upload it using the "Choose File" button.

Be sure that you only use supported fields for your Column Headers in your spreadsheet. For example, if you want to add a registration date, use the Column Header `Field:Registration_Date`. *You must separate spaces with **underscores** only!*

Additionally, please check that your telephone numbers ***include country codes***. We support users globally, so we need to know where your contacts are located.

![](https://storage.crisp.chat/users/helpdesk/website/7a9fc4558a9de000/screenshot-2024-01-31-at-09394_1vs50vy.png)

5. After clicking the "Preview" button, you'll see the option to import headers from your file. In our sample, we have 3 headers: a telephone number, name, and field called `Team`. Additionally, we will choose group membership.

You have the option of creating a new group and giving it a name or adding the contacts to an existing group in your workspace. If you leave the group membership box unchecked, the contacts will not be added to any group.

![](https://storage.crisp.chat/users/helpdesk/website/2d8749c44b135000/fd5eb3b6-13be-4462-902b-0e2dd3_3im008.png)

That's it! After importing, you'll see the number of new contacts created or updated and any group memberships.

![](https://storage.crisp.chat/users/helpdesk/website/51b8bacae6377400/1b52277b-8ac0-4e0d-8990-eb2381_1k9u9do.png)

## Importing Address Types

Contacts can be imported with multiple address types, but only one address for each type:

![](https://storage.crisp.chat/users/helpdesk/website/-/7/a/9/f/7a9fc4558a9de000/screenshot-2026-08-05-at-13132_1ciw36m.png)
Contact addresses can be added via an import, so long as the UUID column contains the UUID(s) of the contact(s). Contact UUIDs can be obtained by exporting your contacts.

## Exporting Contacts

Contact exports will contain your contacts' **UUIDs**, **Names**, **Addresses**, and **Custom Contact Fields**. To export your contacts, simply navigate to the contact tab and select the "Export" option from the ☰ menu icon:  

![](https://storage.crisp.chat/users/helpdesk/website/-/7/a/9/f/7a9fc4558a9de000/screenshot-2026-08-03-at-12365_17e47u8.png)

## Removing Duplicates

Duplicate contacts cannot be imported into TextIt, so you'll first need to find and remove them from your Excel document. Take a look at [this article](https://support.microsoft.com/en-us/office/find-and-remove-duplicates-00e35bea-b46a-4d5d-b28e-66a552dc138d) to see how.