Mac Outlook 2016 - Import Contacts

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

 

Question Info


Last updated October 17, 2019 Views 46,627 Applies to:
Answer
Answer
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
 

I do *not* work for MS
Je ne travaille *pas* pour MS

188 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.