Import Clients into CRM from Excel: Step-by-Step Guide
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
| Name | Phone | Source | |
|---|---|---|---|
| Ana Souza | +55 11 ••• 1204 | [email protected] | |
| Lucas Oliveira | +55 11 ••• 3377 | info@ipe | Website |
| Beatriz Lima | +55 11 ••• 5810 | [email protected] | |
| Ana Souza | +55 11 ••• 1204 | [email protected] | Website |
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
- Open “Contacts,” “Companies” or “Products” and click “Import” in the list header, next to “Export.” Choose the file and click “Next.”
- 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.”
- 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
| Section | Required field | Duplicates matched by |
|---|---|---|
| Contacts | Full name | email, then phone, then full name |
| Companies | Name | tax ID, then name |
| Products | Name | SKU, then name |
| Custom entities | Name | name |
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: “+1 415 555 0134” and “14155550134” 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
- Export the empty “Contacts” section — you'll get the headers.
- Bring your database into one sheet: one row per client, phone numbers as text.
- Import 20–30 rows first and see how the cards look.
- 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?
How many clients can I import at once?
What happens if a client is already in the CRM?
Can I import deals and history from another CRM?
Who on the team can import?
Move your client base over in one evening
14 days free on the “Standard” plan. No card required.