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

    • 5名限定 課題解決型ワークショップイベント Zoho ワークアウト開催のお知らせ (9/25)

      ユーザーの皆さま、こんにちは。Zoho ユーザーコミュニティチームの藤澤です。 9月開催のZoho ワークアウトについてお知らせします。 今回はZoomにて、オンライン開催します。 ▷▷参加登録はこちら：https://us02web.zoom.us/meeting/register/6OSF2Bh6TumsMIlDwaY_PQ ━━━━━━━━━━━━━━━━━━━━━━━━ Zoho ワークアウトとは？ Zoho ユーザー同士で交流しながら、サービスに関する疑問や不明点の解消を目的とした「Zoho

    • hiding a topic from all but one segment (or list)

      My organization sends out a number of newsletters using Zoho Campaigns. One of those newsletters is for volunteers. In order to become a volunteer, a person has to first go through our volunteer orientation (training). After that, they can receive newsletters

    • How do I set up this automation correctly?

      When contacts enter my Subscribers list, I want it to reference a custom field to see if it is empty. Then I want it to do two things: If empty: Assign a tag based on a different custom field. If that custom field is empty, assign a different tag. If

    • Function #62: Display associated Quote on Invoice details screen

      Hello everyone! Today, we are sharing a Related List script that makes it easy to view and access the quote from which an invoice was created right from the invoice details screen. This Related List displays the Quote number and Amount, allowing you to

    • Custom confirmation message

      How can I change the message that users see after they submit the booking form? I have to confirm some details before their appointment is officially "confirmed", so I want to change it where it doesn't say their appointment is "confirmed" but rather

    • email forwarding not working

      Your email forwarding service does not work. I received the confirmation email and completed the confirmation, after that nothing and nothing since no matter what I have tried. Shame as everything else was smooth. I spose it's harder to run one of these web based internet mail services than you guys thought!!! can you fix the email forwarding asap PLEASE!

    • Desk x CRM Integration

      Howdy! We currently use SalesIQ but we are considering moving across to Desk as it seems to have more functionality that we want. One of the pulls is the ability for our customers to self serve. But, I might be getting over excited and not actually need

    • Function #53: Transaction Level Profitability for Invoices

      Hello everyone, and welcome back to our series! We have previously provided custom functions for calculating the profitability of a quote and a sales order. There may be instances where the invoice may differ from its corresponding quote or sales order.

    • Issue with Save & Share Link – Works for Others but Not Creator

      I’ve enabled the "Save and Share" feature in Zoho Forms, and it works correctly for all users accessing the public link—except for me (the form creator). Issue Details: When I save and share the link, recipients see a “no permission” error. The form is

    • Save the pdf report from a registration form in a Folder

      Through Zoho Forms I created a registration form with quite a lot of rules to handle different variables (TEAM types, payment in installments, etc.), and the result is pretty good. The automatic PDF that is sent to the respondent upon submission is already

    • zoho forms integration to zoho work drive

      Scenario: A user fills out a Zoho Form, entering details such as email, mobile number, and other required information, and uploads supporting documents like PAN, Aadhaar, etc. Upon submission, the data is available in Zoho Forms Reports. Requirement:

    • Zoho Forms to Zoho CRM Integration failed - can I restart it?

      The integration of Zoho Form to Zoho CRM has failed. Is there a way for me to restart it for the impacted entry?

    • insert an equation, but in document, it shows an image not available.

      I'm new to Zoho writer and used Zoho writer in desktop app version . When I inserted an equation, I got an image not available sign. Any help is appreciated. Thanks, Charles

    • Zoho Desk Android app update - Swipe action customization

      Hello everyone! We have brought in support for the swipe action customization in latest version(v2.9.13) of the Zoho Desk Android app update, enabling you to configure left and right swipe gestures on tickets to carry out the actions swiftly without opening

    • Import KB template OR Export template for zoho desk?

      Greetings. Can you tell me if there is a way to get an EXPORT of my KB articles? OR is there a template you supply for importing KB articles into my zoho desk? I am looking for a method of understanding what fields can be imported, and what their possible

    • XML format to import knowledgebase into Zoho Desk

      Hi, We just started to use Zoho Desk and want to import our knowledgebase from our old support system (Freshdesk) to Zoho Desk. Can anyone give us information about the format of xml file to import? There is no explanation on the related page.

    • Zoho Desk integration with Power BI

      Hi, I want to be able to create a Power BI report which has live updates of ticket data from zoho desk, is this possile at all? Thanks Jack

    • Arranging Ticket Templates

      Is there any way to arrange our ticket templates? It doesn't look very organised when it's just arranged according to when they were created. We want the list to look more organised, by arranging/grouping them by topics, or even just by alphabetical

    • What they mean with "Portal"?

      I just downloaded this app to take my personal notes on digital art studio because it seemed to me the most comfortable app to do it, I use it very often, what do they mean by “no activity on your portal”? I have about 1 year of work here and I don't

    • Inactive User Auto Response

      We use Zoho One, and we have a couple employees that are no longer with us, but people are still attempting to email them. I'd like an autoresponder to let them no the person is no longer here, and how they can reach us going forward. I saw a similar

    • favorites no longer listed

      Hello, I can no longer navigate to my Favorites from the pulldown at the top of my grid view (see attached screenshot). I wasn't able to find it anywhere! Please help me display my Favorites. Thank you!

    • Notecards Disappeared

      Got a new phone. Downloaded and signed in Zoho Notebook. Not finding the Note cards. Just Empty Note books. Frustrating.

    • Table Errors

      Hello, I'm new to Zoho Notebook and using it on several Mac/Apple devices. My question is regarding tables: Why do they become broken, and how to fix the error without retyping all my data? (Please see the screenshot attached.)

    • Online Calculator with Zoho Forms?

      I'd like to build a custom calculator on my website. Zoho Forms seems to offer all the fields for basic calculations performed live without pressing any "Calculate" buttons. Unfortunately, there is still that "Submit" button at the bottom. There is nothing

    • Zoho Tables instead of Zoho Creator Spreadsheet reports <3

      That would make my day for sure. Zoho Creator is create, but miss data entering as AirTable/Spreadsheet can. Seeing Zoho putting effort in this makes me think maybe one day we could see a similar interface for Zoho Creator spreadsheet reports. B.

    • Zoho Sheet - Desktop App or Offline

      Since Zoho Docs is now available as a desktop app and offline, when is a realistic ETA for Sheet to have the same functionality?I am surprised this was not laucned at the same time as Docs.

    • Notebook Stack

      Hi Everyone I Hope you´re fine, I´m sorry if this idea was posted before (I made a search but I haven´t find anything related). So, Having the possibility of stacking notebooks would be an interesting way to order notebooks that correspond to the same

    • Writing on sketch cards is bugged when zoomed in

      When zoomed in, it writes a noticeable distance above or to the side of where you're actually trying to write. The further you're zoomed in, the more noticeable it is. Zooming is also entirely absent on the desktop version.

    • Swipe between notes on iPhone

      It'd be convenient if I could move from one note to the next in a notebook simply by swiping left to right.

    • Sales IQ chat is not working in signed android apk

      I have integrated ZOHO sales IQ support chat and i have followed each step and its working fine in my development build but when i create signed APK for it. Chat does not work in it and showing awaiting for detail. I previously asked the same query but

    • COQL order by COUNT not working

      Dear community, I am trying to get a list of deal amounts per planner working on it and sorted to get see who has the least amount of deals. For some reason, I am unable to use sort by in combination with a COUNT. My original code was: query = "select

    • I want to duplicate a report and name it something else

      Hi, I have created a report, and now want to reproduce it and call it something else. so that I will end up with TWO separate reports with different titles. Please tell me how do I copy / reproduce a report please

    • Zoho CRM: Sales Rep Professional Certification Program on Coursera

      We are happy to share that we have published the Zoho Sales Representative Professional Certificate in partnership with Coursera, a leading platform for online learning and career development that offers access to courses and degrees from leading universities

    • OS X Notebook quits immediately upon launch

      NoteBook for OS X (Sequoia, but also under Sonoma) always quits immediately upon launch (so I cannot use the "Attach user log" option). I've restarted my MacBook but the problem persists. If it helps, attached is a diagnostic report from Library>Log

    • Can External users upload files or images to WorkDrive?

      I want to know if it is possible for someone externally through a link and PW be able to upload files and images onto WorkDrive?

    • Multi-line fields character limits

      Is there a way to set the character limit higher on multi-line fields so that we are not losing information pasted into the field? When the text is entered or pasted, there is no error to say that the text is too large. After saving and going back to view most of the text is gone.   Also, when viewing the resume, the text is not wrapped in the multi line fields and can t be read without scrolling across the page.

    • Taz bot not working — What should I do to resolve this issue?

      I am experiencing issues with the Taz bot in Zoho Cliq—not receiving responses or it does not seem to work as expected. Could you please explain why the Taz bot might not be functioning and what steps I should take to resolve this issue? Thank you!

    • OneNote Migration

      I am trying to migrate two notebooks from OneNote. For five days now I have had no notification that migration has completed and the migration page show 50% complete - one notebook completed one not finished. It just stays like this. I am unable to cancel

    • Set various time slot reminders for task and event

      Hi I would like known if there is possibility to set various time reminders for a task or event like we have the possibility to do in google calendar or google task. For example I'am creating an event or task and I want to be alerted before 30min and

    • Zoho Calendar not functioning---cannot edit, add attendees, etc.

      Hello, My calendar is acting strange. I'm using Chrome as my browser and pop ups are not blocked (the calendar worked fine yesterday). When creating an event, I'm not able to "edit" the event and add attendees, etc. The link is non-responsive. I cannot

    • Next Page