Import/Export Contacts

On this Import/Export screen, users can sync their contacts with Google and Outlook. The contacts can also be imported and exported in CSV format.

contacts import export

Importing Contacts

This feature allows import of contacts into the OfficeClip Contact Manager from a CSV file.

  1. Click CRM > Contacts > Import/Export.
  2. Click the comma-separated CSV file in Import contactsto import a CSV file.

    contacts import

  3. Click Choose File and upload the field from desired location.

  4. After selecting the file, if you have no issues uploading duplicate entries, then choose the first option Ignore duplicates while import.

  5. But if you do not want duplicate entries in your database, then choose the second option, Merge duplicates by selecting criteria.

  6. Select the appropriate fields to match and merge the duplicate entries. You can also select the desired option on how to override the fields with existing empty fields or with the imported fields.

  7. Then click Import .

  8. Select the fields in the imported CSV file for mapping in the OfficeClip fields. This mapping ensures that fields in the CSV file match correctly to the OfficeClip fields.

  9. Click OK. The contact import results will be displayed on the next screen.

Exporting Contacts

The Export feature allows contacts (or filtered contacts) to be exported into the comma-separated values (CSV) format.

  1. Click CRM > Contacts > Import/Export > Export Contacts.

  2. To export contacts in CSV format, click the link. Select the appropriate tab.

  3. Export all contacts or exports filtered contacts.

  4. Select which fields from the OfficeClip database you want to have in the CSV file. You can move them up and down with the icons. these fields will appear as the first row in the CSV file after being exported.

  5. Click Export when finished mapping or click Cancel to exit without taking any action. Depending on your browser settings, either you can see the excel worksheet on your screen, or you will be presented with an Open or Save pop-up dialog box.

To Export filtered contacts to a CSV file:

  • Click the CSV(Filtered contacts) tab.
  • From the next screen, select the filter from the drop-down list and click Export.

  • Depending on your browser settings, either you can see the excel worksheet on your screen, or you will be presented with an Open or Save pop-up dialog box.


Your Google and Outlook contacts and appointments can be easily synchronized with OfficeClip. The following entities can be synchronized:

  • OfficeClip Contacts.

  • Contact Related Notes.

  • Contact Related Events.

  • Contact Related Tasks.

  • OfficeClip Calendar of Events - (Non-Contact Related).

  • OfficeClip Notes - (Non-Contact Related).

Google Sync

Synchronize OfficeClip Contacts and Calendar entries with Google Contacts and Calendar.


Synchronizing with the Google default contact folder and default calendar is not advised. This recommendation is meant to keep OfficeClip information separated from other personal information in Google.

Following are the steps for syncing your contacts with Google:-

  1. Click CRM > Contacts > Import/Export > Google Sync.

  2. On the next screen, click on Install button to enable the integration.

  3. Select Authorize Google Account.

  4. Select the account which is to be used for synchronization and click on Allow to allow access of your Google account to OfficeClip.

  5. Select the Google contacts folder which you want to sync with OfficeClip from the dropdown and click Next.

  6. Synchronization Options: OfficeClip allows one-way and bidirectional synchronization. One-way synchronization allows one system (either OfficeClip or Google) to be the master and the other system to act as a slave. Any changes in the master system update in the slave but not vice versa.

  7. Select the appropriate direction - (one-way sync, two-way sync).

  8. Synchronization Policy: The synchronization policy determines when the same record is changed in both Google and OfficeClip, and which one will be given priority. You can either choose if Google overwrites OfficeClip or OfficeClip overwrites Google.

  9. Also when an item is deleted in one system, you can decide whether the same item will be deleted in the other system.

  10. CAUTION:

    You may want to keep the deleted item option unchecked to protect each system from inadvertent deletion of information. For example, removing contacts from your Google account should not remove shared contacts from OfficeClip.

  11. If you want to sync your contacts or events on a regular basis you can select the appropriate option from the Auto Sync dropdown.

  12. Then click on the Sync Now button. If the sync is taking time click on the Refresh button at the top.

  13. You will see a message when your contacts are synced successfully. It will sync all the contacts and their information. Check the image below to see the Google contacts synced with OfficeClip contacts.

Synchronization Status: This allows automatic synchronization in the background. Clicking on the button Reset Sync resets the entire synchronization table. This means that the next time when the user attempts synchronization, the algorithm will examine each record and attempt to determine which record in one system matches with the record in another system (comparing the values of the fields).


Reset Data should be used sparingly. Use it if you think that the synchronization is repeatedly failing. If it happens too often, contact your support personnel.

Outlook Sync

OfficeClip contacts can also be synchronized with Microsoft Outlook.

contacts outlook sync

To synchronize with Outlook, you will need to install the Outlook add-in available from the OfficeClip website. The Outlook add-in works in the same way as the Google Sync. Refer to the Outlook Add-in help file for details. Follow these steps to sync the contacts with Outlook:

  1. Click on the MS Outlook Connector button to download the Outlook Connector

  2. After installing the outlook connector, you will be able to see the OfficeClip option in the Outlook menu.

  3. Click OfficeClip > Options to synchronize contacts

  4. Select the appropriate options, checkmark on required, allowed objects, select the Synchronization policy and click Save.

  5. Click on the OfficeClip > Sync now option. When you sync for the first time, you will need to login to OfficeClip and select the Organization to sync.

  6. Select the organization in which the Contacts are to be synced and click on the Set Organization

  7. To sync your contacts, tasks or events on a regular basis select the option Run Sync Every 10 minutes, 30 minutes, 1 hour, 4 hours, 6 hours, etc.

    The Reset Data button clears the entire synchronization table. You will need to login to OfficeClip again and synchronize from the beginning.