Export contacts from outlook mac 2011 to Gmail/Apple's address book

Question

Level 1

0 points

Export contacts from outlook mac 2011 to Gmail/Apple's address book

Hi!

Does anybody know how can I export contacts from outlook for mac, to gmail or Apples Address Book?

I have my contacts attached to the computer, not to any mail account inside outlook. I´d like them to sync with my iphone and iPad.

I tried changing the database identity, I tried exporting as txt then importing them (but it messes up the fields). I tried importing them to thunderbird and export from thunderbird as .csv, but it does´t work either. I tried importing to gmail in anyway possible but it imports the data as a note, not in the proper fields. I know I can export the contacts one by one as Vcards and then import to Apple's address book but there must be a faster way.

Thanks!!

MacBook Pro with Retina display, OS X Yosemite (10.10.3)

Posted on Apr 24, 2015 5:01 AM

Reply

Answer 1

Csound1

Level 9

60,063 points

Apr 24, 2015 5:06 AM in response to macsonrisas

Outlook can export them as a .csv file, Google can import .csv files. That's the method.

Reply

Answer 2

macsonrisas Author

Level 1

0 points

Apr 24, 2015 5:09 AM in response to Csound1

Hi!

I tried that but:

1.- Outlook 2011 for mac, at least in my case, can only export them as a txt or as .olm.

2.- When I export them as a txt and then import to excel to export them as a .csv, in gmail, it imports the data as a note, doesn´t respect the fields.

Thanks anyway.

Reply

Answer 3

Csound1

Level 9

60,063 points

Apr 24, 2015 5:13 AM in response to macsonrisas

Then export as text and convert to csv, learn how to use Excel's import function, this is very easy for it. Open the import wizard and set the delimiters to match the file.

Reply

Answer 4

macsonrisas Author

Level 1

0 points

Apr 24, 2015 5:29 AM in response to Csound1

Ok, thanks.

I can import them to Apple's Address book, but Gmail keeps importing them as a note, not respecting the fields.

Any ideas?

Thanks again!!!

Reply

Answer 5

Csound1

Level 9

60,063 points

Apr 24, 2015 5:35 AM in response to macsonrisas

I am not sure I understand what you are saying, import them into the Gmail account using Gmail OR Apple Contacts, not both.

Do you have your Gmail account setup on your Mac, and are Contacts switched on?

Reply

Answer 6

macsonrisas Author

Level 1

0 points

Apr 24, 2015 5:44 AM in response to Csound1

I know 🙂.

The problem is that I have my contacts on Outlook but they are not related to any mail account. I want to synchronize outlook's contacts with my iphone and iPad and I´m trying different things.

And I don't know why Outlook doesn't sync with Apple's address book even I tried changing my outlook identity and doing everything I found on google, so I was wondering if I could have them all synchronized using a Gmail account.

Reply

Answer 7

Csound1

Level 9

60,063 points

Apr 24, 2015 6:53 AM in response to macsonrisas

I have already told you how, import them into the Gmail account in Contacts on your Mac. They will also be on the Gmail website and any other client connected to the same account.

Reply

Answer 8

macsonrisas Author

Level 1

0 points

Apr 24, 2015 6:59 AM in response to Csound1

I,ve done it. Now that I have them in Gmail, I have them in Apple's Address book and I can have then on my iPhone and iPad. That's ok.

But, my concern is: ¿How to synchronize them with outlook for mac? When I update a contact on Outlook, I also have to do it anywhere else.I have everything else synchronized, but I have Outlook by its own. Because as far as I know, Outlook doesn´t support online sync. So I´m afraid I´ll have to use Mail instead of Outlook in order to have everything synchronized.

Reply

Answer 9

Csound1

Level 9

60,063 points

Apr 24, 2015 7:32 AM in response to macsonrisas

Outlook is no longer compatible with Googles online services, either use MS Exchange (and forget about Gmail) or use Gmail and forget about Outlook.

Outlook ONLY supports Exchange for online sync.

Reply

Answer 10

BuzzWDC

Level 1

0 points

Jan 25, 2016 10:03 AM in response to macsonrisas

GOOGLE Contacts Import - Importing from OutlookMac 2011

In Outlook Mac select single or multiple contacts and drag to desktop. They will be in .vcf format (a type of vCard). Then go to an Online vCard Converter - such as http://www.unc.edu/vtoc/index.php

This will convert files to CSV format which GOOGLE Contacts can import. (This is done one contact at a time.)

In GOOGLE Contacts go to left column and select More > Import. In the new window select CSV. In next window select GO TO OLD CONTACTS. This open contacts in another GOOGLE Contacts format (?!) that has a "More" box in top bar above contact names. Select More > Import from dropdown box. In the new window select a CSV file to import. Voila! It will appear in GOOGLE Contacts. Remember to modify each contact's Group name.

Reply