We are renaming this post to focus on “Import and export of contacts” in Outlook. For MBOX and PST formats, please vote for separate posts.
An error occurred while saving the commentWilliam Carrelli commented
Allow user to cut and paste a list of email addresses in an Excel spreadsheet into Outlook to create a new Contact List. This functionality exists on Outlook for Windows but does not for Outlook for Mac. There is not an easy way to create a New Contact list from a large number of email addresses. In Outlook for Windows this is a simple cut and paste operation from Excel Column into Outlook. This cannot be done in Mac so you need to enter each email address manually.