14 Replies Latest reply: Feb 5, 2014 9:42 AM by Eric Root
PauloGuedes Level 1 Level 1
Whats is the structure (field names) of a CSV file that can be imported to AddressBook?

Thank You,

MacBookAir3,2, Mac OS X (10.6.5), MacBookAir3,2
  • PauloGuedes Level 1 Level 1
    I mean,

    A comprehensive list of field labels to place in the first line of a csv file, to correctly input columns of address information.

    Thank You,
  • satcomer Level 4 Level 4
    Does the Apple document Importing contacts into Address Book help at all?
  • PauloGuedes Level 1 Level 1
    No i does not help at all.
    Thank You,
  • PauloGuedes Level 1 Level 1
    This is exactly what i am looking for.

    Thank you so much,
  • varjak paw Level 10 Level 10
    No problem; it wasn't that easy to find.

    Happy to have been of help.
  • Dan Finazzo Level 1 Level 1
    I have an Excel File saved in .cvs format with the following headers

    name, address, city, state zip and phone number

    and when I try in import it directly into Address Book:

    1. it will not allow various fields to be imported
    2. imports fields in the incorrect areas
    3. Marks certain fields with Do Not Import

    It there not a simple way to tell Address Book which fields go where on an import. I believe the programmer for this product is being paid way too much or is delusional!! Dumming down this product has made simple things impossible - anyone lightening. This should not be rocket science - rant off and waiting to receive my medicine!!
  • Geniecommands Level 1 Level 1
    I think the problem with simple import these days is the extended use of XML which in my case required a label next to the imported field before Address book would import. To Developers can you please add an import type that will find wild characters except comma and tab and excluded them also it would be helpful if addressbook could import without the need to transpose.

    Had a customer ask me to import all the CC addresses from an email into Addressbook and this is what I had to do.

    1. Saved the email to desktop opened with Textedit and copied addresses.
    2. Opened Excel and selected under edit Paste Special, then in this dialog box ticked Transposed
    The End result should be the address flow downwards
    3. Now we need to clean the data select find Command+F and click the replace button
    Search for < and replace with NUL (nothing not even a space) also do this with > and with a
    space (press once on keyboard) and click the Replace All button each time it will tell you how many it replaced
    4. Click on the top of the "A" column it should highlight the whole thing then goto pull down menu Insert->Cells
    5. In box A1 Type "Email (Work)", copy this and highlight with shift all the A cells down and paste to the last email address
    6. Save as Excel .CSV file
    7. Make a new group in Addressbook and highlight before importing
  • RPJRPJ Level 1 Level 1

    Re: http://docs.info.apple.com/article.html?path=Numbers/2.0/en/lso1075f288.html


    All I get with this link is the start page for Apple Support. How do I find the article?


    Thanks. RPJ

  • Zuma Andrew Level 1 Level 1

    Same here, the link below takes me to the Apple Support Page. Could someone show us the headers for the import? Thanks!



  • varjak paw Level 10 Level 10

    Sorry, that URL was valid two years ago when I posted it. Try page 231 - 233 of the Numbers user guide:





  • Zuma Andrew Level 1 Level 1

    Thanks a lot varjak paw! These were the headers I've been looking for!!!

  • Prean Level 1 Level 1

    Hi Varjak,


    Sorry to bother you again with this but i have a list of contacts in CSV file format and domnt know how to import it into my contacts list on my macbook pro.


    Id really appreciate your help.





  • Eric Root Level 9 Level 9
    Mac OS X

    Contacts help:


    Import contacts from other file types


    Import contact information 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, make sure it’s formatted correctly using a text editor such as TextEdit.
      • Remove any line breaks within a contact’s information.
      • 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, then click Open.
    3. 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.”


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

    Custom fields aren’t imported.

    To review duplicate contact cards during an import, see: