About 20 minutes · CSV lead import

Import leads from a CSV file into CrmLeaf

A CSV import in CrmLeaf creates a lead contact and a deal for each row. Clean the file first, map the columns, import a test batch, then check a sample before you trust the full file.

A CSV file and a destination pipeline.A lead contact and a deal created from each row.
1

Prepare the file

Why it matters: Clean data imports cleanly. One person or company per row, and one column per field.
  1. Save the file as CSV with a header row.
  2. Split full names into given and family names if you want them separately, and keep one email address per cell.
What you'll see: A CSV file with a header row and one contact per row.
2

Remove duplicates

Why it matters: The same email address twice in the file creates two leads.
  1. Sort by email and company, and delete obvious repeats before import.
What you'll see: A file with each contact listed once.
3

Start the import

Why it matters: The import is set up from the CRM, not from the spreadsheet.
  1. Choose the CSV import and select your file.
What you'll see: Your file loaded into the import screen.
4

Map the columns

Why it matters: A wrong match puts data in the wrong field, which is harder to fix than a blank.
  1. Match each column to a field.
  2. Leave a column unmapped rather than forcing a wrong match.
What you'll see: Each column matched to a field, or left unmapped on purpose.
5

Set the owner and source

Why it matters: Rows without an agent can be hidden from people who work an owned scope.
  1. Assign the owning agent and a consistent source, either in the file or straight after import.
What you'll see: Every imported lead has an owner and a source.
6

Import a test batch

Why it matters: A 10-row test shows mapping problems before they reach the full file.
  1. Run a 10-row file, and check the results.
What you'll see: A tested mapping you can use for the full file.
7

Check the leads, then create deals

Why it matters: Checking a sample catches errors before they spread across the full file.
  1. Open a few imported leads and confirm the fields.
  2. Import the full file, then create deals for the leads you intend to pursue.
A CSV import creates a lead contact and a deal for each row, so review the deals before you work them.
What you'll see: Checked leads with deals for the ones you pursue.

Your leads are in the pipeline

Each row now has a lead contact and a deal, with an owner and a source. Work the deals you intend to pursue.

Set up web-to-lead forms

Where this fits in the connected workflow

Sell, Quote, Agree, Onboard, Deliver. This tutorial covers the Sell step: bringing existing leads into the pipeline from a file.

Common questions

What does the import create?

A CSV import creates a lead contact and a deal for each row. Review the deals before you work them.

How do I avoid duplicates?

De-duplicate the file before you import, because the same email address twice in the file creates two leads. Check a small test batch first.

Can I import leads from another CRM this way?

Yes, if the other CRM can export to CSV. Clean the export first, then follow the steps on this page.