How to Clean a CSV Before Importing into Zoho CRM

1. Match Zoho's expected header names

Zoho CRM auto-maps columns whose names match its field labels: First Name, Last Name, Email, Phone, Mobile, Company, Title, Mailing Street, Mailing City, Mailing State, Mailing Zip, Mailing Country. Naming your headers exactly this way saves time in the mapping step and avoids manual errors.

Remove columns you won't import and make sure every column has a unique, non-empty header in row 1. Zoho skips unnamed columns silently.

2. Clean and validate email addresses

The Email field is how Zoho identifies a contact for duplicate detection. Zoho CRM checks the Email field when 'Check duplicates' is selected during import and will skip or overwrite rows depending on your setting.

• Trim leading and trailing spaces from every address.
• Lowercase all addresses — Zoho's duplicate check is case-insensitive, but mixed case can confuse downstream automations.
• Remove 'mailto:' prefixes and 'Name <email>' wrappers.
• Delete rows with clearly invalid addresses (missing @, missing domain, double dots).
• Remove duplicate emails within the file — otherwise Zoho imports the last occurrence and silently discards earlier ones.

3. Format phone and mobile numbers

Zoho CRM stores Phone and Mobile as separate fields. It accepts most formats, but phone numbers without a country code are ambiguous once records are shared across regions. Convert every number to E.164 format (+919876543210, +14155552671) before importing so numbers display consistently and are usable for Zoho PhoneBridge integrations.

Remove spaces, dashes and brackets. Numbers that are clearly invalid (fewer than 7 digits, containing letters) should be flagged for manual review rather than imported as-is.

4. Convert dates to Zoho's expected format

Zoho CRM accepts dates in MM/dd/yyyy or yyyy-MM-dd format, depending on your organisation's locale setting in Setup → General → Company Details. Check which format your Zoho instance uses before converting.

Mixed date formats in one column — 25/03/2024 next to 2024-03-26 — will cause some rows to fail silently. Convert every date to a single format that matches your Zoho locale. Resolve ambiguous dates like 03/04/2024 by confirming the source system's date order.

5. Handle Zoho-specific gotchas

• Mandatory fields — Last Name is required for Contacts; Company is required for Leads. Rows missing these will be rejected. Fill them before importing or filter those rows out.
• Picklist values — Fields like Lead Source, Industry, Rating and Lead Status only accept values that match Zoho's configured options. Check your picklist values in Setup → Customization → Modules → Fields and ensure the CSV values match exactly (case-sensitive).
• Record Owner — If your CSV has an Owner column, the values must match email addresses of active Zoho CRM users. Invalid owners cause the entire row to fail.
• Lookup fields — Account Name in Contacts must match an existing Account record unless you're importing Accounts at the same time.
• Maximum file size — Zoho's import wizard accepts files up to 5 MB (about 20,000–30,000 rows). Split larger files.

Pre-import checklist

TheSpreadFix checks all of these in one pass and lets you fix them before downloading the import-ready file.