You don't need to type in clients from an old spreadsheet or another CRM by hand. Upload an Excel or CSV file and the CRM matches the columns itself, filters out duplicates by phone and shows errors before the import. The reverse operation, exporting the client base to Excel, is available to roles with a separate permission.
Where the import is
- Open Settings.
- Go to the Data transfer tab.
- Find the Clients from a file block. It has two buttons: Download a sample and Import.
The Settings section is open to roles with the Changes settings permission. By default these are Owner and Administrator.
Which file works
| Requirement | Value |
|---|---|
| Format | Excel (.xlsx, .xls) or CSV (.csv, .txt) |
| Size | up to 10 MB |
| Rows | up to 5000 data rows in one file |
| First row | column names |
| Required data | a name and a phone in every row |
- Your own spreadsheet works, and so do contact exports from amoCRM and Bitrix24 in Russian and English, including the Bitrix24 “Excel” file.
- The CRM detects the CSV encoding itself: UTF-8, UTF-16 and Windows-1251. The delimiter too: semicolon, comma or tab.
- In an Excel file the first filled sheet is read.
- A phone saved in Excel as a number is not damaged.
To avoid guessing with columns, click Download a sample. The file has the same columns the import expects and two sample rows.
Importing step by step
Step 1 of 3: file
- Click Import. The Import clients window opens.
- Click the Choose a file or drop it here area and pick a file. You can also drag the file into this area with the mouse.
- The CRM shows the file name and how many data rows it has.
- Click Next.
If the file can't be read, the window shows the reason:
| Message | What to do |
|---|---|
| “This file can't be used” | save the file as Excel or CSV. |
| “The file is larger than 10 MB” | split the file into several. |
| “The file has more than 5000 rows” | split the file into several. |
| “There is no data below the row with column names” | check that the data starts in the second row. |
| “Couldn't read the file” | open the file in Excel, save it as CSV and upload it again. |
| “Part of the page needed to read Excel didn't load” | refresh the page and choose the file again, or save the file as CSV. |
Step 2 of 3: columns
The CRM matches columns by their names. For each field you see the selected column and, in grey, a sample value from the file.
| CRM field | Which columns are recognised |
|---|---|
| Name (required) | Full name, Contact name, Name, Client, Contact, and the same in Russian (“Полное имя”, “ФИО”, “Имя”, “Клиент”, “Название”) |
| Last name | Last name, Surname, “Фамилия”. If a full-name column is chosen for the name, the last name is not added a second time. |
| Phone (required) | Mobile phone, Phone, Work phone, WhatsApp, Mobile, and the Russian equivalents. Mobile is preferred over work: clients are messaged on WhatsApp. |
| Email, Work email, “Почта” and similar | |
| Source | Source, Channel, “Источник”, “Канал” |
| Responsible | Responsible, Responsible user, Manager, Owner, “Ответственный”, “Менеджер” |
| Comment | Comment, Comments, Note, Notes, Description, “Комментарий”, “Примечание” |
- Check every field. If a column is wrong, pick another one in the list.
- If a field doesn't need to be imported, choose Don't import.
- One column can't go into two fields: a column already chosen for another field is unavailable in the list.
- Once the name and phone are chosen, click Next. Without them the button is inactive and the hint “Choose the columns with the name and the phone” is shown.
Phone and email may have several columns, for example Mobile and Work. Then the line “If empty, taken from: …” appears under the field: if the main column is empty, the CRM takes the value from the spare one. Several numbers in one cell separated by a comma, semicolon, slash or a new line are also recognised.
Step 3 of 3: review
Before the import, the CRM shows three numbers:
| Number | Meaning |
|---|---|
| New clients | will be imported |
| Already there | the phone is already in the CRM or repeats in the file. Such rows are not imported. |
| With errors | no name or phone, or the phone has a mistake |
Below you see the first five new clients and the first five errors with the row number as in Excel, for example “Row 14: no phone or it has a mistake”.
- Check the list.
- Click Import clients: N.
If there is nothing to import, the CRM says “Nothing to import: these clients are already in the CRM or their rows have errors”, and the button is inactive.
How the CRM processes the data
- Duplicates by phone. Numbers are brought to one format, so
+7 700 111 22 33and8 700 111 22 33count as the same number. A number without a country code gets the country code of your company. - Email is imported only if the value looks like an email address.
- Source is recognised from the text: WhatsApp, Instagram, Telegram, call. Everything else (ads, a web form, a website) becomes the Website source.
- Responsible is matched against the employees in the settings. If the file has an unknown name or the column is empty, the client is assigned to the CRM owner. Deactivated employees do not become owners.
- Where to find imported clients. They land in the Clients section without a deal: at the top of the list and in the No deal segment. Create a deal for a client with the Create deal button in their card.
How to undo an import
After the import, the notification “Clients imported: N” appears with an Undo button. The notification is visible for 10 seconds. Undo removes the imported clients, except those you have already edited or created a deal for.
Exporting clients to Excel
- Open the Clients section.
- If you like, narrow down the clients: with a segment tile, the search or an owner. Exactly what is in the list right now is exported.
- Click Export in the top right.
- The browser downloads the file
clients-YYYY-MM-DD.xlsx, and the CRM shows “Clients exported: N”.
File columns (the column names follow the interface language):
| Column | What it contains |
|---|---|
| Name | the client's name |
| Phone | the client's number |
| email, if any | |
| Source | WhatsApp, Instagram, Telegram, Call or Website |
| Owner | the employee |
| Deals | how many deals the client has |
| Comment | the comment from the card |
Frequently asked questions
Can I import clients together with deals?
The file import creates clients without deals. Create a deal from the client card with the Create deal button. Pipelines, deals and history are transferred from Bitrix24 on the same Data transfer tab.
The file has more than 5000 contacts. What should I do?
Split the file into parts of up to 5000 rows and 10 MB and import them one by one. Phones that are already imported won't get into the CRM a second time.
Why did some rows end up in Already there?
The phone from that row already belongs to a client in the CRM or appears earlier in the file.
Can I export only one manager's clients?
Yes. Choose the manager in the filter above the list and click Export.
The numbers in my file have no country code. Is that a problem?
No. The CRM adds your company's country code to such numbers.
