Elbuz adds customers in bulk from an Excel or CSV file: you say which column goes where, and the program skips anyone already in the base, so importing again creates no duplicates.
When you need this:
- You're moving from another CRM or spreadsheet — the whole base goes in with one file, with one role for all records.
- You imported the same file twice — the second time the program skips everyone found by email or your key.
- You're adding trade show contacts — new records are added, existing cards stay as is.
Where to start: the “Add” button in the header of the “Contacts” list → “Import contacts”.
What contact import can do
- Three steps — the file, mapping columns to card fields, one role for all records.
- Any CSV delimiter — semicolon, comma or tab; xlsx needs no setup.
- Finding existing contacts — by email, name or up to three key fields of your choice.
How to import a file in three steps
You import contacts — a customer base from Excel or CSV — not from the list itself but in the “Import contacts” window: the “Add” button in the header of the “Contacts” list opens a menu with two items, and the second is “Import contacts”. The window has three steps.
1
Column delimiter character2
Start import from row3
Select contact group- Column delimiter character — ';' by default; enter ',' for a comma-separated CSV.
- Start import from row — 2 means the first row is treated as headers.
- Select contact group — the role assigned to all imported contacts.
- “Adding file”. Drag the file into the frame or click “Select file”. Formats: xlsx, csv, txt. There are two fields here as well: “Column delimiter character” (default
;) and “Start import from row” (default 2 — the first row is treated as headers). - “Selecting fields”. Click “Add field” to add a row: “Field” is where the value goes in the card, “Column address” is the column number in the file (1, 2, 3…), and the “Match key” switch decides whether existing records are searched by this field. Each card field can be linked to only one column.
- “Importing contacts”. “Select contact group” is the role all imported contacts get (customer by default). Click “Start import”.
At the end the program shows “Contact import complete.” and two numbers: how many records were “imported out of” how many. The second number is the file rows from the start row on, minus repeats within the file by the key field. The first counts new records only: existing ones that were found aren't included.
CSV delimiter and encoding
- Delimiter. If everything lands in one field after import, the file's delimiter differs from the one in “Column delimiter character”. Open the CSV in Notepad and see what separates the values: for a comma, enter
,; for a tab,tabor\t. The program doesn't detect the column delimiter itself. xlsx files don't need this field. - CSV must be UTF-8; the window has no separate encoding field: re-save a Windows-1251 file as “CSV UTF-8” or import xlsx instead.
- Records that already came in wrong — the whole file row in the name — find them with the “New this month” tile, delete them and import the file again: re-importing won't fix them, they'll stay next to the correct ones.
How the program finds existing contacts and whether you get duplicates
Before writing each row, the program looks for a match among existing contacts by the identification key. If it finds one, the row counts as a duplicate and isn't added.
- With no keys marked, existing records are searched by email. If the row has no email — by name.
- With the “Match key” switch, the search uses the marked fields instead of email — up to three, and all of them must match; a fourth and further keys are ignored.
- A record is found — the file row is skipped. The existing card isn't changed or filled in: import only adds new contacts.
- Empty key — the row is skipped. If the key is email, a row with an address without “@” or with a typo is skipped too.
- Repeats within the file by the key field are dropped before anything is written: the first row stays.
So the same file imported a second time creates no duplicates — as long as the rows have the key filled in: email or a marked field. The “imported” counter shows 0 the second time: existing records that were found aren't included in it.
Scenarios
You're moving a customer base from an Excel spreadsheet
What to do. Open “Import contacts” and drag the xlsx into the frame. At the “Selecting fields” step, add a row for each column: the card field and the column number in the file. Mark “Match key” on a field unique to each customer — the phone, for example. At the third step, choose the role and click “Start import”.
What you get. Each file row becomes a card with the chosen role. At the end the program shows how many records were “imported out of” how many; existing ones that were found aren't included in the first number.
What won't happen. Rows with an empty key are skipped. Existing cards aren't changed or filled in with data from the file.
You're moving from another CRM
What to do. Contact support: the support team moves customers, orders, products and stock from another program or site free of charge — it's included in your plan (moving from another program). To do it yourself:
- customers — with an Excel or CSV file, as described in this article;
- orders from an OpenCart 2/3 or Magento site — through the tunnel;
- orders from other systems — through API v2;
- requests, catalog and stock from SalesDrive — with the ready-made integration.
What you get. Customers land as cards in “Contacts”, orders in the “Orders” window.
What won't happen. Correspondence, calls and deal history from the old CRM don't move over with the customer file: the file only fills in card fields.
You imported the same file a second time
What to do. Nothing: check the import summary.
What you get. The “imported” counter shows 0, and no duplicates appear — every row was found among existing contacts by email or by your key.
What won't happen. If the rows have neither email nor a marked key field filled in, the program searches by name — and adds records with a different name again.
What to do when data lands in the wrong place
| What you see | Why | What to do |
|---|---|---|
| After a CSV import, all data is in one field | the file's delimiter differs from the one in “Column delimiter character” (default ;) |
delete the records that came in wrong, enter the file's delimiter — , or tab — and import again (importing from a file) |
FAQ
Will the import update existing cards?
No. A record found by the key is skipped as is. To fix fields in many records, use bulk editing or edit them in the grid (bulk actions).
What role do imported contacts get?
The one chosen in “Select contact group” at the third step; customer by default. The role is the same for all records in the file.
My file is in Windows-1251 — what do I do?
Re-save it as “CSV UTF-8” or import xlsx instead: the window has no separate encoding field (delimiter and encoding).
Why does the “imported” counter show 0?
It only counts new records. If every row was found among existing contacts, there are no new ones (finding existing contacts).
Are product duplicates found the same way?
No, this rule is for contacts only. For products the match field is different — SKU, barcode or the ID from the source (product duplicates).
Where it is and who has access
- Menu
- Directories → Contacts → Contacts → “Add” → “Import contacts”
- Access right
- the “Import contacts” window in “Group permissions”
- Prepare
- an xlsx, csv or txt file; CSV must be in encoding
Related topics
- If you need the big picture of the customer base — Customer base: how contacts work.
- If duplicates appeared after import — How to merge duplicate customers.
- If imported contacts need managers assigned — Bulk change of the responsible person.
- If you're choosing a CRM for your store — what it gives your store.
