Moving Office365 Contacts to Google Apps

If you have lots of contacts in your Office365 address book you may want to move them into Google Apps.

It takes some time though, so it may only be worth doing if you have a lot of contacts and you have already configured Outlook for Office365. Otherwise you might prefer to just re-create your contacts in Google Apps. This guide shows how to export contacts using Outlook 2010 (Windows) and then import them into Google Apps.

Export Contacts from Office 365

1. Open Outlook and select Contacts. Under the File menu, select Open and then Import (yes, Import).

2. Select Export to a file. Click Next.

3. Select Comma Separated Values (DOS). Click Next.

4. Select Contacts. Click Next.

5. Choose a file name and location for the Contacts export file you are creating. Click Next.

6. In the Export to a File window, click Finish.


Import Contacts Into Google Apps

7. Log into the Google Web App (GWA) and click on Contacts under the Mail drop-down menu in the upper left corner.

8. In the list under Contacts, select Import Contacts...

9. In the Import contacts window, click Choose File.

10. Select the contacts file that you created using Outlook. Click Open.

11. Click Import.

12. Your My Contacts folder now contains the imported contacts.

13. In the list under Contacts, you will see a new contact group called Imported, with its import date and number of contacts.

14. If you want GWA to find potential duplicate entries and merge them, select the Imported folder and click on Find & merge duplicates at the top of the Contacts window.

15. It will present you with a list of possible duplicate contacts as well as individual contacts with duplicate data. For all contacts that you know are not duplicates, uncheck the box next to them. Click Merge.

16. If there are duplicates, GWA will merge them and report that "The contacts were merged successfully." If there are no duplicates, you will see the following notification. For more detailed information about merging contacts, see Microsoft's Merging Contacts.

17. If you want to delete the Imported group, select it and, under the More menu, select Delete group. Click OK. This will not delete the imported contacts, only the new group.

Your Office365 contacts should now be in Google Apps.