Mac Outlook 2016 - Import Contacts

Anonymous
2015-11-07T08:24:58+00:00

I can't find a straightforward answer on this, so hoping you can help. I want to import a list of contacts in Excel (Mac 2016) into my Outlook (Mac 2016) contacts list. This used to be easy, but I cannot find the functions to do this now. Is this another functionality Microsoft has stripped from Mac Office or is there a way to do it?

Many thanks

Outlook | MacOS | Legacy Outlook for Mac | For business

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
Answer accepted by question author
Anonymous
2015-11-09T15:08:29+00:00

You can't import it straight into Outlook, but there is a way around this:

• Export from Excel to a csv file.

• Import the csv file into the System Contact app (it should be fairly

straightforward, especially if all fields are properly labeled).

• Select all contacts there and drag them to the desktop to create a .vcf

• drag the .vcf into the address book where you want them imported in

Outlook.

That should do the trick.

Corentin

Was this answer helpful?

200+ people found this answer helpful.
0 comments No comments

69 additional answers

Sort by: Newest
  1. Anonymous
    2015-11-24T05:04:29+00:00

    You should be able to drop the vcf into your Outlook. I was able to select all of my .vcf files (i saved them out of Entourage) and dragged them directly on top of the words "Address Book" in the left column of the "People" section of Outlook. Have you tried that yet?

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2015-11-24T04:32:45+00:00

    You can't import it straight into Outlook, but there is a way around this:

    • Export from Excel to a csv file.

    • Import the csv file into the System Contact app (it should be fairly

    straightforward, especially if all fields are properly labeled).

    • Select all contacts there and drag them to the desktop to create a .vcf

    • drag the .vcf into the address book where you want them imported in

    Outlook.

    That should do the trick.

    Corentin

    what is or where do you find the system contact app that you referred to? i have a csv file but i've not succeeded in getting them into my contacts in Outlook 2016 for Mac. 

    not sure how to convert cvs files into vcf. although i do have a vcf file that i've imported into Apple contacts but it doesn't seem to work with Outlook either.

    very frustrating especially for a technologically challenged person.

    Gary

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2015-11-09T20:11:00+00:00

    Not a problem. I'm glad it worked 9and yea, I agree, the whole process

    should have been made a LOT easier).

    Corentin

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2015-11-09T19:10:22+00:00

    Whew. Thanks for the quick reply. It did work!

    I was dragging the .vcf files into the "empty" column where Contacts should appear, which wasn't working.

    Then I tried dragging the .vcf files into the very far left column directly onto the toggled "checkbox" labeled "Address Book." All of my .vcf files appeared and worked.

    In my case, I was using Entourage and needed to move my contacts list to the new Outlook for Mac 2016. The new Outlook doesn't support importing in traditional methods. So, in summary...

    • From Entourage, I clicked "Address Book" to view all of my contacts, selected all and dragged them to a folder on my desktop (this gives you a .vcf for all contacts).

    • I then opened Outlook for Mac 2016 and clicked the "People" tab (which appeared in the bottom of my Outlook window).

    • The column Correntin noted is at the very far left with a title of "Address Book" next to a toggled checkbox.

    • From the finder I selected all of the .vcf files (that were exported from Entourage) and dragged them directly on top of the words "Address Book".

    This worked and tested out for me!

    Thanks for hanging in there Correntin. I really appreciate it.

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments No comments