How to move your sales pipeline from a spreadsheet to a CRM

A shared spreadsheet is a sensible way to start tracking sales. It is free, everyone knows how to use it, and it bends to whatever you need. The trouble starts when the team grows: two people edit the same row, nobody knows which copy is current, and follow-ups live in someone's head instead of the file.

Moving to a CRM doesn't have to be a big project. Here is a practical way to do it in an afternoon.

1. Decide what you are moving

Most sales spreadsheets mix several kinds of information on one row. Before importing, split them in your head (or in separate sheets):

• Companies – the organisations you sell to.
• Contacts – the people at those companies.
• Opportunities (deals) – something you hope to sell, with a value, a stage and an expected close date.
• Activities – calls, emails and meetings that already happened.

If a company appears on many rows, that's fine: a good importer will match it rather than create duplicates.

2. Clean the data you actually need

You don't need to fix everything. Focus on the columns that drive decisions:

• One stage per deal, using a short list (for example Lead, Qualified, Proposal, Negotiation, Won, Lost).
• A value for each open deal.
• An expected close date for each open deal.
• An owner for each deal.
• A next action and date – if your sheet doesn't have one, add the column now. It is the habit that keeps deals moving.

Remove obvious duplicates (same person, same email) and fix dates written in mixed formats.

3. Map columns, then preview before anything is saved

A careful import has two steps: map your columns to the CRM's fields, then review a preview showing which rows will be created, updated or rejected and why. Never import blind. In Zyrft, the preview shows new, updated, unchanged, invalid and conflicting rows, and nothing is saved until you confirm. Imports never delete existing records, so you can safely run the same file twice.

4. Import in a sensible order

Import reference data first so later files can link to it: products, then companies, then contacts, then opportunities, then activities. Keep your original spreadsheet unchanged as a backup.

5. Check the result with three questions

• Does the number of open deals match your sheet?
• Does the total open pipeline value match?
• Does every open deal have an owner and an expected close date?

If not, fix the source data and re-import; matching rows will update instead of duplicating.

6. Switch the team over on a fixed day

Pick a Monday, tell everyone the spreadsheet becomes read-only, and run that week's pipeline meeting from the CRM. The first week is when habits form: every deal gets a next action and a date, and everyone starts the day from the follow-up list.

Try it with practice data first

If you'd like to rehearse, Zyrft offers a fictional demo dataset you can import into a test workspace. Getting Started guide · Import help · Start free