IMPORTING CONTACTS INTO OUTLOOK 2016 FROM AN EXCEL FILE ARCHIVE

Select Outlook for Windows archive file (.pst or.

IMPORTING CONTACTS INTO OUTLOOK 2016 FROM AN EXCEL FILE FOR MAC

Open your Outlook for Mac and click on the File > Import.

The vCard will get open in the Contacts window.

Open this mail on your Mac Outlook and click on the attached Card.

Compose a new email, attach the converted vCard to it and send it to your Mac Outlook email address.

Now, you are ready to import this output file to Mac Outlook to proceed import contacts from Excel to Outlook for Mac and below are the instructions for the same: Import vCard to Mac Outlook

All the Excel file contacts will get converted into vCard / PST (whatever selected) file formatДЄnother interesting read: Syncing Google Contacts With Outlook.

Browse a destination location for the output file and hit the Convert button to start import Excel Contacts to Outlook Mac process

After customizing your resultant file format, map Excel File Contact Fields with vCard / PST Columns manually or automatically.

vCard Type: As you are going to import this vCard further to Mac Outlook so it is suggested to choose Mac vCard.

You may select any of these versions (v3.0 or v4.0 is recommended) as Mac Outlook supports all these vCard versions.

IMPORTING CONTACTS INTO OUTLOOK 2016 FROM AN EXCEL FILE SOFTWARE

vCard Version: The software will allow you to export Excel File Contacts into vCard v2.1, v3.0, and v4.0.

In case you will leave this unchecked, then all the added Excel Contact Files will be exported into a single vCard file.

Create Single vCard Per File: In case if you have added multiple Excel Contact Files then, choosing this option will create separate VCF files for each Excel file added.

Selecting the VCF file format will give you the following customization options:

Now, you can select PST or VCF as an export option because you can import both file types to Mac Outlook.

Add this file to the software and click Next to proceed import Excel Contacts to Outlook Mac

Click on Add File(s) button and navigate to the location where your Excel Contact File is saved.

Once done, with the conversion, follow the same set of instructions given here to import contacts from the converted vCard to Mac Outlook.

IMPORTING CONTACTS INTO OUTLOOK 2016 FROM AN EXCEL FILE DOWNLOAD

Tip: In case if you are using Windows computer to perform the Excel file conversion, then it is suggested to download Excel2vCard Converterfor Windows and convert the Excel Contacts file into vCard.

The first thing you have to do is download Excel File Converter on your Mac computer and then launch it.

Since there is no direct option provided by Mac Outlook to import contacts from Excel file directly so, what we have to do is, first make this Excel file Mac Outlook compatible and then, import the converted file into Mac Outlook address book to execute import contacts from Excel to Outlook for Mac process. Then select XLS / XLSX / XLSM file format and save it. If it is not then, open this file in MS Excel and click on File > Save As.

Make sure your Excel contact file extension is.

For example, Name, Contact, Address, Business, Department, etc.

The Excel file must be formatted correctly and the first line of Excel Contact File should be labeled with contact field names.

If you have exported the Excel contact file from some email client or platform like Google Contacts, Windows Outlook, Mozilla Thunderbird, etc., then make sure this Excel file is opening correctly and is not corrupted.

Before initiating import contacts from Excel to Outlook for Mac process, there are a few things you have to keep in mind:

Importing contacts into outlook 2016 from an excel file