Import contacts from a file
Add or update many contacts at once from a CSV or Excel file, set owners and groups, and undo an import within 7 days.
- Who can use this
- Account owner, Manager, Agent
Add or update many contacts at once from a CSV or Excel file, set owners and groups, and undo an import within 7 days.
Import adds or updates many contacts at once from a CSV or Excel file: you preview the file, choose what each column means, pick options, and import. To download contacts instead, see Export contacts.
Sidebar → Contacts → Import & Export, Import tab. You see this tab if your role has the Contact Import permission. With neither import nor export permission, the page says "Access Denied".
.csv, .xlsx or .xls file with one contact per row and a header row.The import has four steps: Upload, Match columns, Options, Review & import.
Drop your file on Upload your file, or click to choose it. The panel reads it and shows the file name, Rows, Columns, Text encoding and Separator.
For each Column in your file you see Example values. Under Import as, choose Name, Phone (required), Groups, Assigned staff (email), Do not disturb, one of your custom fields, + New custom field…, or Don't import.
Choose how the import behaves (see the list below).
Check the summary of columns and options.
You see "Import started". You can leave the page; the import keeps going.
Options you can set:
| Section | Option | What it does |
|---|---|---|
| Contacts already in your list | Update them / Leave them as they are | Update changes only the columns you chose; Leave adds only new phone numbers. |
| Blank cells clear existing values | Off keeps saved values when a cell is empty; on wipes them. | |
| Phone numbers | Country for numbers without a code | By default, your workspace country. |
| Groups column | Add to these groups / Replace their groups | Plus the character between group names (comma, semicolon or bar). |
| Also add everyone to a group | Existing groups or Or a new group | Called Add these contacts to, and required, if your contacts are limited to your contact groups. |
| Assigned staff | Overwrite existing staff assignments | Off sends only unassigned open chats to the staff member in the file; on moves all open chats to them. |
| Contact owner | Owner for all contacts | None (default), Me or a team member. See "Contact owners" below. |
| Do not disturb | Allow re-subscribing do-not-disturb contacts | See Good to know. |
| Dates | How dates are written in the file | Detect automatically, Day / Month / Year, Month / Day / Year or Year - Month - Day. |
| Next time | Remember this mapping | Files with the same columns are matched the same way for everyone in your workspace. |
Every contact can have an owner: the team member who looks after them.
staff@example.com.Click Stop import to stop after the current batch. Rows already imported stay.
You see Added, Updated, Skipped, Failed and Warnings.
.csv, .xlsx, .xls..xls files: up to 10 MB.name, phone_number, groups, dnd_enabled, custom_<field>).Do it with Copilot
(crm_preview_import, a dry run that writes nothing)
Do it with Copilot
(crm_import_contacts) The import needs your approval. Paste the rows in the chat; split lists over 1,000 rows into several imports.
| What you see | Why | What to do |
|---|---|---|
| "This file is … MB. The limit is 20 MB. Split it into smaller files, or save it as XLSX (usually 3–5 times smaller)." | The file is over the upload limit. | Split the file or save it as .xlsx. |
| "Old Excel (.xls) files can be up to 10 MB. Save it as .xlsx or .csv and try again." | Large .xls file. | Save as .xlsx or .csv. |
| "Only xlsx, xls, and csv files are allowed" | Wrong file type. | Save the file as CSV or Excel. |
| "The file could not be read. Save it as .xlsx or UTF-8 .csv and try again." | Encoding or format problem. | Re-save as .xlsx or UTF-8 CSV. |
| "The file has more than … rows. Split it into smaller files and import them one after another." / "The file has … columns; up to … can be imported." | Too many rows or columns. | Split the file, or remove columns you don't need. |
| "File appears to be empty or has no headers" / "File contains only headers with no data rows" | No header or no data. | Add a header row and at least one contact. |
| "Choose the column that has the phone number. Phone is required." | No column mapped to Phone. | Set one column to Phone (required). |
| "This is already used by another column. Each field can be used once." | Two columns mapped to the same field. | Change one to another field or Don't import. |
| "You do not have permission to create custom fields — map those columns to existing fields or skip them" | You chose + New custom field… without permission. | Map to an existing field or skip. |
| "Choose one of your contact groups (or name a new one) for these contacts" | Your contacts are limited to groups. | Pick one of your groups or type a new group name. |
| "A group with this name belongs to another team — choose another name" | The new group name is taken by another team. | Use another name. |
| Row warning "No enabled team member with this email — owner not set" | The owner email isn't an enabled team member (for example the template's staff@example.com). | Use a team member's email, or leave the cell empty and use Owner for all contacts. |
| "You can only make yourself the owner" / "You can only choose yourself or someone in your team" | You picked an owner you are not allowed to pick. | Pick Me (or a member of your team), or ask a manager to import. |
| "That team member was not found or is disabled" | The chosen owner was removed or disabled. | Pick another team member. |
| Row warning "Group 'X' does not exist and you cannot create groups — not added" | Creating groups during import needs a manager, the Manage Contact Groups permission, or contacts limited to your groups. | Create the group first, use an existing name, or ask a manager. |
| Replies from imported contacts go to one person automatically | Those contacts have an owner. | Change or remove the contact's owner, or reassign the chat. |
| "This import can no longer be undone (only imports that saved contacts, within 7 days)" | Too old, or nothing was saved. | Fix contacts by hand or with a new import. |
| "Your contacts are limited to your contact groups. Use the new import / export." | Quick import is not allowed with a group limit. | Use the four-step import. |