Exporting all Contacts from Outlook ready for import to Zoho CRM

Exporting all Contacts from Outlook ready for import to Zoho CRM

You can use the Outlook Import/Export function to achieve this. It's typically used to migrate the actual emails, but it suits the purpose of getting just the email addresses and Contact data to import into Zoho CRM.

Here is how to do it in Outlook :
  • Click on 'File', 'Import and Export' to open the Wizard
  • Select 'Export to a File' [then click Next]
  • Select a CSV file [click Next]
  • Select an Outlook folder. Your Inbox or Sent Items or both if required.
  • Click on Browse to select a location and then type the file name to export the information to (terminated by .csv) [Next]
  • Click on Map Custom Fields. This will bring up a list of all the available fields that are available in that folder.
  • Since we are only interested in Email address, click on Clear Map and then from the Left side click on From: (address) and From : (Name) and drag that to the Right list
  • Click OK
  • Click Finish
  • Open the output file using Excel and remove the duplicates.

You now have a CSV ready for import into Zoho CRM.

    • Related Articles

    • Email Templates are now available in the Zoho CRM mobile app

      The capability to use email templates has now been introduced in the Zoho CRM mobile app. This means that you can very easily send standard emails whilst on-the-move. I have a client that makes collections and needs to provide photo evidence of the ...

    • Zoho CRM Custom Sales Signals

      Custom SalesSignal The SalesSignals feature in Zoho CRM provides real-time notifications of all touch points from your leads, contacts, or potential customers. You can keep track of all the customer interactions across various channels and follow-up ...

    • Zoho Desk : Insert HTML in Desk Templates

      For a professional look, insert pre-built HTML code to your Zoho Desk Templates. Pre-requisites: Administrator Access to Zoho Desk Pre-built HTML code as required Process: In Zoho Desk, go to the settings cog and open the Settings menu: Go to ...

    • Merging Duplicate Records

      Merging Duplicate Records Over a period, there may be a chance of accumulating duplicate records. You can search the duplicates and merge them for a better organization of records. Find & Merge Duplicate Records This feature gives you the option to ...

    • Zoho Desk - Email Reply Failed From Being Sent - Outlook Authentication Issue

      Zoho Desk - Email Failure Alerts On occasion we have reports saying Zoho Desk shows the following error when sending an email: Outlook Authentication - Mandated Password Change This is often related to an issue with authentication within the Outlook ...