Lusha Prospecting
Zoho Leads8 fieldsHow to import Lusha Prospecting data into Zoho Leads
Lusha ships at least two CSV export shapes. This template handles the Prospecting export, the one with separate First name and Last name columns, Seniority and Departments, and a Phone 1 / Phone 2 structure. It maps the export to Zoho's standard lead fields: names, job title, work email, and company. Lusha runs on a credit-per-reveal model, so any Work email or Phone column can be blank for contacts you have not revealed yet. Phone 1 and Phone 2 are combined into the single Phone field. Lead Source is set to Lusha and Lead Status to Not Contacted on every row. If your export has a single Contact name column instead, use the Lusha User Data template.
Field-by-field mapping
This is the complete column mapping from Lusha Prospecting to Zoho Leads. The left column is the header in your CSV export. The right column is the Zoho Leads field it should map to.
| Lusha Prospecting column | Zoho Leads field | |
|---|---|---|
| First name | First NameFirst_Name | |
| Last name | Last Name*Last_Name | |
| Job title | Title | |
| Work email | Email TransformLowercased and trimmed | |
| Phone 1 → Phone 2 | Phone Zoho Leads have one Phone field. Phone 1 and Phone 2 are combined into Phone, taking the first available number in that order. TransformStandardized to international format (+1, +44, etc.) | |
| Company name | Company* | |
| "Lusha" | Lead SourceLead_Source Set on every row. Change the value, or remove it, in the column mapper if your process records lead source differently. | |
| "Not Contacted" | Lead StatusLead_Status Set on every row. This is Zoho's standard new-lead status. If your org renamed its Lead Status picklist, change the value in the column mapper to match before you run the job. |
Required by Zoho Leads.
Columns we don't use
Your Lusha Prospecting export includes 11 columns this template doesn't map. Each one below explains why, plus the workaround if you want the data in Zoho Leads.
- Seniority
Zoho Leads have no native seniority field. The data is real and useful, Zoho just has no standard place for it.
If you need it. Create a custom picklist field on the Zoho Lead called Seniority, then map it by hand.
- Departments
Zoho Leads have no native department field. Lusha ships several departments per row, comma-separated.
If you need it. Create a custom field on the Zoho Lead called Departments, then map it by hand.
- Phone 2, Phone 1 type, Phone 2 type
Zoho Leads have one Phone field, which this template fills from the first available of Phone 1 and Phone 2. The second number and Lusha's phone-type labels have no native place on the Lead.
If you need it. Add custom phone fields on the Zoho Lead if you want the second number or the type labels kept.
- City, State, Country
Zoho Leads have no native address block. Address fields live on the converted Contact's Mailing fields, not on the Lead itself.
If you need it. Add custom address fields on the Zoho Lead and map them by hand, or convert the lead and put the address on the resulting Contact.
- Company domain, Company number of employees
These are company-level data points. Operelio's exposed Zoho Leads schema is the core lead field set and does not include them.
If you need it. Enrich the lead in Zoho after import, or convert the lead to a Contact and Account and put these values on the Account record.
- LinkedIn URL
Zoho Leads have no native LinkedIn field on the standard layout.
If you need it. Create a custom URL field on the Zoho Lead called LinkedIn, then map this column to it by hand.
Formatting and cleanup
Lusha Prospecting exports rarely match the format Zoho Leads expects. Fix these before you import.
- 1.Lowercases and trims email addresses
- 2.Standardizes phone numbers to international format (+1, +44, etc.)
- 3.Fills the single Phone field with the first available number, checking Phone 1, then Phone 2
- 4.Sets Lead Source to Lusha and Lead Status to Not Contacted on every row
- 5.Trims whitespace and removes blank rows
Or skip the manual work
Operelio runs this cleanup and mapping for you. Upload your Lusha Prospecting export and download a clean, import-ready file for Zoho Leads.
Lusha Prospecting to Zoho Leads FAQ
Which Lusha export does this template expect?
The Prospecting export, which ships separate First name and Last name columns, Seniority and Departments, and a Phone 1 / Phone 2 structure. If your export has a single Contact name column instead, that's the User Data export. Use the Lusha User Data to Zoho Leads template for that shape.
How do I export from Lusha?
In Lusha Prospecting, build your search, save the contacts to a list, then open the list menu and click Export to CSV. Lusha emails you a download link when the file is ready. Upload that CSV to Operelio.
Why are these going to Zoho Leads instead of Contacts?
This template is for users treating Lusha contacts as net-new leads in Zoho. Leads are the right destination for prospects you haven't qualified yet. If you want to import them as Zoho Contacts with an Account link instead, use the Lusha Prospecting to Zoho Contacts template.
Why does the template set Lead Source and Lead Status?
A freshly built Lusha prospect list is a new lead from Lusha, so the template sets Lead Source to Lusha and Lead Status to Not Contacted on every row. Not Contacted is Zoho's standard new-lead status. If your org renamed its picklist, change the value in the column mapper before you run the job.
Zoho requires Last_Name and Company. What if they're blank?
Lusha reliably populates both fields, but the import will reject any row with a blank Last_Name or Company. Spot-check your CSV before upload, or fill blank cells with a placeholder like Unknown and update in Zoho after import.
Will this create duplicate leads in Zoho?
Zoho uses Email as the unique-value field on leads by default, so rows with matching emails update the existing record rather than creating a duplicate. You can change the match field in Setup, Data Administration, Deduplication if your team uses a different convention.
Why are some Work email and Phone columns blank?
Lusha uses a credit-per-reveal model, so contacts you haven't spent credits to reveal ship with blank email or phone columns. Operelio preserves those blanks rather than guessing values.
