How to Import Excel Contacts to Apple Address Book

Apple Mail is the default email application in Mac OS X's. In Mac Operating System, Apple Address Book is also available which appear as general contact manager but it's capable of so much more. Apple Address book is basically a central repository of information which can be accessed and used by multiple applications. So for any communication, internally or externally the most required thing is contacts.

MS Excel is very popular among users for managing contact information as it maintains the data in tabular format. So, if you have your contacts information's like email address, home address, contact number, website etc. managed in Excel sheet and now want to import all contacts from Excel spreadsheet into Apple Address book then follow the below mentioned steps.

How to Export Contacts from Excel to VCF File?

Check here complete guide of exporting contacts from Excel sheet into vCard file format so that VCF file could be further imported into Apple mail.

  • Now mapping of Excel fields with vCard field has to be done, after mapping each field click on "Add", after field mapping is done, click on "Next"

    map excel sheer fields with vcard fields

  • Before starting conversion process, select these 2 options

    • Select "Single vCard for all contacts" option
    • Choose "Allow empty email address" option

    select options to save csv contacts of excel to vcf and import it into apple address book

    By default software creates, separate VCF file for each contacts

  • Now, all contact information from Excel sheet is exported into VCF file, now we will discuss the further steps to import the vCard file into Apple Address Book.

How to Import VCF File into Apple Address Book?

  • In your Mac desktop, click on "Mail" icon to open Apple Mail

    open apple mail in mac machine

  • Now, Click on "Contacts" icon to open Contact Address Book

    open apple mail address book

  • Click on "File" and from drop down menu select "Import option"
  • Select VCF file from desktop and click on "Open"

    select vcf file to open it in apple contacts

  • A pop-up window will appear asking you to click on "Add" option

    click on add option to import all contacts of excel file into apple contacts book

  • Contacts are successfully imported into Apple Address Book; you can scroll them to check the contact details which are showing in the right panel.

    all contacts are copied from excel sheet into apple mail address book

The process of importing contacts from Excel sheet into Apple Address book is accomplished. Now you can easily access all your contacts into Apple mail which were previously stored in Excel sheet.