Can I import contacts from an Excel csv file?

I have a large number of email addresses to import to set uo an email system for my organization group. I can do so within Google gmail by using an Excel csv file. Is that possible within Mail?

iMac G5 (17-inch Ambient Light Sensor), Mac OS X (10.7.3)

Posted on Jan 27, 2016 10:14 AM

Reply
1 reply

Jan 28, 2016 10:29 AM in response to Ann Shore

Hello Ann,



While Mail itself doesn't handle contacts in such a manner, the Contacts app does support importing from a CSV file. Once imported into the Contacts app (either locally or to a CardDAV service like iCloud), those addresses can be accessed via Mail.

You can import contact information that you saved or exported from other apps. The files can be in LDAP Interchange Format (LDIF) or text format (tab-delimited or comma-separated value (CSV)).

  1. If you’re importing a tab-delimited or CSV file, verify it using a text editor such as TextEdit.
    • Remove any line breaks within a contact’s information. Line breaks can cause the import to fail.

    • Make sure that fields in a tab-delimited file are separated by a tab, instead of by another character. Don’t include spaces before or after tabs.

    • Make sure that fields in a CSV file are separated by a comma, instead of by another character. Don’t include spaces before or after commas.

    • Make sure all addresses have the same number of fields. Add empty fields as needed.

  2. In Contacts, choose File > Import, select the file, change the encoding if necessary, and then click Open.
  3. If you’re importing a text file, review the field labels. You can change field labels, or ignore or not import fields.
    • If the first card contains headers, make sure the headers are correctly labeled or marked “Do not import.” Any changes you make to this card are made in all of the cards in the file. To not import the headers card, select the “Ignore first card” checkbox.

    • To change a label, click the arrows next to the label and choose a new label. If you don’t want to import a field, choose “Do not import.”

If a contact has custom fields, the information in the fields isn’t imported.

When you import contacts into an Exchange account, information that isn’t supported in Contacts is added to the Notes field.

If you import a duplicate contact card, Contacts asks if you want to review the cards. For more information, see this Contacts help topic:

Resolve duplicate contact cards when importing contacts

Contacts: Export and import your contacts
https://support.apple.com/kb/ph11586



Sincerely

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Can I import contacts from an Excel csv file?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.