

Replacing duplicates deletes existing contacts, if Outlook finds a match for the contact's name (or some other field, as explained in the section about mapping, below). Under Options, choose whether to replace duplicates (existing contacts), create duplicate contacts, or not import duplicates.


This starts the Import and Export Wizard.Ĭhoose Import from another program or file and click Next.Ĭhoose Comma Separated Values and click Next.Ĭlick Browse and locate the saved CSV file. In Outlook, click File > Open & Export > Import/Export. Now, you can start the import process in Outlook. xlsx file) closes, but no changes are made to it. When Excel tells you "Some features in your workbook might be lost", click Yes to save the current worksheet as a CSV file. The message refers to a limitation of the CSV file nothing will happen to your original workbook (the. If Excel tells you "The selected file type does not contain workbooks that contain multiple sheets," click OK. In the Save as type box, choose CSV (MS-DOS) (*.csv), give it a file name, and click Save. In your workbook, click the worksheet with the contact information you want to import.

Outlook can't import workbooks with multiple sheets, but it can import comma-separated value (.csv) files. Step 1: Save your contact information from Excel in a file that Outlook can import Map the Excel spreadsheet columns to the appropriate Outlook fields. Get your contact data ready to be imported. But, you can do it by following these four steps: Unfortunately, Outlook can't automatically create a contact group from a list of contacts in Excel. With a contact group, you can send emails and meeting invitations to people without having to add each name every time. Then you can create a contact group (formerly called a "distribution list") using the imported contact information. To make suggestions, UserVoice is your best friend in this case or through the “Contact Support” button located in the upper right hand corner in the Outlook 2016 for Mac client as shown here.If you have a lot of business or personal contacts that you keep in an Excel spreadsheet, you can import them straight into Outlook.
#Outlook for mac 2016 contact groups windows
Recently announced, hot off the press, Office 365 Groups are coming to Outlook 2016 for Mac! More about this and what the scope of this release is yonder on the Outlook for Mac Insights blog on 2 March 2017 titled “ Support for Groups in Outlook for Mac.”Ĭaveat, this is by way of the Insider builds fast ring at the moment, so if you’re a corporate user and you’re wondering where this is, give it sometime and keep on accessing groups through either a Windows VM in your favorite hypervisor on Mac (whether that be Parallels, VirtualBox or VMWare Fusion) or through Safari / Chrome / Firefox.
