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
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

69 additional answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2017-02-07T13:42:54+00:00

    I thought it wasn't working for me either until I tried dragging-and-dropping directly over the words, "Address Book". Dragging into the general "area" of the Address Book box didn't work. 

    If you've already tried that, Robert Nero posted here before with the following solution:

    One minor change I made.  Drag and drop did not work.  I had to right mouse on VCF file and "open with" Outlook.  Done.

    Hope that helps.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-02-07T13:57:00+00:00

    The Contacts App is in your System/Applications folder (comes stock with Macs). It may already be in your dock (the lil' brown notebook icon).

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2017-02-07T19:41:02+00:00

    You have to drag in a specific address book within the sidebar, not just

    in the sidebar itself.

    I'm not aware of any limit on the number of contacts it can import.

    Corentin

    Was this answer helpful?

    0 comments
  4. Anonymous
    2017-03-16T16:51:54+00:00

    Hi,

    This is something I am trying and I have managed to get the . vcf file in the desktop.

    Could someone please tell me where exactly should I drag the .vcf to in Outlook to?

    what does the above comment mean when it says: 

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

    Outlook.

    I am sorry I don't get it and if possible do share a screen shot

    Thanks

    Was this answer helpful?

    0 comments