Here’s the smarter working way I do it with Microsoft Outlook. Choose Preview of all the given options to import contacts from excel to Outlook Mac. Now, a list of options will be displayed. Open the email received in your Outlook Mac account right click on the attached file. In the database or spreadsheet program, export the contacts data to a CSV (comma separated values) file.Make sure the columns have meaningful headers, though they don't need to correspond precisely to the fields used in the Outlook address book. Import Contacts from a CSV File Into Outlook. How To Copy Email Addresses From Excel To Outlook.How To Copy Email Addresses From Excel Into Outlook For Mac Shortcut.