Zoho CRM CSV Import Guide: Format & Field Mapping

Zoho CRM is one of the most popular CRM platforms for small and mid-size businesses. Importing contacts via CSV is the fastest way to bulk-add leads. This guide covers the correct CSV format, field mapping, and import process for Zoho CRM.

Zoho CRM Data Model: Leads vs. Contacts

Like Salesforce, Zoho CRM distinguishes between two types of people records:

• Leads: Unqualified prospects. Best for newly extracted email addresses that haven't been vetted yet.
• Contacts: Qualified people linked to an Account (company). Use these after you've had interaction with the person.

For email extraction workflows, import as Leads first, then convert to Contacts after qualification.

Zoho Lead CSV Template

Example CSV

Last Name,Email,First Name,Company,Website,Lead Source,Description
Doe,jane@acme.com,Jane,Acme Inc,https://acme.com,Web Extract,Found on team page
Smith,bob@startup.io,Bob,Startup.io,https://startup.io,Web Extract,CTO

How to Import: Step by Step

1. In Zoho CRM, go to Leads (or Contacts)
2. Click the three dots menu and select Import
3. Choose Import Leads
4. Upload your CSV file
5. Select the correct file encoding (UTF-8 recommended)
6. Map each CSV column to a Zoho field — Zoho will auto-map matching column names
7. Choose duplicate handling:
   • Overwrite: Update existing records with new data
   • Clone: Create duplicates (not recommended)
   • Skip: Ignore rows that match existing records
8. Select the duplicate check field: Email (recommended)
9. Click Import

Mapping CAPT Export to Zoho

CAPT's CSV export can be imported into Zoho with minimal adjustments. Here's the mapping:

Tip: Zoho requires a Last Name for Leads. If your CSV only has email addresses, add a Last Name column before import. You can use the email local part (the part before @) or the email domain as a placeholder.

Handling Duplicates in Zoho

Zoho's import wizard offers built-in deduplication:

• Check by Email: If a Lead with the same email already exists, Zoho can skip or overwrite. This is the recommended option.
• Check by Email + Last Name: Stricter matching for when you have multiple contacts at the same company.
• Manual dedup: After import, go to Setup > Data Administration > Deduplicate Leads for additional cleanup.

For best results, use CAPT's built-in deduplication before export, then let Zoho handle any remaining overlaps with existing CRM data.

Common Import Errors

• "Mandatory field missing: Last Name": Every Zoho Lead needs a Last Name. Add this column before import if missing.
• "Invalid picklist value": Lead Source must match one of your configured values in Zoho. Check Setup > Modules > Leads > Fields.
• "File exceeds import limit": Zoho free edition limits to 1,000 records per import. Paid editions allow up to 30,000. Split large files if needed.
• "Encoding error": Always save your CSV as UTF-8. Non-UTF-8 files cause garbled characters in names and notes.

Zoho vs. Other CRMs for CSV Import

Conclusion

Importing contacts into Zoho CRM via CSV is straightforward once you get the format right. Use the template above, map your CAPT export fields during import, and let Zoho's built-in deduplication handle overlaps. For a complete workflow, extract emails with CAPT, export to CSV, and import into Zoho in under 10 minutes.