Import Leads Into a CRM From a Spreadsheet in 10 Minutes
How to import leads into a CRM from a spreadsheet: tidy your columns, save as CSV, upload to our free CRM and start with a ranked Today list.
Most small businesses already have a customer list: a spreadsheet, a phone's contacts, a notebook someone typed up. The reason people never move to a proper tool is the fear of retyping everything. It does not have to be like that. This guide shows how to import leads into a CRM from a spreadsheet in about ten minutes, using our free CRM.
Before you start
You need your leads in a spreadsheet such as Excel, Google Sheets or Numbers, with one lead per row. If your list is in a messy state, do not worry; you only need a few tidy columns.
Step 1: Add a header row
The first row must be headings. The CRM understands these names, in any capital letters:
- Company (required). It can also be called Name, Lead name or Business.
- Contact, Contact name or Contact person.
- Email.
- Phone, Mobile or Tel.
- Website.
- Location or City.
- Industry.
- Notes.
- Value: a one-off deal value.
- Monthly value: a recurring value.
Columns it does not recognise are ignored, so you can leave extra columns in place. Only the company name is required for a row to be added.
Step 2: Clean the obvious things
Spend two minutes on these, and the import will be smoother:
- Remove blank rows and any total rows at the bottom.
- Put one email address in the Email column, not two.
- Write money as plain numbers, such as 30000. Symbols and commas are tolerated, but plain is safest.
- Keep notes short; very long notes are trimmed.
Step 3: Save as CSV
In your spreadsheet choose File, then Download or Save As, and pick CSV. This is a plain text version of your table, and it opens everywhere.
Step 4: Upload it
- Sign in with your email. There is no password: we email you a short code.
- Open the CRM and go to Settings.
- Under "Bring in your leads", choose your CSV file.
The CRM adds up to 200 rows at a time. If you have more, split the file and upload it again. The result message tells you how many leads were added and how many were skipped, for example because the company name was empty.
Step 5: Open Today
Every imported lead is set to be due now, so your first Today list is full. That is by design: you see everyone to contact, ranked, with the people who have a deal value near the top. From there, work through them and log what happens. The CRM moves each lead's stage and schedules the next follow-up automatically, so you never need to tidy the list by hand.
If something does not import
- "Add a column called Company." The header row is missing or named differently. Rename the column and try again.
- Some rows skipped. Those rows had no company name, or an email that does not look like an email. Fix them and upload again; leads already added will not be removed.
- File too big. The upload limit is a few hundred kilobytes per file, which is plenty for a few hundred leads. Split larger lists.
- Strange characters. Save the CSV with UTF-8 encoding, which most spreadsheets offer.
After the import
Spend a few minutes on your first Today list. Open the leads with a deal value and give each one a follow-up date that makes sense. For leads you have not spoken to in months, log a quick note so the history starts clean. Over a week or two the list sorts itself out: the CRM keeps the live leads near the top and sends the cold ones to a keep-or-close decision.
The free limits
A free workspace holds up to 500 leads and 5,000 logged items such as calls and emails. If you ever want to leave, one click downloads everything, leads and history, as a spreadsheet.
Your data is private
Each person has their own workspace. Nobody else can see your leads. Do not store sensitive details about people, such as ID numbers, in a CRM, and remember that you are responsible for having the right to hold the contact details you add.
No spreadsheet yet?
Start from scratch. Add a lead in a few seconds with just a company name, or load three sample leads to see how it works. You can delete them after.
Try it
Open the free CRM, upload your list and see your first ranked Today list. Read more about what the CRM does, including how stages and follow-ups move on their own.