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

    • Manage Testing Process in Zoho Sprints

      Agile framework supports a robust quality assurance system that incorporates continuous testing throughout the development lifecycle of the product. The agile testing team focuses on planning the testing around the development, identifying defects early

    • Announcing the Zohotshots of the ZDC Hackathon 2025

      Hey everyone, The wait is finally over! After weeks of building, experimenting, and pushing creative boundaries, we’re excited to announce the winners of the second edition of the ZDC Hackathon. This edition brought together an incredible community of

    • ZOHO CRM Button Integration

      Hi Team, I’m currently working with Zoho CRM along with a custom application where I fetch deal details from the CRM and use them based on my requirements for each deal. Now, I want to enhance this setup. I plan to create a button on the Deal Detail page

    • Major journey crash and not loading. Zoho Marketing Automation

      Hi all. Last night (19MAR, 2026) Marketing Automation for a specific journey completely crashed, and since the crash the specific journey has failed to load at all (blank journey canvas, no journey appears, no menu accessible) but other separate journey's

    • Candidate Assessments, no workflows.

      I have an issue where I would like to trigger a workflow based on a candidate assessment being completed. Sometimes a returning candidate will complete a second assessment, on completion the status of the candidate will be updated to "Unqualified" if

    • Mail Merge in Zoho Desk

      Hello Team, Do we have an option of mail merge within Zoho Desk like we have in Zoho CRM? We have a requirement to generate some pdf file in the form of mail merge doc from the ticket.

    • Workdrive backup and default storage selection

      Hi community, I have been informed by Zoho that workdrive will be the default storage mechanism for crm and projects. These 2 Apps seem to have different design on how they interact with workdrive for storage. 1. Crm: seems to have files saves at the

    • Zoho vault filling in a form it's not supposed to fill in

      Hey there, I have a problem with ZOHO Vault autofill. In a software package, we have these options: For some reason zoho vault always replaces what's in the top option and fills a 2fa password in there, and then saves that value.. Meaning whatever was

    • Zoho Booking Integration with Desk

      Just wanting to share something in case it helps someone else who may run into a similar use case as we did. Issue: Currently, the Zoho Booking integration with desk will drop a comment into the ticket when a customer books a time, however it won't change

    • Let us view and export the full price books data from CRM

      I quote out of CRM, some of my clients have specialised pricing for specific products - therefore we use Price Books to manage these special prices. I can only see the breakdown of the products listed in the price book and the specialised pricing for

    • Syncing calendar with Google Calendar doesn't work when events are sent to auto repeat

      Hi... The ZOHO CRM -- GOOGLE CALENDAR sync is broken. If I create a single event on either side, sync works, but if I create an event with auto repeat on either side it doesn't work. Furthermore, events created before the sync don't show up in the calendar.

    • Organization wide Account and Contacts Visibility/Sharing Capabilities?

      Has anyone figured out a way to make visibility or sharing of Accounts and Contacts to be available across the entire organization without having to have every individual user edit their Sharing permissions? For our sales folks they need to be able to

    • Notification of Interaction Assignment

      If a user is assigned an interaction, they should be notified via email. These are almost useless because if I assign an interaction for someone to respond to, they dont know that I assigned it to them without me telling them or them logging in and discovering

    • Countries List Global Set- Complete with Phone Country Code and Continent.

      Dear Zoho Team I saw your recent addition to the Global Sets regarding the Countries list and states. While working on it, why didn't you also add things like Continent and Phone Country Code? Also, some ISO codes from some Countries/regions are mis

    • Custom Display Field for Lookup Dropdowns in Zoho CRM

      Could Zoho CRM support changing the display field in lookup dropdowns, like Zoho Creator does? This would make it much easier to select the right record by showing a more useful field instead of only the default one. It would improve speed, clarity, and

    • Message as bot

      I would like to be able to send a Cliq message truly as a bot. the current implementation of this function, while it sends the message as a bot it sends that message inside a chat from the user how authenticated the flow cliq connection instead of directly

    • Books <-> CRM synchronisation with custom Fields

      Hello, We are synchronising Books Customers with CRM Accounts. In CRM Accounts I set up last year a "segments" multiselect field shown below In Books, I set up a custom multi-select field with the same value as in the CRM And set up the synchronisation inside Books. Want to synchronise the Books Segments with the CRM Segments, but the later doesn't exist, and another non-existing is there ?! First, I don't understand where the field Segmentation is coming from. Second, I set CRM Segmentation to sync

    • Trouble with using Apostrophe in Name of Customers and Vendors

      We have had an ongoing issue with how the system recognizes an apostrophe in the name of customers and vendors. The search will not return any results for a name that includes the mark; ie one of our vendors names is "L'Heritage" and when entering the

    • Recording overpayment?

      So a customer just overpaid me and how do I record this? I can't enter an amount that is higher than the invoice amount. Eg. Invoice is $195 and he sent $200. He's a reccuring customer so is there a way to record so that he has a $5 advance for future invoice?

    • Introducing the New Zoho Assist Quick Support Plugin

      We are thrilled to announce the new Zoho Assist Quick Support Plugin, the upgraded and enhanced version of the Zoho Assist Customer Plugin. This new plugin allows organizations and IT administrators to deploy it directly onto their customers’ devices,

    • Automate your signing workflows with Zoho Sign + n8n

      Hello! We're excited to announce that Zoho Sign is now available as a community node on n8n, a popular open-source workflow automation platform used by tens of thousands of teams worldwide. n8n lets you connect apps, APIs, and services through a visual

    • Ask the Experts 27: Onboarding and managing support reps

      Hello everyone, We are back with our Ask the Experts (ATE) series for 2026. This year, we bring experts to help you address customer support challenges using Zoho Desk. For our first ATE, we are getting into the human side of customer support. "Every

    • 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.

    • Spotlight #27: Embed visual collaboration Spaces in your presentations using the Vani add-on

      Hello everyone! This month’s spotlight feature is the Vani add-on for Zoho Show. Every time you pause your presentation to open another tab or pull up supporting material, you lose a bit of momentum. At Zoho Show, we design features that keep everything

    • CRM

      Is anyone else experiencing this issue? Our company is not moving out of using Gmail's web app. It just has more features and is a better email program than Zoho Mail. Gmail has an extension (Zoho CRM for Gmail) that we're using but we've found some serious

    • Good news! Calendar in Zoho CRM gets a face lift

      Dear Customers, We are delighted to unveil the revamped calendar UI in Zoho CRM. With a complete visual overhaul aligned with CRM for Everyone, the calendar now offers a more intuitive and flexible scheduling experience. What’s new? Distinguish activities

    • Global Search / Command Palette in Live App

      Zoho Creator applications can contain many forms, reports, pages, and dashboards. While navigation inside the app is smooth, users still need to move through multiple menus or screens to find specific records or open particular modules. Currently, in

    • New 2026 Application Themes

      Love the new themes - shame you can't get a little more granular with the colours, ie 3 different colours so one for the dropdown menu background. Also, I did have our logo above the application name but it appears you can't change logo placement position

    • Smarter appointment allocation with round-robin distribution

      Greetings from the Zoho Bookings team! We’re excited to introduce the Appointment Distribution feature, a new way to decide how appointments are assigned among users. By default, appointments are distributed evenly across all event types, but this enhancement

    • A2P 10DLC Opt-in Rejection Issue with Zoho Creator Public Form

      Hi everyone, I’m working on an A2P 10DLC SMS campaign and running into repeated rejections due to opt-in issues. I’m using Zoho Creator for the registration flow. The form is public (no login required). Users enter their phone number and there is an unchecked

    • Analytics & Reporting Improvements + Export Bug

      Hello, I would like to raise several important product suggestions and issues regarding Zoho Expense: 1. Filter in Admin View → Analytics → Expense Details → Receipt Is it possible to add a filter that allows us to prioritize or sort reports that have

    • Make Quick Edits to Images Before Attaching

      Hello everyone, We have enhanced how attachments are handled in tickets to help agents preview and share files more efficiently in Zoho Desk. Agents can preview image attachments before adding them to tickets and edit them using attachment annotator.

    • 3/18 オンライン勉強会のお知らせ Zoho ワークアウト （無料）

      ユーザーの皆さま、こんにちは。コミュニティチームの中野です。 3月開催のZoho ワークアウトの開催が決定しましたのでご案内します。 今回はZoomにて、オンライン開催します。 ▶︎参加登録はこちら（無料） https://us02web.zoom.us/meeting/register/BoNTN7zYR8OvOPGShqBY0A ━━━━━━━━━━━━━━━━━━━━━━━━ Zoho ワークアウトとは？ Zoho ユーザー同士で交流しながら、サービスに関する疑問や不明点の解消を目指すイベントです。

    • Extend color coding to custom picklist fields

      Objectively, Projects has the best UI of any Zoho app — clean, intuitive, and never feels bloated. Big props to whoever owns the design. Feature request: color coding for custom picklist field values in field customization. You've already done it in two

    • New in Office Integrator: In-sheet text translation

      Hi users, We're pleased to introduce translation capability in the spreadsheet editor in Zoho Office Integrator. This allows you to translate the text in your spreadsheet's cells into 70+ languages from within your web app. Office Integrator's spreadsheet

    • Streamline email communication with Out of Office configuration

      Managing user communication effectively is the key to ensuring timely responses and consistent messaging. However, when users are unavailable, the absence of an Out of Office response can lead to delays and missed expectations. Managing these settings

    • Changing settings for auto logoff

      I've noticed that when I haven't used Cliq for a while, I have to re-enter my password. That is really clumsy, especially if you have a complicated password. Because it won't be filled in automatically. Is there a way to change that behaviour? We are

    • A few Issues when using "Pay Bill via Check"

      We have quite a bit of issues with how paying for Bills via Check works. Would love some feedback from the Zoho team in case we are doing something incorrectly. 1. When we go from a vendor and select "Pay Bill via Check" option, we see ALL the outstanding

    • Prevent tracking users from specific countries

      Currently, I’m receiving many bot visits from the United States and Malaysia. I would like these visits not to be recorded in SalesIQ. I already enabled the option to exclude traffic from cloud service providers, but I’m still receiving bot visits. Ideally,

    • My client requires me to have custom pdf file names to except payment for invoices, how can I customize this before emailing.

      Hello! I love the program so far but there are a few things that are standing in the way. I hope you guys can code them in so I can keep the program for years to come. My client requires I customize the pdf file names I send in for billing. Can you please

    • Next Page