Zoho CRM import checker

Find what Zoho CRM skips before you import the file.

Free for 10 runs a day.

The Zoho CRM import check on a contact file: row 2 Phone fixed in file, row 3 Email check, row 4 Email duplicate.

Rows Zoho skips

A contact without a last name never imports. Ten blank rows in a row end the file. Everything below them is lost.

This checker finds both and leaves the blank rows out of the fixed file.

Start from the fields Zoho maps

An owner name in place of an email assigns the record to you. Checkboxes take true or false. Multi-select values need a semicolon.

The Zoho CRM templates use its standard field names.

The Zoho CRM import template

Zoho CRM leads template

15 columns, in the order the template downloads.

Column	What goes in it	Required
First Name	Text
Last Name	Text	Yes
Company	Text	Yes
Title	Text
Email	An email address
Phone	Plus sign, country code and number
Mobile	Plus sign, country code and number
Website	A web address
Street	Text
City	Text
State	Text
Zip Code	Text
Country	Text
Email Opt Out	Yes or no
Lead Owner	The user’s email

Zoho CRM contacts template

15 columns, in the order the template downloads.

Column	What goes in it	Required
First Name	Text
Last Name	Text	Yes
Account Name	Text
Email	An email address
Title	Text
Department	Text
Phone	Plus sign, country code and number
Mailing Street	Text
Mailing City	Text
Mailing State	Text
Mailing Zip	Text
Mailing Country	Text
Date of Birth	A date, year-month-day
Email Opt Out	Yes or no
Contact Owner	The user’s email

Zoho CRM accounts template

12 columns, in the order the template downloads.

Column	What goes in it	Required
Account Name	Text	Yes
Website	A web address
Phone	Plus sign, country code and number
Industry	Text
Employees	A number, no currency signs
Annual Revenue	A number, no currency signs
Billing Street	Text
Billing City	Text
Billing State	Text
Billing Code	Text
Billing Country	Text
Account Owner	The user’s email

Use it from a script or an AI agent

Use in Claude

MCP  https://dedupe.ly/tools/mcp   every free tool in one connector (this one: check_crm_import)

POST https://dedupe.ly/tools/api/import-checker
{ "crm": "zoho", "csv": "..." }

Docs https://dedupe.ly/tools/api/openapi.json

OpenAPI document · API index · llms.txt

Questions about Zoho CRM imports

How many rows can Zoho CRM import?

It depends on the edition: Free 1,000 rows, Standard 20,000, Professional 50,000, Enterprise 100,000 and Ultimate 200,000. Files go up to 25 MB and 500 columns.

Why did Zoho stop importing halfway?

Zoho reads more than 10 blank rows in a row as the end of the file.

What does Zoho require in each row?

A last name for leads and contacts and an account name for accounts. Your admin can make more fields mandatory.

How does Zoho handle duplicates on import?

You pick a unique field such as Email. Rows matching a record already in Zoho are skipped, and the match ignores letter case.

Why are imported records assigned to me?

Zoho matches owners by email or user ID. A name in the owner column assigns the record to whoever runs the import.