Lead sources & integrations
Import leads from a spreadsheet (CSV)
Bring up to 10,000 existing leads in from Excel or Google Sheets, with owners, statuses and follow-up dates.
Updated 19 Nov 2026
Import brings in leads you already have - from Excel, Google Sheets, another CRM, or leads downloaded from Facebook. One file can hold up to 10,000 rows (10 MB). You need the Import data permission.
Prepare the file
- Put one lead per row, with column headers in the first row - for example Name, Phone, Email, City, Owner, Status.
- Make sure every row has a phone number or an email.
- Save it as CSV. In Excel: File > Save as > CSV UTF-8. In Google Sheets: File > Download > Comma-separated values.
Import step by step
- Go to Leads and click Import.
- Click Choose a CSV file and pick your file.
- Choose the Status when the file has none - used for rows without a status.
- Choose the Source, for example CSV import.
- Under Match columns, choose the CRM field for each column, or Don't import to leave a column out. Columns with clear headers (phone, email, city, owner, status) are matched for you - check them.
- Click Check file. You see how many rows are ready, the first rows as they will be created, and any Things to check. You can still import with these.
- Click Import (the button shows the number of rows). A progress bar follows the import. Close (keeps running) lets you carry on working while it finishes.
At the end you see how many leads were Created, Skipped (duplicates) and Not imported. Click Download report for a row-by-row list of what was skipped or changed, and why.
What a column can fill
- Name, primary and secondary phone, email, gender, city, state and country
- Assigned to - matched to a user by name or email
- Status - matched by name
- Created at and Updated at - the original dates
- Follow-up date - creates a follow-up on the lead
- Meta campaign, ad set, ad and form names
- Any of your custom fields
Dates like 08-10-2026 23:44 are read day-first, in India time.
Good to know
- Duplicates are skipped, never overwritten. A row whose phone or email is already in the CRM - or earlier in the same file - is skipped.
- Assignment rules don't run for imported leads, and nobody is notified. Each lead gets the owner from your file, or waits in Leads > Unassigned.
- The Admin can't own leads, so a row assigned to the Admin is left unassigned.
Common problems
- "Map a column to Primary phone or Email". Match at least one column to one of them.
- "Left unassigned: no user named ...". The owner's name doesn't match a user exactly, or two users share it. Use their email in the file, or transfer the leads afterwards.
- "Status ... not found". The row got your default status. Match the spelling to a status in CRM Configuration > Lead statuses.
- Hindi or other names look garbled. Save the file as CSV UTF-8.
- The Import button is missing. Ask your Admin for the Import data permission.
Was this helpful?
