4 Replies Latest reply: Dec 10, 2008 6:42 AM by Farkdan
Farkdan Level 1 Level 1 (0 points)
I want to create a CSV file to import a large number of contacts into Address Book. I do not know what order the fields are supposed to be in. Does anybody know where I can find a CSV template to use to import these contacts into Address Book?

Thanks,
Dan

MacBook Pro, Mac OS X (10.5.5)
  • 1. Re: Address Book -  CSV Import Template?
    Mulder Level 6 Level 6 (8,980 points)
    What program are the contacts coming from? Can't you just export them as a vCard file and then import them into Address Book?

    Mulder
  • 2. Re: Address Book -  CSV Import Template?
    Farkdan Level 1 Level 1 (0 points)
    They are coming from text files and printed sources and there is no really easy way to do them as Vcards. I know Address Book allows you to import CSV files so I just need a template or even to know what order the fields go in to make a file to import.
  • 3. Re: Address Book -  CSV Import Template?
    Mulder Level 6 Level 6 (8,980 points)
    I can't tell you what order they go in, but generally speaking, you would use the typical First Name, Last Name, etc order of things. If you take the record with the most amount of data and put that in a text file named 'test.csv' and import it without any field names, Address Book will show you a screen where you can choose which field names you want those pieces of data assigned to, and from that you can create the field names in your actual CSV file and then import it.

    Keep in mind that CSV has a very specific syntax it's expecting, so if you don't conform you data to it, you won't get the results you want. You can read it here: CSV Syntax

    Mulder
  • 4. Re: Address Book -  CSV Import Template?
    Farkdan Level 1 Level 1 (0 points)
    Thanks Mulder! You are correct that the AB program lets me assign the fields when I do the import.