how to import contacts with csv file

How to import contacts from a CSV file to my Macbook PRO. Getting error: unable to import vcard as it contains invalid contact data.

MacBook Air 13″

Posted on Jan 31, 2023 6:17 AM

Reply
Question marked as Top-ranking reply

Posted on Feb 1, 2023 4:35 PM

Hey jonell83,


We'd recommend reviewing this article as it provides steps and requirements for importing a CSV file in Contacts on Mac: Import contacts into Contacts on Mac - Apple Support


"Import contacts from other file types

Note: Before you import a tab-delimited or CSV file, use a text editor (such as TextEdit) to confirm the file is formatted correctly:

  • Remove any line breaks within a contact’s information.
  • Make sure all addresses have the same number of fields. Add empty fields as needed.
  • Make sure fields are separated by a tab (in a tab-delimited file) or a comma (in a CSV file), instead of another character. Don’t include spaces before or after the tabs or commas.
  1. In the Contacts app  on your Mac, choose File > Import, select the file, change the encoding if necessary, then click Open.
  2. If you’re importing a text file, review the field labels.
    • 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 to all cards in the file. To not import the headers card, select “Ignore first card.”
    • 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.”"


Thanks!

1 reply
Question marked as Top-ranking reply

Feb 1, 2023 4:35 PM in response to jonell83

Hey jonell83,


We'd recommend reviewing this article as it provides steps and requirements for importing a CSV file in Contacts on Mac: Import contacts into Contacts on Mac - Apple Support


"Import contacts from other file types

Note: Before you import a tab-delimited or CSV file, use a text editor (such as TextEdit) to confirm the file is formatted correctly:

  • Remove any line breaks within a contact’s information.
  • Make sure all addresses have the same number of fields. Add empty fields as needed.
  • Make sure fields are separated by a tab (in a tab-delimited file) or a comma (in a CSV file), instead of another character. Don’t include spaces before or after the tabs or commas.
  1. In the Contacts app  on your Mac, choose File > Import, select the file, change the encoding if necessary, then click Open.
  2. If you’re importing a text file, review the field labels.
    • 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 to all cards in the file. To not import the headers card, select “Ignore first card.”
    • 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.”"


Thanks!

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.

how to import contacts with csv file

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