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

    • Default Value on a Number

      Hi, I would be nice to also be able to set the Default Value for a Number Field, not just the Initial Value shown, so if not on the screen so not enetred it can have a value of 0 for example. Thanks Dan
    • Add Setting Values to the Rules

      Hi, It would be great to use the rules to set values in fields for submission, such as if a Type is X then set the Field Y to 10. Thanks Dan
    • So we ran with it for the week

      In our company i bit the bullet and ran with FSM for a whole week. Service calls, deliveries and surveys. Covering about 30-120 miles a day to domestic properties. Loved the appointment list and satnav integration. Loved the timer to measure the appointments.
    • Organization Emails in Email History

      How can I make received Org Emails to show up here?
    • All new Address Field in Zoho CRM: maintain structured and accurate address inputs

      The address field will be available exclusively for IN DC users. We'll keep you updated on the DC-specific rollout soon. It's currently available for all new sign-ups and for existing Zoho CRM orgs which are in the Professional edition. Managing addresses
    • Is there a way to set Document Owner/Sender via the API

      When sending requests for zoho sign, it would seem zoho uses the id of the person that created the zoho api cred to determine the owner_id, is there a way to set a default for this?
    • Unlock your Zoho Vault with OneAuth, Windows Hello, TouchID, YubiKey, and many more!

      Hello everyone, We are thrilled to introduce one of the most highly requested features – the ability to unlock your Zoho Vault using various authenticators. The primary purpose of a password manager is to remember just one master password and securely
    • Has anyone built a ticket export that allows Help Center users to export the tickets shown in the My Area list they are looking at?

      Hi, We are moving to Zoho Desk soon. Our current support system displays an option in our help center allowing customers to export their Open, Closed, or all tickets based on which list they are looking at. We need to offer the same in Zoho Desk help
    • What's New - September 2025 | Zoho Backstage

      September has been a different month for Zoho Backstage. Instead of rolling out a long list of new features, we focused on something just as important: Performance, reliability, and stability The event season is in full swing, and organizers are running
    • Prevent stripping of custom CSS when creating an email template?

      Anyone have a workaround for this? Zoho really needs to hire new designers - templates are terrible. A custom template has been created, but every time we try to use it, it strips out all the CSS from the head.  IE, we'll define the styles right in the <head> (simple example below) and everything gets stripped (initially, it saves fine, but when you browse away and come back to the template, all the custom css is removed). <style type="text/css"> .footerContent a{display:block !important;} </style>
    • link to any Belgian bookkeeping software?

      Hello, Does anyone on this Forum can help me with the question whether the ZOHO CRM (Invoices) or ZOHO Book can be linked to software that is used for Belgian Bookkeeping/accountancy? By linking, I mean either with the help of a middleware program or either by the ability to export the custom made reports as CSV-files... If someone has an experience with online CRM-Accountancy in Belgium, with ZOHO (or other), it would be great to read it... Thank you
    • marketing automation

      wants to know about the zoho marketing automation
    • 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
    • Zoho Slowness - Workarounds

      Hi all, We've been having intermittent slowness and Zoho just asks for same stuff each time but never fix it. It usually just goes away on it's own after a couple weeks. Given that speed is a very important thing for companies to be able to keep up with
    • issue with image thumbnails not showing in Image Selector

      We have been using Zoho Campaigns for over a year, maybe close to two years, and this issue just started happening in the last month. I wanted to wait to see if it would resolve on it's own, and it doesn't seem to be. The thumbnail images for all new
    • Transitioning to API Credits in Zoho Desk

      At Zoho Desk, we’re always looking for ways to help keep your business operations running smoothly. This includes empowering teams that rely on APIs for essential integrations, functions and extensions. We’ve reimagined how API usage is measured to give
    • Problems with email templates (HTML - Outlook)

      Hi there, I've been trying to create a newsletter from the template "Business 4". Everything looks great in the preview, but when I send it to my Outlook inbox, the layout doesn't seems to stick. More particularly: - The line-height is way more reduced, even though I used the line-height tool from the template - Columns but they are sometimes misaligned - Font size is not always the one I've selected. Could you help? Thanks!
    • Zoho CRM still doesn't let you manage timezones (yearly reminder)

      This is something I have asked repeatedly. I'll ask once again. Suppose that you work in France. Next month you have a trip to Guatemala. You call a contact there, close a meeting, record that meeting in CRM. On the phone, your contact said: "meet me
    • Zoho CRM IP Addresses to Whitelist

      We were told to whitelist IP addresses from Zoho CRM.  (CRM, not Zoho Mail.) What is the current list of IP Addresses to whitelist for outbound mail? Is there a website where these IP addresses are published and updated?  Everything I could find is over
    • How to create a drop down menu in Zoho Sheets

      I am trying to find out, how do I create a drop down option in Zoho sheet. I tried Data--> Data Validation --> Criteria --> Text  --> Contains. But that is not working, is there any other way to do it.  Thanks in Advance.
    • Introducing Keyboard Shortcuts for Zoho CRM

      Dear Customers, We're happy to introduce keyboard shortcuts for Zoho CRM features! Until now, you might have been navigating to modules manually using the mouse, and at times, it could be tedious, especially when you had to search for specific modules
    • Zoho CRM's custom views are now deployable from sandboxes

      This feature is now available for users in the AU, JP, and CN DCs. This feature is now available for users in CA and SA DCs. New update: This feature is now available for users in all DCs. Hello everyone, We're excited to announce that you can now deploy
    • Where are Kanban swimlanes

      So i've been playing with Zoho Projects Kanban view a bit more. It appears that task lists are being used as the Kanban columns, which makes sense from the implementation point of view but not the logical one.  Kanban columns are statuses that a task can flow through, while a task list has been a logical way to organize related tasks and relate them to a mislestone. In other words a task in a particular task can go through several stages while remaining in the same task list. After doing some research
    • Send Automated WhatsApp Messages and Leverage the Improved WhatsApp Templates

      Greetings, I hope all of you are doing well. We're excited to announce a major upgrade to Bigin's WhatsApp integration that brings more flexibility, interactivity, and automation to your customer messaging. WhatsApp message automation You can now use
    • Scheduling Calls in CommandCenter / Blueprints

      I would love it if you could add a function to schedule a call in the lead's record for a future date. I know you can add a Task by going to Instant Actions > Task and completing the form: These tasks go into the lead's record under Open Actions. But
    • Zoho One - Syncing Merchants and Vendors Between Zoho Expense and Zoho Books

      Hi, I'm exploring the features of Zoho One under the trial subscription and have encountered an issue with syncing Merchant information between Zoho Expense and Zoho Books. While utilizing Zoho Expense to capture receipts, I noticed that when I submit
    • Limit in number of records for subforms and multi-select lookup fields

      It is my understanding that a maximum of 100 items can be selected in a multi-select lookup field, and that a total of 200 items can be selected in total between both subforms in a given module.  Are there any ways to work around this limitation if we
    • Kaizen #136 - Zoho CRM Widgets using ReactJS

      Hey there! Welcome back to yet another insightful post in our Kaizen series! In this post, let's explore how to use ReactJS for Zoho CRM widgets. We will utilize the sample widget from one of our previous posts - Geocoding Leads' Addresses in ZOHO CRM
    • Way to update CRM records in quik view

      I have custom module in zoho crm and that module have 500 records. I want a quick way or UI so that user can easily update the record information in quick view without going to record detail view or edit view. I tried zoho sheet option but in zoho sheet
    • Getting Permission denied to access this portal.

      We have one user that can't login to projects even though access has been granted. This user can login to accounts.zoho.com but when login to https://projects.zoho.com/portals.do we get this error: Unauthorized login to this portal Permission denied to access this portal. Check your portal URL again. Sometimes we also get "server too busy". We have tried killing sessions (in accounts.zoho.com) and we have deleted cookies; and tried different computers and still the same problem. All others use can
    • Marketing Tip #1: Optimize item titles for SEO

      Your item title is the first thing both Google and shoppers notice. Instead of a generic “Leather Bag,” go for something detailed like “Handcrafted Leather Laptop Bag – Durable & Stylish.” This helps your items rank better in search results and instantly
    • Does Zoho Docs have a Line Number function ?

      Hi, when collaborating with coding tasks, I need an online real time share document that shows line numbers. Does Zoho's docs offer this feature ? If yes, how can I show them ? Regards, Frank
    • Ticket Status Colors

      Can i change the colors of Ticket Status in the admin panel? Or even change the background of the entire cell of a Critical ticket? This way its easy for my agents to see a urgent ticket when it comes in. Right now everything is black text. Here Right
    • Template usage

      Hi, We are using some templates as a response to customer questions. Is it possible to analyze the usage of these templates? We want to know if the use of our templates has increased over time
    • Setting Default Views for Custom, List and Detail Views

      Hey, Is it possible to set a default custom view, list view and detail view for a module for every user? We are onboarding a lot of non technical people that struggle with these things. Setting the views as default would really help. Btw: also setting
    • Custom function return type

      Hi, How do I create a custom deluge function in Zoho CRM that returns a string? e.g. Setup->Workflow->Custom Functions->Configure->Write own During create or edit of the function I don't see a way to change the default 'void' to anything else. Adding
    • Filter Based API request in Zoho Books using POSTMAN

      How do I GET only specified CONTACTS based on created time or modified time in Zoho Books using POSTMAN. In the api documentation, it is written we can apply filters but I need a sample request.
    • URL validation

      We use an internal intranet site which has a short DNS name which Zoho CRM will not accept.   When attempting to update the field it says "Please enter a valid URL". The URL I am trying to set is http://intranet/pm/ Our intranet is not currently setup with a full DNS name and given the amount of links using the shortname probably isn't a feasible change for us.
    • Sync Lookup Fields from Zoho CRM

      HI Team, I have synced a lookup field from my CRM data to Campaigns. When I view the synced data the field appears to display a Zoho CRM record ID rather than the text value. Is it possible to get the sync to import the text value rather than the CRM
    • Has anyone been experiencing slow issues?

      Dear all, I just want to ask if anyone has been experiencing slow issues with Zoho Creator in the past two weeks? I worked with the ISP to improve network quality by changing routes and upgrading bandwidth, but nothing changed. I am in Vietnam.
    • Next Page