Try for freeTry free
Getting started

Import Clients into CRM from Excel: Step-by-Step Guide

Ivan Kancyr7 min read

Almost every client base starts as a spreadsheet: Excel, Google Sheets or an export from an old program. Moving it into a CRM by hand takes a week and leaves dozens of typos. In emyCRM, you can upload the spreadsheet in a few minutes: the CRM maps the columns to fields on its own, finds duplicates and shows you the result before anything is saved.

Contents
  1. Prepare the file
  2. Import in three steps
  3. What you can import
  4. Companies with their contact persons
  5. Duplicates and errors
  6. Who can import
  7. Where to start
clients.xlsx
NamePhoneE-mailSource
Olena Koval+380 67 ••• 1204[email protected]Instagram
Andrii Shevchuk+380 67 ••• 3377info@karpatyWebsite
Iryna Bondar+380 67 ••• 5810[email protected]Instagram
Olena Koval+380 67 ••• 1204[email protected]Website
An example. Nothing is written to the CRM until you press “Import” — the preview shows what will happen.

Prepare the file

  • Format: Excel (.xlsx) or CSV. The old .xls format can't be read: open the file in Excel and save it as .xlsx.
  • Headers go in the first row, one table per file. Only the first sheet of the workbook is read.
  • Size: up to 5,000 rows and 5 MB at a time. Split a larger database into several files.
  • Phone numbers and tax IDs should be a text column: in a number column, Excel strips the “+” and leading zeros. It's best to store numbers with the country code.
  • Several numbers or emails can stay in one cell, separated by commas — on the card they become separate lines.
  • Full names split into “First name” and “Last name” columns don't need to be merged in advance — the CRM does it for you.

There's no ready-made template, and you don't need one: the easiest way is to export the section you need and take the headers from that file. It's best to save CSV as UTF-8 (in Excel, choose “CSV UTF-8”); the CRM detects the delimiter on its own.

Import in three steps

  1. Open “Contacts,” “Companies” or “Products” and click “Import” in the list header, next to “Export.” Choose the file and click “Next.”
  2. Check the mapping: the table shows the “File column,” “Samples” and “CRM field.” Matches by header are already filled in. Adjust them if needed, set extra columns to “— do not import —” and, if you like, send several columns to one field. Choose the owner — by default, it's whoever is uploading — and click “Check file.”
  3. In the preview, look at the “Will create,” “Will skip as duplicates” and “Rows with errors” counters and the first 20 rows with reasons. If everything is right, click “Import.”

The preview and the import run on one and the same calculation: what the check showed is exactly what ends up in the CRM. Each new contact gets a note in its feed saying who created it.

What you can import

SectionRequired fieldDuplicates matched by
ContactsFull nameemail, then phone, then full name
CompaniesNametax ID, then name
ProductsNameSKU, then name
Custom entitiesNamename

Besides the required field, you can import phone numbers, emails and job title, and for companies, the legal name, tax ID, website and address. The CRM recognizes the tax ID by the headers “VAT” or “Tax ID” (and by local names such as CUI and EDRPOU too); if the column is named differently, choose the field manually. Custom card fields are imported too: text, number, date, list, checkbox, URL, email, phone and money amount.

Companies with their contact persons

The company import has a “Contact person” group of fields: full name, phone, email and job title. If the file has these columns, the CRM creates both the company and the person who works there, and a company that repeats across several rows is created once — with several employees. This way, a typical B2B spreadsheet of “company — who's in charge there — phone” moves over in a single pass.

Duplicates and errors

  • Duplicates are skipped, not overwritten: if a client is already in the CRM, their data stays as it was. Repeats within the file itself are caught too.
  • Phone numbers are compared by digits: “+380 67 123-45-67” and “380671234567” are the same number. The check runs across the whole workspace database, even against clients the uploader can't see.
  • An error in one row doesn't stop the file: a row without a name or with an invalid email is flagged with the reason, and the rest are imported.
  • All or nothing: if saving fails halfway, not a single row gets into the CRM — you never end up with a half-imported database.

Who can import

By default, only the administrator can import and export: your client base is the most valuable thing in a CRM. You can give a sales rep this permission in the role settings, in the “Import” and “Export” columns. The administrator sees the log in “Settings → Import & export”: who, when, which file and how it ended. More on permissions in our article on CRM roles and permissions.

Where to start

  1. Export the empty “Contacts” section — you'll get the headers.
  2. Bring your database into one sheet: one row per client, phone numbers as text.
  3. Import 20–30 rows first and see how the cards look.
  4. If everything looks right, import the rest in batches of up to 5,000 rows.

Once your base is in, set up your sales stages — see our article on the sales pipeline in CRM. The whole launch, day by day, is laid out in our article on how to implement a CRM in a week.

Which files can I import into the CRM?
Excel in .xlsx format and CSV. An old .xls file has to be re-saved in Excel as .xlsx. The first sheet is read, with headers in the first row.
How many clients can I import at once?
Up to 5,000 rows and 5 MB per file. Import a large database as several files — the CRM will skip duplicates between them.
What happens if a client is already in the CRM?
The row is skipped as a duplicate, and the card stays as it was. Contacts are matched by email, phone and full name; companies by tax ID and name.
Can I import deals and history from another CRM?
Not on your own: a file can bring in contacts, companies, products and custom entities. Our team will help you move over from another CRM.
Who on the team can import?
By default, only the administrator. A sales rep gets the permission in the role settings, in the “Import” column.

Move your client base over in one evening

14 days free on the “Standard” plan. No card required.

Start for free

Share this article

Ivan Kancyr

Founder of emyCRM. Writes about how small teams sell over the phone and in messengers without losing clients.

← All articles

Try 14 days free

14 days of the Standard plan: up to 30 employees, telephony and AI features. No card needed — try it on your own deals.

  • No card needed, cancel anytime
  • We’ll help you move clients and deals from another CRM or Excel
  • Your data stays after the trial

First steps

  1. Account createda couple of minutes, no card
  2. Connect telephonyyou only need a SIP provider
  3. Connect WhatsApp and Telegramapps in the marketplace
  4. Move clients and dealsfrom Excel or another CRM — we’ll help
  5. Invite your teamroles and access by department
1 of 5