Can anyone tell me how I can export my calendar and contacts from my Outlook for Mac 2011 (I'm using a MacBook Pro) to calendar & contacts on my Google account?
Macos – Export from Outlook for Mac 2011 to gmail – Mission impossible
macosmicrosoft-outlookmicrosoft-outlook-2011
Best Answer
This is what I found for doing it 'on the cheap'. This is not flawless by any means, so please don't do this with your eyes closed ;-) Do pay attention to the warning about uploading duplicate entries in Google.
I specifically did this for migrating data up to Google Apps, but having done similar things for my own personal Google account, I don't believe there's much difference.
I decided to write this up because it still seemed like a largely unanswered question out there. The Mac version of Outlook certainly doesn't make any of this much easier, what with formats like OLM! So much so that there are more than a few vendors of OLM to PST conversion software.
[Oh for those of you wondering why I didn't use the Google Apps Migration tool for Exchange (GAMME), it was because our hosted MS Exchange service only gave us limited access.]
Migrating Contacts:
In Outlook:
In Excel:
In Google Apps:
Note: if you need to edit your CSV file and re-import to Google Contacts, it's best to delete all of the contacts from Google before performing the import again. This is because Google doesn't overwrite the original contacts, but creates new contacts, which will create duplicates in most cases.
Migrating Calendar:
In Outlook:
In Calendar:
In Google Calendar:
Hope this helps someone out there!