About half a day for a small book · Migration

Migrate leads and deals from a spreadsheet or another CRM

You can move leads into CrmLeaf by exporting them to CSV and importing the file. A CSV import creates a lead contact and a deal for each row, so the work is in cleaning the data, setting up your stages and checking the result.

An export from the old tool.Leads and deals in CrmLeaf, checked against the old tool.
1

Export from the old tool

Why it matters: A complete export is the only source the migration can use.
  1. Export the leads, deals and notes you want to keep, as CSV.
  2. Keep the original file untouched.
What you'll see: A CSV export and an untouched copy of the original.
2

Map the old stages to new ones

Why it matters: Stages are set on your pipeline, so the mapping must exist before the import.
  1. Create your pipeline in CrmLeaf first.
  2. Map each old stage to a new stage.
What you'll see: A written map from each old stage to a new stage.
3

Clean the file

Why it matters: Duplicates and bad email addresses are the most common import errors.
  1. Remove duplicates, fix email addresses, and standardise the sources.
What you'll see: A file with one clean row per contact.
4

Note the old stage

Why it matters: Keeping the old stage lets you check each deal against the old tool.
  1. Create a custom field or a note before the import, and keep the old stage in it.
What you'll see: The old stage kept on each row for checking.
5

Import a test batch

Why it matters: A 10-row test shows mapping and owner problems before the full import.
  1. Import 10 rows, and check the lead fields and the owner.
What you'll see: A tested mapping you can use for the full file.
6

Import the rest

Why it matters: Batches are easier to check and to correct than one large file.
  1. Import the full file in batches.
What you'll see: The full file imported in batches.
7

Check the result, then cut over

Why it matters: A sample check against the old tool catches errors before the old system is retired.
  1. Check the leads and deals created by the import, and sample 20 records against the old tool.
  2. Stop using the old system for new deals.
What you'll see: Checked records, and the old system retired for new work.

Your leads and deals are in CrmLeaf

The sample matches the old tool, and the old system is no longer used for new deals. Keep the original file until you are sure.

Import leads from a CSV file

Where this fits in the connected workflow

Sell, Quote, Agree, Onboard, Deliver. This tutorial covers the Sell step: moving an existing book of leads and deals into the pipeline.

Common questions

Can CrmLeaf import from any CRM?

If the old tool can export CSV, you can import it.

Are notes and files imported?

Plan for notes in a column, and move files separately.