Importing Outlook Contacts to Apple Contacts

Thank you in advance.


I'm trying to import my outlook.com contacts to my apple contacts on my brand new iMac and when I try this with a csv file I get a popup window that says 'can't read file.' This is what I'm doing:


1. From outlook.com I can export my contacts to my desktop as a csv file of my contacts (which I can open in Excel for Mac or Numbers) (outlook.com will only export this type of file).


2. When I try to import the outlook csv file my Apple contacts say's cannot read.


3. I can open the csv file in excel or numbers and convert it to there to other file types, but no luck with those so far.


4. Has to be a way!

Powerbook, Mac OS X (10.4.8), Contacts

Posted on May 21, 2016 1:16 AM

Reply
Question marked as Top-ranking reply

Posted on Jul 15, 2017 6:44 PM

G'day Mate,


I am a MS Exchange Administrator and I am able to perform this without using any third party software which are not trusted and may compromise your security and privacy if not careful.

Follow the steps and this will be like a cakewalk.

1. Export the contacts file in CSV format. Use Microsoft article below.

Import contacts to Outlook - Office Support


2. After saving that .csv file open Google contacts. Link is below.

https://contacts.google.com/


Please note google will prompt you to go old version of Google contacts Say YES

https://www.google.com/contacts/u/0/?cplus=0#contacts



3. After opening google contacts click on Import Contacts on left and browsing your saved .csv file.

4. All your .csv contacts will now be imported to your google contacts.

( I believe 99% of world has google account but still if you are in that 1% please create one, This won't make you hate Apple 🙂)


5. This step is optional but you can merge and duplicate you google contacts by clicking the check box (tick) to select all contacts
then More > clicking merge and duplicate tabs.

6. Now in Google Contacts you can click the check box(tick) to select all contacts and then More > Export > vCard Format. This will save file in Apple vCard Format.

7. Open Apple iCloud contacts iCloud — Sign in

8. In iCloud Contacts Click Actions menu with (the Gear Symbol) on the left bottom side and Import vCard.

9. Browse the file you downloaded from Google Contacts and you are done!

ALL YOUR CONTACTS WILL APPEAR IN ICLOUD AND SYNC TO YOUR IPHONE 😀

18 replies

May 22, 2016 9:11 AM in response to HamRadioElijah

Solution found (for a mac anyway)!


1. Download a csv file from outlook.com onto your desktop.


2. Sign into your Google account (or sign up for one).


3. In your suite of Google apps open 'sheets' (which is like excel or numbers).


4. Import your csv file to Google sheets and name the file.


5. Now export that sheet from Google to your desktop in vcard format.


6. Now import into Apple contacts, etc. Worked seamlessly for me...I was amazed myself.


Biggest Apple fan ever, but maybe I should buy some Google stock as well 🙂

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Importing Outlook Contacts to Apple Contacts

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.