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?
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.]
- Go to File -> Export
- Select the "Contacts to a list (tab-delimited text)" radio button
- Note where you've saved that file
- Open Excel, then open the file you saved in the last step
- Excel will prompt you with the Text Import Wizard. Click through ensuring that Tab is the selected Delimiter.
- Unfortunately, since the export isn't perfect, it's a good idea to eyeball this list of contacts and ensure that the data appears to be in the right columns. E.g. First names appear in the First Name column, etc.
- Now save the file as a CSV file: click File -> Save As. Select Comma Separated Values (.csv) as the Format (near the top of that list), and save.
- Note where you've saved that file.
In Google Apps:
- Navigate to the Contacts section (either via Gmail) or the top navigation menu bar.
- Click the More menu (with the down-arrow next to it) and select Import…
- Use the Choose File button to select the CSV file you saved in the last section, then click Import.
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.
- Go to Outlook -> Preferences
- Click Sync Services
- Check the Calendar box and ensure that your main account is checked under "accounts to sync"
- Now close that dialog box (red circle)
- You will get a prompt titled "You have turned on Sync Services". Click OK.
- Open Calendar (used to be called iCal)
- Ensure that your calendar(s) from Outlook are there
- Right-click on the calendars you want to copy and select Export.
- Keep or change the name and click Export
In Google Calendar:
- After logging into your Google Apps account, select Calendar from the top menu
- Click the drop-down menu next to the gear icon (top right-hand corner) and select Settings
- Click the Calendars link (top left-hand corner)
- Now you either create a new calendar or import into the default one that uses your name as the title.
- Click Import Calendar
- Browse to the .ics file on your computer which you had previously saved in step #4 above. 6. Select the calendar you want to import into and click Import.
- You should see that some # of events were processed, and then see those events when you browse back to the main Calendar page.
Hope this helps someone out there!
You can sync outlook to OS X's built-in Address book and then sync the Address book with your google account.
Address Book > Google: http://osxdaily.com/2009/12/27/sync-your-mac-address-book-with-google-contacts/