Importing Into Zoho CRM

Importing Into Zoho CRM

Do you have a list in Excel that you would like to import into Zoho CRM? If your administrator has not restricted your ability to import, the process is fairly easy to accomplish, but understanding the options can make everything go smoother.

First you may need to prepare the spreadsheet
  1. Remove any extra rows from the top of the spreadsheet, like titles or blank lines. Row 1 should be the column headers. Row 2 should be where the data starts.
  2. Make sure that there is a column for any required fields and that it is populated. For example, if you are importing into Leads or Contacts, the “Last Name” field is required. Depending on how you set up your Zoho, “Account Name” may also be a required field. You can tell which fields are required by looking at any record in edit mode. Fields with a red underscore on labels are required. Any records in your spreadsheet that are missing a required field value will be skipped on import.
  3. If there are any date fields in your spreadsheet, make sure that you  format all date fields with a 4-digit year (mm/dd/yyyy hh:mm). Dates not formatted in this manner will not be imported. 
  4. If you want to assign to a user other than yourself, create a Record Owner column and enter the email address of the Zoho user to assign record ownership .

Now you are ready to import your data into Zoho CRM

  1. Click the module you wish to import into (e.g Leads or Contacts or Accounts. You cannot import into Activities, Quotes, Sales Orders, Purchase Orders, or Invoices).
  2. Click the  Import button at the top right of the module List view.
  3. Select the first option to  Import [module name]
  4. Click the  From File option (NOT "From other CRM’s")
  5. Click the  Browse button (or use the Drag and drop option) to search for and select the file to import. Click the  Open button
  6. Click the  Next button when the file has been uploaded successfully.
  7. If you have created multiple layouts for this module, use the drop-down to  Select layout to import to use for the import.
  8. Identify how to import the records from the spreadsheet file:
    • Add as new [module name] – Zoho will import the list as new records. If a record already exists in Zoho, it will be skipped.
    • Update existing [module name] only – Zoho will import the list and only update existing records based on the ‘Skip…’ field option you select. When you select this option, you many need to break up your import into multiple files with 5,000 or less records each.
    • Both – Zoho will import the entire list. If a duplicate record is found it will update the current record in Zoho. If the record is not found, a new record will be added.
  9. Then identify the matching field ( Find/Skip existing [module name] based on) by selecting an   option from the drop-down.
    • The first option will always be the  [module name] Id This is the system-generated ID that Zoho has defined for the record. You cannot see the ID in any view. You can only see this ID when you export the records. So, if you export the records in some way or do a bckup, and then update the field values in the spreadsheet, you can re-import the updated values into Zoho, matching on the module ID field.
    • Any other fields identified as ‘unique fields’ will be displayed. For example, the  Email  field might be listed for Leads or Contacts. The  Deal Name or  Product Name or  Account Name  fields will be unique identifiers offered for record matching in those modules (though you may want to be careful if you haven’t been strict about unique naming). If you created an Accounting ID for the Account records, you could import revenue values based on that field.  Unique fields are defined in Setup by selecting the field and editing the property to “Do not allow duplicate values”.
    • If you select  Update or  Both , you will see the option for  “Don’t update empty values for existing records ”. You will want to leave this one checked. For example, leaving it checked means that if the record has a Mobile Number and the file that you are importing has a Mobile Number column, but you don’t have anything in it for selected records, it won’t copy the blank field onto the field that has data. Sometimes you may want to wipe out old values, but usually you will want to keep it checked.
  10. Click  Next.
    • Column labels in the file will display in the left column. The fields defined for the module will be displayed in the second column.
    • Start by clicking the  Apply Auto Mapping hyperlink at the bottom left of the screen. Zoho will do it’s best to match what it thinks are the correct fields.
    • Review each of the selections in the second column for reasonableness. Use the drop-down to change any field links.
    • Click the  Unmapped button at the top of the screen to see any remaining file values that should be mapped. Use the drop-down to select the matching field.Map each of the  Fields in file to the  Fields in Zoho CRM .
    • Any required fields in the database will need to be matched before proceeding.
  11. Notes:
    • Whichever field you selected in step 9 above, you will be required to map that field.
    • If there are matching fields in the file, but you don’t want to use them to update any records in the CRM, don’t map them and those fields will remain untouched in Zoho.
    • When mapping the Owner field, if you followed the instructions a few pages back for ‘Assigning Record ownership’ to update that field with the email of the User, then you should select Owner – Email as well for the mapping.
  12. Once you have completed all the field mapping, click  Next .
  13. Click  Yes, Continue to confirm that you know that some fields may be left unmapped.
  14. Final Options
    • Assign Lead Source: This is only available in the Leads module. It allows you to select an option from the Lead Source picklist. Alternately, you could have created a column in your spreadsheet for Lead Source and filled in the values for all records prior to selecting the file for import.
    • Assign Owner : Select  Users option to select the desired user from the drop-down list. Select  Assignment Rule if you have created one. Assignment rules are good for assigning records based on conditions (State or Zip address fields, product interest fields, etc.). Or select  Field Mapping if you created a column in the spreadsheet and assigned ownership with the user’s email login.
    • Assign Tasks: You can select a Workflow Task to be launched against each record if you like. You can read more about creating Workflows in the Automation chapter. In the example above, a Task is created for each record in 3 days to follow up.
    • Add Tags : Add tag to each of the imported records.
    • Enable Manual Lead Approval option is only available when importing into the Leads module. If you check this option, an admin will need to manually assign users to each of the imported records.
  15. Click  Finish .
** For more great tips on preparing your spreadsheets   and getting your data ready for an import into Zoho, you can download a copy (below) of my 12-page guide that will help you get your data in shape.

Happy importing.

Susan Clark, Zoho CRM Certified Consultant, Authorized Zoho ONE Partner
Cornerstone Solutions www.zcrmhelp.com
susan@zcrmhelp.com


  

    • Recent Topics

    • No option for pick up in Zoho Books / Inventory but yes on commerce

      Is it planned to release soon on books/inventory?

    • Accessing Zoho form enteries via API

      Hi As a user I can view enteries to a form at: https://forms.zoho.com/<myOrganisation>/report/<myReportName>/records/web How do I access these entries via API? I don't have any problem with scope and getting tokens. But I have no idea what the API call

    • Zoho Books - France

      L’équipe de Zoho France reçoit régulièrement des questions sur la conformité de ses applications de finances (Zoho Books/ Zoho Invoice) pour le marché français. Voici quelques points pour clarifier la question : Zoho Books est un logiciel de comptabilité

    • Blueprint Issue - Being able to set a subform field as mandatory

      I'm creating a blueprint. My record involves a subform which is only shown once field is set but the field gets set in step two of the process. My problem - I can't save the record as the subform field is set to mandatory - If I unset the mandatory field,

    • Blueprint - Mandatory file upload field

      Hi, File upload (as we as image upload) field cannot be set as mandatory during a blueprint transition. Is there a workaround? Setting attachments as mandatory doesn't solve this need as we have no control over which attachments are added, nor can we

    • Zoho Books - Include Quote Status in Workflow Field Triggers

      Hi Zoho Books team, I recently tried to create a Workflow rule based on when a Quote is Accepted by the customer. This is something which I thought would be very easy to do, however I discovered that Status is not listed as a field which can be monitored

    • Zoho Books - Show Related Sales Orders on Quotes

      Hi Books team, I've noticed that the Quotes don't show show the related Sales Order. My feature request is to also show related Sales Orders above the Quote so it's easy to follow the thread of records in the sales and fulfilment process. Below screenshot

    • Add VAT/Tax line to bank adjustments

      When categorising transactions and matching bank feeds with transactions such as customer payments, we use the "Add Adjustment" to add things like fees/bank fees. It would be useful to choose a VAT/Tax rate here. Whilst there is a bank charges option when adding a payment, this goes into the default bank charges account. We use the adjustments so that we can choose the account and separate our fees. We use different card providers and Worldpay charges VAT so we are stuck. We cannot integrate with

    • New Menu Layout Feedback

      I'd really like to see the banking item back on the top of the menu. I'm sure part of it is just because that's what I'm accustomed to. However, for a bookkeeping program, I think there's a logic to having banking be on top. Not a giant issue, but something

    • How to use Rollup Summary in a Formula Field?

      I created a Rollup Summary (Decimal) field in my module, and it shows values correctly. When I try to reference it in a Formula Field (e.g. ${Deals.Partners_Requested} - ${Deals.Partners_Paid}), I get the error that the field can’t be found. Is it possible

    • Form Accessibility

      Hi, is there an update on the accessibility standard of Zoho forms? Are the forms WCAG 2.1 AA compliant? 

    • Cannot schedule report delivery

      The only 'send option' available when exporting reports is 'immediately' The option to schedule the report is missing.

    • adding attachment in sendmail script where attachment is in a CRM field

      Hi all, I have a custom field of type 'File Upload' in one of my modules in my CRM. I want to include the file in that field as an attachment to an email - which is done from a button on  the 'Results' module. I have created a script and a button to initiate an email from that module. The Deluge scripting window has allowed me to add arguments for all the fields I need to use except for the one file upload type field. My script currently looks like the below (content of the email omitted). As you

    • [Free Webinar] Learning Table Series - AI-Enhanced Insurance Claim Management in Zoho Creator

      Hello Everyone! We’re excited to invite you to another edition of Learning Table Series, where we showcase how Zoho Creator empowers industries with innovative and automated solutions. Struggling with lengthy claim processes, a lack of visibility into

    • Not sure how to use credits to my account

      Hi I have a $50 credit to my account. I'm just wondering how I can apply that to either a current invoice or to try a new service. Any advice would be great, thanks. Kind Regards Chris

    • Control who sees Timeline and Interactions in Zoho CRM through Profiles

      The feature has been enabled for all DCs (except US, EU, and IN DCs). We will be rolling it out to the other DCs in the upcoming days. Dear All, In a CRM, not all users would require access to the history of a record. For instance, a Marketing Operations

    • Zoho Desk Integration - Add the option to send the estimate from the Zoho Desk Ticket Integration

      Hi, Currently in the Zoho Desk integration, the user is able to create an estimate from a ticket, once the estimate is created the user can see the estimate under the ticket (see screenshot below), but is not able to send that estimate from Zoho Desk.

    • Utilisation de Zoho en conformité avec l’article 286 du Code général des impôts (CGI)

      Cher(e) client(e), Conformément à l’article 286 du Code général des impôts (CGI) impose aux entreprises assujetties à la TVA d’utiliser des systèmes de caisse ou de gestion commerciale certifiés lorsqu’elles enregistrent des ventes à des particuliers.

    • Issue showing too many consultations in my workspace link.

      Hi Team, I’ve set up two Workspaces to track meetings from different sources. So far, this has been working well, and the two Workspaces are differentiated without any issues. However, when I navigate to Consultations and share the link to my personal

    • 👋 Welcome to the Zoho MCP Community

      Hello all, glad to have you here! This is your space for everything AI agents, MCP tools, and intelligent business apps. This community is for you — developers, partners, creators, and businesses exploring how agents can transform work. Whether you’re

    • CRM Validation Rules Support Only Single Condition

      Simply put, CRM validation rules support only a single condition for each field on "All Records". You also cannot specify additional validation rules on the same field because it has already been used in an existing validation rule. The ONLY solution

    • Unapproved Leaves are hard to distinguish in Attendance View

      This is a an unapproved leave request It appears in the Attendance view without any visual indicator if its approved or not For a whole day request this might be manageable but for hourly requests it gets very hard to know which are approved, which are

    • Performance Appraisal Probation Period

      Hello All,  Is there any possible way to create an appraisal cycle for new staff members, at the end of probation period? Many thanks!

    • Zoho Creatorの一括操作における処理の同期/非同期について

      現在、Creatorのレポート機能を利用して、複数のレコードに対して一括で処理を実行しようとしていますが、処理の実行順序について確認したいことがあります。 レポート内の複数レコードに一括で処理を実行した際、処理は同期的に行われるのでしょうか？それとも非同期的に行われるのでしょうか？ 【同期処理の場合】 レコード①に対する処理が開始され、終了後にレコード②に対する処理が開始され、最後にレコード③に対する処理が実行されるように、処理が順番に行われる場合。 【非同期処理の場合】 レコード①、レコード②、レコード③の処理が一斉に開始され、それぞれ並行して処理が行われ、全処理が終了する場合。

    • Adding Chargebee as a Data Connector

      Is it possible to get Chargebee added as a Zoho Analytics data connector?

    • Mail Delivery Failed

      Good morning,   I have just set up an account with 5 users, however each time a message is sent to 1 user a m'mail delivery failed' message is generated. See below.   Any ideas   Thanks   Rob   This message was created automatically by mail delivery software. A message that you sent could not be delivered to one or more of its recipients. This is a permanent error. The following address(es) failed: robb@thesmartgroup.ae mailbox is full: retry timeout exceeded ------ This is a copy of the message,

    • Delete commerce website

      I need to delete a commerce website, but the only option is to click on settings, REQUEST DELETE, choose an urgency notice, add a message....AND THEN nothing, no way to send the request. Why is nothing simple!?!?!  I just want to delete the store.  The

    • Adding external users to Zoho Social under Zoho ONE licence - how to best achieve this

      My client has a small business, and we are looking to implementing Zoho ONE with a single flexible user licence as that is all they really need and offers the best pricing for the range of modules we eventually wish to set them up with, one of which will

    • Has anyone built a custom AI support agent inside Zoho (SalesIQ/Zobot)?

      Hi all, I’ve been experimenting with building my own AI support assistant and wanted to see if anyone here has tackled something similar within Zoho. Right now, I’ve set up a Retrieval-Augmented Generation (RAG) pipeline outside of Zoho using FAISS. It

    • This mobile number has been marked spam. Please contact support.

      Problem Description: One of our sales agents in our organization is unable to sign in to Zoho Mail. When attempting to log in, the following message appears: This mobile number has been marked as spam. Please contact support at as@zohocorp.com @zohocorp

    • What’s New in Zoho Inventory | April 2025

      Hello users, April has been a big month in Zoho Inventory! We’ve rolled out powerful new features to help you streamline production, optimise stock management, and tailor your workflows. While several updates bring helpful enhancements, three major additions

    • When Zoho Tables Beta will be open to EU data center

      Hello all, We in EU are looking at you all using and testing and are getting jealous :) When we will be able to get into the beta also? We don't mind testing and playing with beta software. Thank you!

    • Pass current date to a field using Zoho Flow

      I am trying to generate an invoice automatically once somebody submits a record in Zoho CRM. I get an error in the invoice date. I have entered {{zoho.currentdate}} in the Date field. When I test the flow, I get "Zoho Books says "Invalid value passed

    • API: Mark Sales Order as Open + Custom Status

      Hi, it's possible to create Custom Status (sub-status actually) states for the Sales Order. So you have Open, Void. Then under Open you can have Open, and create one called Order Paid, Order Shipped, etc etc...which is grouped under Open. I can use the

    • Multi-Unit Inventory with Flexible Unit Selection (Purchase in One Unit, Sell in Another)

      We need multi-unit inventory management in Zoho Books with the flexibility to choose units (e.g., Box or Piece) at the time of purchase or sale. For example, if 1 Box = 10 Pieces, we should be able to record purchases in Boxes but sell either in Boxes

    • Zoho Quartz Screen Recording

      Hello, can we get access to Quartz, please, as a standalone solution? It would be great for creating training videos for current and future staff on how to use Zoho software according to our company requirements. Thank you

    • This domain is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details

      This is the error i keep getting when trying to use my Zoho Domain Mail. This domain is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details Find attached. I hope this can be resolved very quickly so i can go on and make

    • Tip 26: How to hide the "Submit" button from a form

      Hi everyone, Hope you're staying safe and working from home. We are, too. By now, we at Zoho are all very much accustomed to the new normal—working remotely. Today, we're back with yet another simple but interesting tip--how to hide the Submit button from your forms. In certain scenarios, you may want to hide the submit button from a form until all the fields are filled in.  Use case In this tip, we'll show you how to hide the Submit button while the user is entering data into the form, and then

    • filter broke my data

      I uploaded a file recently from Sheets and it has top 2 rows frozen, with table headers in second row and each one is filterable. somehow my first 2 columns became unfiltered and no matter what I do I cannot reapply the filter?? also didn't realize they

    • Email address for forwarding is not saving and there's no confirmation ema

      Steps to reproduce: 1. Enter my forward email in the email forward section of the account 2. Click save 3. See a notification stating saved successfully 4. Refresh the page, no forward email is saved 5. No email confirmation received at the forwarding

    • Next Page