CRM Help

Import Data to Zoho CRM

Importing records from external sources to Zoho CRM is one of the most important lead creation activities for marketing and sales. In Zoho CRM, importing records help you to create new leads by gathering data through various sources, such as purchasing a record database, records from different business units, etc. You can import records with the help of two features:

Import My [Module] - Use this feature to import the records owned by (assigned to) you. By default, the records' ownership is automatically assigned to the user who imports the records.

Import My Organization [Module] - Use this feature to import all the records that are owned by (assigned to) the users in your organization, including the records owned by you. While importing, the import file should have a column that contains the exact email address of the users to whom you want to assign each record.

Note

Zoho CRM is compatible with Internet Explorer 9 and above and Firefox 17 and above. We recommend you use these browsers for best results.

Availability

Profile Permission Required: Users with the Import permissions in profile can access this feature.

Import Checklist

Before importing the data, please go through the following checklist:

  1. Permission
    Make sure you have the access and privilege to Import data. If you do not have the privilege, the Import link will be hidden in your User interface.
  2. File Format
    The files to be imported must be in a CSV (comma separated values) file format. It must be an ASCII file (usually with a .txt or .csv extension in the Windows environment) where each line of text represents a single record. The supported formats are Excel (XLS, XLSX), Comma Separated Value (CSV) and Business Card or vCard Format (VCF). All file attachments should be separated from the data.
    Unexpected errors may occur if the XLS/XLSX files contain any special controls such as combo filters or images embedded in it.
  3. Forbidden Characters
    Any data for the file to be imported should not contain the following characters:
    • Double quotation marks(") - use only as a field delimiter
    • Vertical bar (|)
    • Angle brackets (<>)
  4. Mandatory Fields
    The required (mandatory) fields must contain a value. Make sure you do not leave the mandatory fields blank, in the import file. For instance, when you are importing account information, each account record must include an Account Name. The Field Mapping page in the Import wizard shows the required fields in the * format. Do not proceed to the next step without mapping the mandatory fields.
  5. Check box Data
    Make sure that the data you plan to import from Boolean or check box fields contain values that will properly convert during the import process.
    Imported data from Boolean and check box fields are converted as follows:
    • If check box is selected - True or 1
    • If check box is not selected - False or 0
  6. Drop-down List
    All data values displayed in the drop-down lists must exist in the corresponding Zoho CRM fields.
    For instance, if you plan to import account information that contains a value for the industry type drop-down list, before you import the account information, make sure all the industry values in the source file already appear in the drop-down list. If the values do not exist, you must either change the values in the source file to match the existing values in Zoho CRM, or have your administrator add the new values.
  7. Field Names
    Make sure the first row of data (records) in the source file contains the column headings or field names rather than the actual data values. These heading field name values help identify the data when you map the new data to the existing fields in Zoho CRM.
  8. Blank Lines
    Remove all blank lines from the file to be imported. A blank line is interpreted as the end of the file.
  9. User Name
    When imported records are assigned to other users also, you need to map the Owner field with the appropriate field from the import file. While importing, the import file should have a column that contains the exact email address of the users to whom you want to assign each record. Only then will the records automatically get assigned to the respective users while importing.
  10. File Size
    Make sure the file size (Import data) does not exceed 5MB.

The modules for which you can Import data along with their mandatory fields are mentioned in the table below:

Modules Mandatory Fields Modules Mandatory Fields Modules Mandatory Fields
Leads
  • Company
  • Last Name
Potentials
  • Potential Name
  • Account Name
  • Sales Stage
  • Closing Date
Products
  • Product Name
Accounts
  • Account Name
Cases
  • Case Origin
  • Subject
  • Status
Vendors
  • Vendor Name
Contacts
  • Account Name
  • Last Name
Solutions
  • Solution Title
  • Question
  • Answer
Price Books
  • Price Book Name
Campaigns
  • Campaign Name
       

Note

  • Using the Import feature, you cannot import activities, reports, invoices, quotes, purchase orders, forecasts, sales orders, and templates into Zoho CRM.

Import Limits

If the import file is in XLS, XLSX or VCF format, you can import a maximum of 1500 records/batch. Records more than 1500 can be imported in CSV format. Check the Feature Availability table for Import Limits.

Note

  • The supported formats are Excel (XLS, XLSX), Comma Separated Value (CSV) and Business Card or vCard Format (VCF).
  • If your records exceed the specified limits mentioned above then you can split the records in two or more files and import them.

Import Data

Use the Import My [Records] feature to import the records owned by (assigned to) you. By default, the records' ownership is automatically assigned to the user who imports the records.

Use Import My Organization [Module] feature to import all the records that are owned by (assigned to) the users in your organization, including the records owned by you. While importing, the import file should have a column that contains the exact email address of the users to whom you want to assign each record. Only then will the records automatically get assigned to the respective users while importing.

Note

  • Module refers to the different tabs. For example, Leads, Contacts, Accounts, etc.

To import data

  1. Click the [Module] tab.
    Module refers to the tabs like Leads, Contacts, Accounts, etc.
  2. In the [Module] Home page, click Import [ Module ].
  3. In the Import [Module] page do the following:
    • Choose Import My [Records] or Import My Organization [Records].
    • Browse to locate and select the required file that is to be imported.
    • Select the check box to Enable Manual Lead approval.
      The records will be manually approved by the admin before being assigned to specific users. This option is available only while importing leads. See Also Approve Records
    • Select Skip, Overwrite or Clone for duplicate records. (Refer to the notes below)
      The skip and overwrite option is available only in the Paid Editions.
  4. Under Advanced Options, do the following:
    • Select the Character Encoding from the list.
    • Select a Workflow Task, if required.
      Note, that the work flow task will be available in the list only if you had already created a work flow task.
    • Choose the Date and Time format for the date and time values in the import file.
    • Select an option from the list to Assign all imported Leads to this Lead Source.
      This option is available only while importing leads.
    • Click Next to continue.
  5. In the Map Fieldssection, do the following:
    • Associate the fields in CSV/XLS file column header with the corresponding [Module] fields in Zoho CRM.
      (Mandatory fields should be properly mapped)
    • Click Next to continue.
  6. In the Confirm Mapping section, verify whether all fields are mapped correctly.
  7. Click Import.
    When the process is over, the added, updated and skipped records will be listed for your reference.

Note

  • Once Import process begins, you cannot cancel it and the manual approval option is available only while importing leads.
  • If you select a workflow task while importing, the Notify Assignee option in the selected workflow task, will not be applicable.
  • In the Free Edition, only the Clone option is available.
  • The option to clone, skip and overwrite records is available in the Professional & Enterprise Edition. The skip and overwrite options can be used only if the import file is in CSV format with not more than 5000 records per batch.
  • For instance, there are two records namely, A and B in your Zoho CRM account. You want to import records B and C.
    When you select:
  Record C Record B
Skip Imported Not imported, as it already exists in Zoho CRM.
Overwrite Imported Imported. If the mapped fields' values differ in the existing record, they are replaced with the ones in the import file. Additional new data is added to the record, if the related field is mapped before importing.
Clone Imported Imported and another record B is created along with the existing one.
  • When the Overwrite option is selected, the duplicate records will be identified based on some fields for each type of record. Following are the fields for each type of record:
    • Leads - Email
    • Contact - Email
    • Account - Account Name
    • Potentials - Potential Name
    • Cases - Subject
    • Solutions - Title
    • Campaigns - Campaign Name
    • Vendors - Vendor Name
    • Products - Product Name
  • When the above mentioned fields are not mapped, duplicate records will not be identified, causing duplicates to be created in Zoho CRM.
  • In case of duplicate records, only the fields that are mapped will be overwritten.
  • When you do not use the above mentioned fields and still want to check for duplicate records while importing, then you can use the Record ID. Each record in Zoho CRM has a unique ID. When you export the records, you can get their individual Record IDs. See Also Knowledge Base

View Import History

Maintaining a log of the activities performed in your Zoho CRM account is always useful. You know when a record was edited, or who added a record. Similarly, a log of the import activities is also useful in knowing who imported records, when it was imported and whether the records were properly imported or not. The Import History page in Zoho CRM provides a clear picture of the recently imported files using the Import as well as the Migrate features. You can see the following details under the import history:

  • Imported file name
  • Module's name to which the records are imported
  • The user's name who imported the records
  • Imported date and time
  • Details on the number of records that are added, updated and skipped

In the Import History page you can perform the following operations:

  • Check details of the import
  • Confirm the imported data
  • Undo the data import

Files imported within the span of 60 days will be listed under Import History. Each entry in the imported history gives you the option to view the records that were added, updated and skipped. These details are available only for 7 days from the day the records are imported after which you can only see the number of records that were added, updated or skipped.. In case the records are not imported properly and you want to undo the import, you can do so within 30 days, after which the import action will be locked and confirmed automatically.

Availability

Profile Permission Required: Users with the Import permissions in profile can access this feature.

 

Check the Import Details

On importing a file, the import details will be listed under the Import History. This includes the date and time when the records were imported, user's name who imported the file, details on the number of records that were added, updated or skipped, details on why records were skipped, etc.

To check the import details

  1. Click Setup > Data Administration > Import History.
  2. In the Import History page, every import action will be recorded along with the details on the date and time that it was imported.
  3. Click on the added link to check the records that were added on importing.
    The fields in the import file will be listed, along with the values for each record.
  4. Click on the updated link to check the records that were updated on importing.
    The fields in the import file will be listed, along with the values for each record. The row numbers help you easily locate the records in your import file.
  5. Click on the skipped link to check the records that were not added in Zoho CRM.
    The fields in the import file will be listed, along with the reason why the records were not imported. The row numbers help you easily locate the records in your import file.
  6. Click on the Export link and get a copy of the skipped records and the reason why they were not imported.

Note

  • In the Skipped records list, the details of the first 5 fields (from the import file) that were mapped with the Zoho CRM fields will be listed. The rest of the field details will be available when you export the list.
  • When you export the skipped records, you will get a .csv file with all the fields that were mapped with the Zoho CRM fields during the import process. Also, the reason why the records were skipped will be available. You can make the necessary changes to the file and import it again.
  • The Added and Updated view will list only those fields available in the All [Records] list view of the respective module.
  • There is a possibility of a mismatch in the added/updated records count and the number of records that you see in the detailed list. There are two reason why this mismatch is there.
    • Records are deleted manually by a user.
    • You do not have permission to view the records. (When organization's data is imported).

Confirm or Undo Imported Data

Within 30 days from the import, one can undo the import process and remove the imported records from Zoho CRM. For security reasons, you may want to lock the imported records so that one does not remove the records that were imported. This is where the Confirm option is of use. After importing the data into Zoho CRM, confirm the operation if you are satisfied, so that the data will be permanently added to your CRM account.

To confirm or undo the import activity

  1. Click Setup > Data Administration > Import History.
    In the Import History page, the import entries are listed.
  2. Move your mouse pointer to an entry. Do one of the following:
    • Click to confirm the import.
    • Click the Undo this import link to undo the action and remove the imported data.

Note

  • Once confirmed, you cannot revert.
  • After 30 days from the import, the import action will be automatically confirmed. You cannot roll back once it is confirmed.
  • If you undo the imported Contacts, then the imported Accounts associated to contacts will also be deleted.
  • If you delete the imported Accounts, then the imported Contacts associated to the accounts will also be deleted.
  • If the data import is failed, it will be clearly marked in the data history.

FAQ

1. On what basis are the duplicate records identified during import?

2. I could not import the file. What could be the possible reasons?

3. How to avoid duplicate records while importing?

4. Whom are the imported records assigned to?

Top