Operelio
Lusha ProspectingZoho

How to import Lusha Prospecting into Zoho Leads or Contacts

13 of the 17 columns in a Lusha Prospecting export, mapped into 12 Zoho Leads fields under Zoho's own names.

13 of the 17 columns in a Lusha Prospecting export, mapped into 10 Zoho Contacts fields under Zoho's own names.

Import into Zoho as

Free · 19 KB · Excel 365 or Google Sheets

Free · 19 KB · Excel 365 or Google Sheets

Check your Lusha Prospecting export first

Built on Lusha Prospecting’s export columnsChecked against Zoho’s import rulesUpdated October 3, 2026

One Lusha Prospecting row, through the templatecopied as it ischanged on the way1explained below
  • First name to First NamePriya
  • Last name to Last NameNair
  • Job title to TitleMarketing Manager
  • Work email to Emaillowercasedpriya.nair@lumenlabs.example.com
  • Phone 1, Phone 2 to Phone1first with a value+44 20 7946 0071
  • Company name to CompanyLumen Labs
  • Not in the export to Lead Source2set to LushaLusha
  • Not in the export to Lead Status2set to Not ContactedNot Contacted
  • LinkedIn URL, Seniority, Departments to Description3joined, with labelsLinkedIn: linkedin.com/in/priya-nair-example | Seniority: Manager | Departments: Marketing, Communications
  • City to CityManchester
  • State to StateGreater Manchester
  • Country to CountryUnited Kingdom
Not imported: Phone 1 type, Phone 2 type, Company domain and Company number of employees. The template leaves these out; map any to a custom field in Operelio.
One Lusha Prospecting row, through the templatecopied as it ischanged on the way1explained below
  • First name to First NamePriya
  • Last name to Last NameNair
  • Job title to TitleMarketing Manager
  • Work email to Emaillowercasedpriya.nair@lumenlabs.example.com
  • Phone 1, Phone 2 to Phone1first with a value+44 20 7946 0071
  • Company name to Account NameLumen Labs
  • City to Mailing CityManchester
  • State to Mailing StateGreater Manchester
  • Country to Mailing CountryUnited Kingdom
  • LinkedIn URL, Seniority, Departments to Description2joined, with labelsLinkedIn: linkedin.com/in/priya-nair-example | Seniority: Manager | Departments: Marketing, Communications
Not imported: Phone 1 type, Phone 2 type, Company domain and Company number of employees. The template leaves these out; map any to a custom field in Operelio.

Where Lusha Prospecting and Zoho don’t line up

1

Two phone columns, one phone field

Lusha Prospecting splits numbers across Phone 1 and Phone 2.

The template Phone takes the first of Phone 1 and Phone 2 that has a value.

ExportPhone 1 empty
Phone 2 +44 20 7946 0071
Zoho+44 20 7946 0071
2

No lead source or lead status in the export

Lusha Prospecting's export has no lead source or lead status column.

The template sets Lead Source to Lusha and Lead Status to Not Contacted on every row. Change either, or drop them, before you import if your process differs.

ExportNo column
ZohoLusha · Not Contacted
3

Three columns kept in Description

This template gives LinkedIn URL, Seniority and Departments no Zoho field of their own.

The template writes them into Description, each with its label, and leaves empty ones out.

ExportLinkedIn URL linkedin.com/in/priya-nair-example
Seniority Manager
Departments Marketing, Communications
ZohoLinkedIn: linkedin.com/in/priya-nair-example | Seniority: Manager | Departments: Marketing, Communications
1

Two phone columns, one phone field

Lusha Prospecting splits numbers across Phone 1 and Phone 2.

The template Phone takes the first of Phone 1 and Phone 2 that has a value.

ExportPhone 1 empty
Phone 2 +44 20 7946 0071
Zoho+44 20 7946 0071
2

Three columns kept in Description

This template gives LinkedIn URL, Seniority and Departments no Zoho field of their own.

The template writes them into Description, each with its label, and leaves empty ones out.

ExportLinkedIn URL linkedin.com/in/priya-nair-example
Seniority Manager
Departments Marketing, Communications
ZohoLinkedIn: linkedin.com/in/priya-nair-example | Seniority: Manager | Departments: Marketing, Communications

Check your Lusha Prospecting export before you import it

Looks for the 13 columns this template reads, and what Zoho would skip.

Drop your Lusha Prospecting CSV here

Runs in your browser. Nothing is uploaded, and results are counts only.

Looks for the 13 columns this template reads, and what Zoho would skip.

Drop your Lusha Prospecting CSV here

Runs in your browser. Nothing is uploaded, and results are counts only.

Lusha Prospecting to Zoho in three steps

Step 1Export from Lusha
  1. Run a search in Lusha Prospecting and reveal the contacts with Show details.
  2. Check the revealed contacts you want.
  3. Click the Export icon.
  4. The CSV is saved to your computer, emailed to you and kept in Export history.

A CSV export from Search takes up to 150 contacts at a time.

Revealing an email address uses 1 credit and a phone number 5 credits.

Lusha: Export contacts to a CSV fileLusha: How credits are counted
Step 2Paste into the template
  1. Paste the export at A1 of Paste your export here.
  2. Start here checks all 13 columns were found.
  3. Save Zoho Leads import as a CSV.

Works in Excel for Microsoft 365 and Google Sheets. Excel 2019 and older, Apple Numbers and LibreOffice can't run the formulas this file uses.

Just the 12 headers as a CSV

Step 3Import into Zoho
  1. Open the Leads tab, click the down arrow next to the Create button and choose Import.
  2. Drop in or browse to your CSV, XLS or XLSX file, set the character encoding if needed and click Next.
  3. Choose Add as new, Update existing only or Both, and the field that identifies an existing record.
  4. Map each column to a Zoho CRM field; for a lookup, choose the field that identifies the linked record.
  5. Set the assignment, approval and automation options, accept the anti-spam policy and submit.
Zoho CRM's importer, screen by screen

Operelio, with the same template

Fixes the capitals in names, formats phone numbers, removes duplicate and blank rows, which the Excel file leaves to you. On every plan. Email verification from Starter.

Use this template in Operelio
Step 1Export from Lusha
  1. Run a search in Lusha Prospecting and reveal the contacts with Show details.
  2. Check the revealed contacts you want.
  3. Click the Export icon.
  4. The CSV is saved to your computer, emailed to you and kept in Export history.

A CSV export from Search takes up to 150 contacts at a time.

Revealing an email address uses 1 credit and a phone number 5 credits.

Lusha: Export contacts to a CSV fileLusha: How credits are counted
Step 2Paste into the template
  1. Paste the export at A1 of Paste your export here.
  2. Start here checks all 13 columns were found.
  3. Save Zoho Contacts import as a CSV.

Works in Excel for Microsoft 365 and Google Sheets. Excel 2019 and older, Apple Numbers and LibreOffice can't run the formulas this file uses.

Just the 10 headers as a CSV

Step 3Import into Zoho
  1. Open the Contacts tab, click the down arrow next to the Create button and choose Import.
  2. Drop in or browse to your CSV, XLS or XLSX file, set the character encoding if needed and click Next.
  3. Choose Add as new, Update existing only or Both, and the field that identifies an existing record.
  4. Map each column to a Zoho CRM field; for a lookup, choose the field that identifies the linked record.
  5. Set the assignment, approval and automation options, accept the anti-spam policy and submit.
Zoho CRM's importer, screen by screen

Operelio, with the same template

Fixes the capitals in names, formats phone numbers, standardizes countries, removes duplicate and blank rows, which the Excel file leaves to you. On every plan. Email verification from Starter.

Use this template in Operelio

Questions

Where does Lusha Prospecting's export fill Last Name and Company, which Zoho requires?

Last Name comes from Lusha Prospecting's Last name column; Company comes from Lusha Prospecting's Company name column. The checker above counts the rows with Last Name or Company blank.

Where do LinkedIn URL, Seniority and Departments go?

Into Description on each lead, labeled like "LinkedIn: linkedin.com/in/priya-nair-example | Seniority: Manager | Departments: Marketing, Communications".

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.

Where does Lusha Prospecting's export fill Last Name, which Zoho requires?

Last Name comes from Lusha Prospecting's Last name column. The checker above counts the rows with Last Name blank.

Where do LinkedIn URL, Seniority and Departments go?

Into Description on each contact, labeled like "LinkedIn: linkedin.com/in/priya-nair-example | Seniority: Manager | Departments: Marketing, Communications".

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 Contacts template for that shape.

Duplicates and undoing an import: Zoho CRM import questions.

Try this template free

Upload your Lusha Prospecting export and download a file Zoho can import. No credit card needed.