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: Newest
Most helpful Newest Oldest
  1. Anonymous
    2018-04-28T21:31:55+00:00

    So I have also had this problem for a long time, without success in figuring it out even with some "solutions" published in blogs like this...UNTIL TODAY!  This finally worked for me.

    THIS IS A METHOD TO IMPORT YOUR CONTACTS FROM YOUR MAC INTO YOUR CONTACTS IN MICROSOFT OUTLOOK FOR MAC.

    Sometimes the way you have your settings selected can change the icons and arrangement of items in your Outlook, but I'll give you the way it looks to me (Version 16.12, today's date 28 APR 2018):

    • open Outlook
    • click on your Contacts in Outlook ("people" icon)
    • you're now in Outlook Contacts; select the HOME tab at the top
    • on the far right under a search window, click on the ADDRESS BOOK icon
    • a new "Search People" dialogue box opens
    • leave the search window blank
    • select "search names only" in
    • in the next box, instead of "All Folders" open it up and select "ADDRESS BOOK"
    • now your contacts should appear...select any one of them
    • now, to get them all selected, click your keyboard COMMAND key and "A" key at the same time
    • now MINIMIZE this Address Book window to get it out of the way
    • now, back in Outlook, still in the Contacts section, click on the TOOLS tab
    • now click "EXPORT"
    • in the box that opens, UNSELECT all boxes EXCEPT "Contacts"
    • click CONTINUE
    • now select the .OLM option and save it to your desktop
    • click FINISH
    • it it ok now to close the previously minimized search window, or just leave it minimized
    • now, going back to the TOOLS tab in Outlook, now click the IMPORT button
    • select the .OLM option, then CONTINUE
    • now find the file you just saved to your desktop and click IMPORT
    • then, FINISH
    • now, put a check mark next to the correct ADDRESS BOOK from any being shown and UNSELECT any other, old options, that may be selected

    Hopefully, this does it for you.  It did for me.

    ~TD

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-04-10T19:30:44+00:00

    Hi Cortig- where do I find the System Contact app?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2018-03-16T21:59:36+00:00

    I created the VCF file from iCloud and put it on my desktop.

    I then right-clicked on the file, selected Open With---> Microsoft Outlook and all the contacts appeared in my default address book.  I'm using 2016.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-02-22T09:49:40+00:00

    I want to maintain a SINGLE master list of contacts, preferably Google contacts, that are drawn on by Microsoft and automatically reflect my updates. This works with Apple contacts, but Microsoft is not yet to first base.

    Was this answer helpful?

    0 comments