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

    • Set Default Payment Method & Default account

      Hi, I would like to know how to set the default payment method and default bank account when recording payments in zoho books. At present we have to change these fields everytime we record a payment, which leads to potential error and as we have a very

    • Directory Websites

      Directories are a good website category to gain search engine traffic. Directories for a professional service category as an example can help their members in search results over their individual website. It would be nice to have a directory template

    • Unified WhatsApp Number Management in Zoho Desk and SalesIQ

      Dear Zoho Desk Support Team, We are currently utilizing both Zoho Desk and Zoho SalesIQ for our customer support operations. While both platforms offer WhatsApp integration, we are facing challenges due to the requirement of separate WhatsApp numbers

    • Customer Portal on Zoho Desk

      Hi, I'd like to know more about the items below I found when setting up the Customer Portal on Zoho Desk. Could someone help me explaining these in details? Especially the 2nd and 3rd point. Thanking you in advance! Permissions Customers can sign up for Customer Portal Customers can view tickets of their organization (contacts) Customers must register to access Customer Portal Display Community in Customer Self Service portal

    • Slow Performance on desk.zoho.com. 11/3/2025

      I’m not seeing any active service alerts for desk.zoho.com, but everyone on our account is currently experiencing very slow load times when opening or navigating tickets. We’ve already tried the standard troubleshooting steps — clearing cache and cookies,

    • "Authorize to Access Your Account"

      Hi, I'm trying to log into cliq on my phone but I can't. It says "Authorize to access your account - Verify your identity to access your account using oneAuth credentials", and asks for a password. I tried maybe 100 different passwords and nothing works.

    • Books API Receiving an Error that Doesn't Make Sense when Creating Credit Note - trying to use 'ignore_auto_number_generation' argument

      Hello, I'm working on a newly created routine and I'm getting an error that doesn't make sense when trying to create a new Credit Note. Here is my POST request. Endpoint: https://www.zohoapis.com/books/v3/creditnotes?organization_id=########## Body:     {

    • Computer Showing Offline in Unattended Access

      I have a computer that was connected to the internet but showing offline in Assist. I tried uninstalling the program and deleting it from Zoho Assist the reinstalling and it still does not show up. I have been a user for several months and am not pleased with the lack of connectivity with Assist. If this continues I will have to find another product. The computer I reinstalled it on is not even showing up in Assist now. The name is NYRVLI-PC. Thanks

    • Closing Accounting Periods - Invoice/Posting dates

      Hi, I have seen in another thread but I'm unsure on how the 'transaction locking' works with regards to new and old transactions. When producing monthly accounts if I close December 24 accounts on 8th Jan 25 will transaction locking prevent me from posting

    • Zoho CRM Portal Error

      Hi, We’re experiencing an issue with the Zoho CRM Portal. When we try to access it, we receive an HTTPS connection error: net::ERR_CERT_COMMON_NAME_INVALID. If we proceed past that, we then get a 400 Bad Request error. Could you please help us resolve

    • Can we do Image swatches for color variants?

      We want to do something like the attached screenshot on our new zoho store. We need image swatches instead of normal text selection. We want to user to select an image as color option. Is this doable? I don't see any option on zoho backend. Please h

    • Meeting impossible to use when sharing screen

      he Meeting tool in Brazil is practically unusable when sharing anything, whether it’s a presentation or simple navigation. When accessed via Cliq, the situation gets even worse: even basic calls fail to work properly, constantly freezing. And as you are

    • Paste issues in ZOHO crm notes

      Hi, since a week or so I have issues with the paste function in ZOHO CRM. I use "notes" to copy paste texts from Outlook emails and since a week or so, the pasting doesnt function as it should: some text just disappears and it gives a lot of empty lines/enters.....

    • Integrating Zoho CRM EmbeddedApp SDK with Next.js — Initialization and Data Fetching Issues

      You can get an idea from my code I have given in end: First, I worked on a React project and tried the same thing — it worked. My goal was to import the Zoho script and then load contacts using the Zoho Widget SDK, which was successful in React. Now,

    • Feature enhancement: Highlight rows based on a cell value

      Hello Sheet users, We're excited to announce a new feature enhacement, shaped directly by your valuable feedback! As you might know, conditional formatting is a great tool for anyone dealing with large data sets. Previously, if you’ve ever wanted to draw

    • Script Editor not an option

      I am trying to apply a script to a sheet and Script Editor is not an option. I don't want to go outside Sheets to do this (like Creator) if it can be done inside Sheets.

    • monetizing the courses

      Can I add a price for course enrollment ?

    • How to copy value from a single line field into a picklist field within a module's subform?

      Hello there, I have a single line field in a module's subform. I would like the value in the field to automatically update a picklist field within the same subform (both have items with the same names). Is this possible via function? Unfortunately, workflows

    • Can we add zoho books features like invoices estemates etc on our zohocommerce website. When our customer login with their account they can able to see all books features in one place on zohocommerce?

      Can we add zoho books features like invoices estemates etc on our zohocommerce website. When our customer login with their account they can able to see all books features in one place on zohocommerce?

    • File Field Validation

      Hello all, We are tracking our customer NDA agreements in our CRM and have created 2 fields to do so, an execution date field and a file upload field. I want to create a validation rule to ensure that when the execution date field is populated that the

    • Copy paste from word document deletes random spaces

      Hello Dear Zoho Team, When copying from a word document into Notebook, often I face a problem of the program deleting random spaces between words, the document become terribly faulty, eventhough it is perfect in its original source document (and without

    • Microsoft Teams now available as an online meeting provider

      Hello everyone, We're pleased to announce that Zoho CRM now supports Microsoft Teams as an online meeting provider—alongside the other providers already available. Admins can enable Microsoft Teams directly from the Preferences tab under the Meetings

    • Create custom rollup summary fields in Zoho CRM

      Hello everyone, In Zoho CRM, rollup summary fields have been essential tools for summarizing data across related records and enabling users to gain quick insights without having to jump across modules. Previously, only predefined summary functions were

    • Taxes for EU B2B Transactions

      Currently, ZC doesn't seem to have a procedure for validating VAT numbers of businesses purchasing in another EU state, and removing local VAT is valid. This is essential for all inter EU B2B trade.

    • Unable to Receive Emails on Zoho Mail After Office 365 Coexistence Setup – Error: 553 Relaying Disallowed

      Hello, My domain name is bigniter.com, and I’ve been using Zoho Mail as my email service provider without any issues. Recently, I followed the steps outlined in the Zoho documentation to enable Coexistence with Office 365: 🔗 https://www.zoho.com/mail/help/adminconsole/coexistence-with-office365.html#multi-server

    • How to update custom multi-user field in Zoho Projects?

      I'm trying to update custom multi-user fields in Zoho Projects via a Deluge function in CRM. The code I have so far is below. It works for updating standard project fields and single-line custom fields, but it does not work to update multi-user fields.

    • Enhance Sign CRM integration

      Hello all, I'm working on a custom Deluge script to enhance the integration between Zoho CRM and Sign by using a writer merge template for additional flexibility. I want to replicate the post-sign document integration that exists between CRM and Sign

    • CRM Related list table in Zoho analytics

      In Zoho Analytics, where can I view the tables created from zoho crm related lists? For example, in my Zoho CRM setup, I have added the Product module as a related list in the Lead module, and also the Lead module as a related list in the Product module.

    • Candidate Registration/Invitation

      It would be great to include the 'invite' candidate functionality into some of the automation functions - ether through a custom function trigger or webhook or accessible through an email template.  Currently there is no way to add this functionality into any workflows or blueprint steps which, I find limits the ability to invite candidates to engage with us directly through our candidate portal. 

    • [Free Webinar] Learning Table Series - Creator for Infrastructure Management | A Partner-driven collaborative session

      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. About the Learning Table Series The Learning Table Series is a free,

    • Where we can change the icon in social preview

      Hi, we changed our logo, and the image that appear in preview (ex : when we post a appointment link somewhere) is still our old logo. I did change our logo in the org setting. https://bookings.zoho.com/app/#/home/dashboard/settings/basic-info?clview=false

    • I want to subscribe 1 professional user but the email only 250 per day?

      When I subscribe 1 professional user, I am only able to send 250 email per day? So less? Or is it typo, 2500 rather than 250? Any sale agent or friends can clear my doubt? Thank You

    • Cadences

      I have just started using Cadences for follow-up up email pipeline. Is it just me or do you find the functionality very basic? For example, it will tell me (if I go looking for it) if someone has replied to a follow-up and been unenrolled; but it won't

    • Retainer invoice in Zoho Finance modlue

      Hello, Is there a way of creating retainer invoices in the Zoho Finance module? If not can I request this is considered for future updates please.

    • I have error AS101 when I try to add paypal@mydomain.com to Zoho

      Please help me with this. I tried to call the help line 4 times but don't get any response.

    • VAT on Multiple Expenses

      Firstly, might I say I am based in Ireland, and I'm not an accountant, and therefore my understanding of procedures could be somewhat limited. Scenario. An employee pays for items throughout a month, and therefore their claim for expenses includes multiple items - some of the items are VAT deductible (eg, an IT product) and some are not (eg, a client lunch). Discovery The odd thing in ZBooks, is that whilst it seems possible to add a VAT rate to a one-off item of expense, it is not possible to add

    • Workflow Creation with Zia gets stuck

      It gets stuck here:

    • Marketing Tip #5: Improve store speed with optimized images

      Slow-loading websites can turn visitors away. One of the biggest culprits? Large, uncompressed images. By optimizing your images, your store loads faster and creates a smoother shopping experience leading to higher sales. It also indirectly improves SEO.

    • CRM for email in Outlook: how to ignore addresses?

      We’re using the "Zoho CRM for email" add-in for Outlook. When opening an email, the add-in displays all email addresses from the message and allows me to add them to the CRM or shows if they’re already contacts. However, sometimes people listed in To

    • Rules not working properly

      I created a rule to display certain fields on certain states. But it seems to be not working. It hides the fields even when I selected California, (which is a state that should show the fields when selected)

    • Next Page