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.
Prepare the file
- Save the file as CSV with a header row.
- Split full names into given and family names if you want them separately, and keep one email address per cell.
Remove duplicates
- Sort by email and company, and delete obvious repeats before import.
Start the import
- Choose the CSV import and select your file.
Map the columns
- Match each column to a field.
- Leave a column unmapped rather than forcing a wrong match.
Set the owner and source
- Assign the owning agent and a consistent source, either in the file or straight after import.
Import a test batch
- Run a 10-row file, and check the results.
Check the leads, then create deals
- Open a few imported leads and confirm the fields.
- Import the full file, then create deals for the leads you intend to 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 formsWhere 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.












