How to move from spreadsheets to a CRM in two weeks

We earn a commission if you buy through some links on this page, at no extra cost to you. It never affects the order. How we make money.

Most small businesses start with a spreadsheet of leads and customers, and most eventually need to move from spreadsheets to a CRM. The move does not need to be a big project. With a clear plan, a small team can clean its data, import it, connect email and be working in the new system within two weeks. This guide gives a day-by-day plan, a field-mapping checklist and the habits that stop the CRM becoming another neglected list.

Signs your spreadsheet has reached its limit

Spreadsheets are flexible and free, which is why everyone starts with them. They begin to fail when:

• Several people edit different copies and nobody knows which is current.
• You cannot see the emails and calls behind each row.
• Follow-ups depend on memory, and some are missed.
• Rows are deleted or overwritten by accident.
• You want reports, such as deals by stage or win rate, and building them takes hours.
• A departing employee takes knowledge of their customers with them.

If two or more of these sound familiar, the time saved by a CRM will quickly outweigh the effort of moving. For background, see what a CRM is.

The two-week plan at a glance

• Days 1 to 2: decide what you need and choose a CRM.
• Days 3 to 4: design your pipeline and fields.
• Days 5 to 6: clean the spreadsheet data.
• Day 7: import a test batch, check and fix.
• Day 8: import everything.
• Day 9: connect email, calendars and forms.
• Day 10: train the team.
• Days 11 to 14: run in the CRM only, review daily and fix issues.

Adjust the timing to your size, but keep the order. Cleaning before importing and testing before the full import save the most pain.

Days 1 to 2: choose the CRM

Write a short list of what you need: how many users, which channels leads come from (website, email, WhatsApp, phone), which tools must connect (email, calendar, accounting, email marketing), and your budget. Then shortlist two or three CRMs and try them with a few real deals.

Use our CRM ranking and best CRM for small business page to build the shortlist, and how to choose a CRM for a small team for a scoring sheet. Check what the plan you will need costs, not just the entry plan; see how much a CRM costs. If many customers reach you by chat, read WhatsApp CRM first.

Days 3 to 4: design the pipeline and fields

Before touching your data, decide how the CRM will be organised. Define your pipeline stages and what moves a deal from one to the next; our guide on how to build a sales pipeline covers this in detail.

Then decide which fields you need. Start with the CRM's standard fields (name, email, phone, company, deal value, stage, owner, close date) and add only a few custom fields that you will genuinely use, such as lead source, industry or country. Every extra field is something people must fill in. You can add more later; removing unused fields after people have learned them is harder.

Understanding CRM objects

A spreadsheet usually has one row per customer or deal, mixing everything together. A CRM separates information into linked objects:

• Contacts: individual people.
• Companies or organisations: the businesses they work for.
• Deals: potential sales, linked to a contact and company.
• Activities: calls, emails, meetings and tasks linked to any of the above.

When you import, you may need to split one spreadsheet into separate files for contacts, companies and deals, with a shared value (such as email address or company name) that links them. Check your CRM's import guide for the exact format it expects.

Days 5 to 6: clean the data

Cleaning is the most important step. Importing messy data just moves the mess into a more expensive tool. Work on a copy of the spreadsheet:

• Remove duplicates, matching on email address and phone number.
• Delete dead records: bounced emails, closed companies, leads with no contact in years and no value.
• Split combined columns, such as full name into first and last name if your CRM uses both.
• Standardise formats: phone numbers with country codes, consistent country names, dates in one format.
• Standardise choices: the same spelling for each lead source, industry and stage.
• Fill in owners: every open deal needs a responsible person.

This is also the moment to check consent: keep a note of how people agreed to be contacted, since data protection laws apply to the CRM as much as the spreadsheet.

Mapping spreadsheet columns to CRM fields

Make a simple table with three columns: spreadsheet column, CRM field, and notes. For example:

• "Client name" maps to Contact: first name and last name (split first).
• "Company" maps to Company: name.
• "Status" maps to Deal: stage (translate your old statuses to the new stages).
• "Amount" maps to Deal: value (numbers only, one currency or a currency column).
• "Notes" maps to a note on the contact or deal.
• "Last contacted" may map to a custom date field, or be left out.

Any column with no matching field should either get a custom field or be dropped. Decide deliberately rather than creating a custom field for every old column.

Day 7: import a test batch

Import 20 to 50 records first. Then open several of them in the CRM and check: are names split correctly, are deals linked to the right contacts and companies, do stages and owners look right, do phone numbers and dates display properly, and did notes come across?

Fix problems in the spreadsheet, delete the test records, and repeat until the test batch is clean. Most CRMs let you undo or bulk-delete an import, but check how before you start.

Day 8: import everything

Import in this order, so links work: companies, then contacts, then deals. Keep the original spreadsheet as a read-only archive in case you need to check something later.

After the import, spot-check a sample of records and look at your pipeline board. Does the total pipeline value look roughly right? Are the number of deals in each stage sensible? If something is badly off, it is easier to fix now than after the team has started editing records.

Day 9: connect email, calendar and forms

Connecting email and calendars is what turns a CRM from a list into a working tool. Once connected, emails with contacts are logged automatically, and meetings appear on contact records. Set up:

• Email sync for each user, and decide whether personal emails are excluded.
• Calendar sync, and a booking link from a scheduling tool if your CRM does not include one.
• Website forms that create leads directly in the CRM.
• WhatsApp or chat integration if customers contact you that way.
• Your email marketing tool, so subscribers and customers stay in sync.

Day 10: train the team

Keep training short and practical, around an hour. Cover only what people need every day: finding a contact, logging a call, creating a deal, moving it through stages, setting a next step and using email templates. Show the dashboard you will use in weekly meetings.

Write a one-page "how we use the CRM" note with the rules you agreed: every lead gets an owner within a set time, every open deal has a next step and date, lost deals get a reason. Pin it where everyone can find it.

Days 11 to 14: switch off the spreadsheet

From day 11, work only in the CRM. This is the step teams most often skip, and it is the reason many CRM projects fail: if the spreadsheet stays in use, people keep updating it instead and the CRM goes stale.

Make the spreadsheet read-only. Hold a ten-minute check-in each day for the first week to answer questions and fix small problems, such as a missing field or a confusing stage name. At the end of the second week, run your first pipeline review from the CRM.

Getting people to keep using it

Adoption comes from making the CRM useful to the people who update it, not only to managers. Templates, reminders, automatic email logging and a mobile app save salespeople time. Show them those features first.

Then make the CRM the single source of truth: leads are assigned in the CRM, pipeline reviews use the CRM, and commission or targets are calculated from CRM data. When the CRM is where decisions are made, people keep it up to date. Lead management habits help too.

Simple automations to add after a month

Once the basics are routine, add a few automations that remove repetitive work:

• Assign new web leads to the right person by region or product.
• Create a follow-up task when a deal reaches Proposal.
• Send an internal alert when a big deal has no activity for a set number of days.
• Create a project or invoice when a deal is won, through integrations with project management or invoicing software.

Add one at a time and check it works as expected before adding the next.

What it costs to switch

The main costs are the CRM subscription and your team's time, typically a few days spread across two weeks for a small team. Current entry prices for popular CRMs: HubSpot Free, Pipedrive From USD 14 per seat per month, annual, Zoho CRM Free plan, then INR 800 per user per month (India price) (≈ USD 8.29), Freshsales From USD 9 per user per month, annual. Several have free plans, listed on our free CRM page.

Paying a consultant usually only makes sense for complex setups with many custom fields, integrations or large data volumes. For most small teams, following a plan like this one is enough.

Common mistakes when switching

• Importing without cleaning, so duplicates and dead leads clutter the CRM from day one.
• Recreating every spreadsheet column as a custom field.
• Skipping the test import.
• Leaving the spreadsheet in use alongside the CRM.
• Not connecting email, so activity has to be logged by hand.
• Over-automating before people use the basics.
• Forgetting to remove access for people who leave.

Protecting your data

Your customer list is one of your most valuable assets. Give each person their own login, turn on two-factor authentication, limit who can export data, and review permissions when roles change. Check how to export your data from the CRM, so you are never locked in, and keep a periodic export as part of your backup routine.

A sample field plan for a small agency

To make the mapping concrete, here is a lean field plan a five-person marketing agency might use after moving from a spreadsheet:

• Contact fields: first name, last name, email, phone with country code, job title, lead source, marketing consent (yes or no, with date).
• Company fields: name, website, country, industry, size band.
• Deal fields: name, value, currency, stage, owner, expected close date, service type (a drop-down with four options), lost reason.

That is all. Their old spreadsheet had over 30 columns, many half-empty: "met at", "notes 2", "status old", "follow up?" and so on. Most were replaced by standard CRM features, such as activities and tasks, or dropped because nobody used them. The handful of useful notes were imported as notes on the contact record.

The result is a CRM where every field is filled in for most records, which makes reports reliable from the first week.

Handling deals in progress during the switch

Open deals need the most care, because they affect revenue this month. Before the import, ask each salesperson to update their open deals in the spreadsheet: current stage under the new stage names, value, next step and date. Import those deals with their next step as a task, so nothing due during the switch is forgotten.

For deals in late stages, add a short note summarising the history, such as what was proposed and what the buyer asked, since older email threads may not be linked automatically. Once email sync is on, new messages will be logged from that point forward.

Questions