↑↓ selectEnter openEsc close

    1. Elbuz

    How to import contacts from Excel or CSV

    3 min readUpdated

    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

    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.

    Import contacts from file window: file upload, field selection and contact group
    1Column delimiter character
    2Start import from row
    3Select contact group
    1. Column delimiter character — ';' by default; enter ',' for a comma-separated CSV.
    2. Start import from row — 2 means the first row is treated as headers.
    3. Select contact group — the role assigned to all imported contacts.
    1. “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).
    2. “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.
    3. “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, tab or \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:

    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 the program says and what to do about it
    What you seeWhyWhat 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

    Was this article helpful?

    Missing a feature? Tell us.

    We will add it for free if other users need it too.

    If only you need it, we will agree on it separately.

    Article contents

    Suggest an improvement

    Try Elbuz free