Bulk Import Into Address Book

Question

Level 4

3,070 points

Bulk Import Into Address Book

Hi all

I need to create a long list of addresses and then be able to import them into Address Book, where all the details will go into the correct field, so the Address goes into the address section etc and any phone numbers too.

Does anyone know how this is done? There is an import feature in Address Book but I haven't got it to work so far,

any thoughts?

Mark

Quicksilver G4 2002, Mac OS X (10.4.4), iPod, iSight, LaCie 19" Blue III Monitor, LaCie 160Gb External Drive, JBL's

Posted on Feb 26, 2006 4:46 AM

Reply

Answer 1

bronson

Level 2

282 points

Feb 26, 2006 5:00 AM in response to Mark Jones

I do this a lot. I create a CSV file in Excel and it imports right in.

How have you been trying to import the data? What format was the file?

I think it will accept a CSV (comma separated value) or a TXT (tab separated) file.

Give one of those a try.

HTH

Bronson

Reply

Answer 2

Mark Jones Author

Level 4

3,070 points

Feb 26, 2006 5:31 AM in response to bronson

Yes but how are they formatted no matter what I do it does not work.

Thanks for the help

Mark

Reply

Answer 3

bronson

Level 2

282 points

Feb 26, 2006 9:06 AM in response to Mark Jones

Well, a CSV file is formatted with commas. Something like this:

FirstName,LastName,Address,City,State,Zip,Email,Phone,etc,etc

You can have as many or little fields as you like. It depends on your needs. The fields don't have to be in any particular order or anything. Once you begin the import process, you are able to map what fields of the CSV file link to the corresponding field in the Address Book.

Here's a sample one to work from:

John,Doe,no@email.com
Jane,Doe,not@email.com

Copy and paste the above into a text file and name it "text.csv". Then try to import that into Address Book.

Good luck. Let me know if you have any problems.

--
Bronson

Reply

Answer 4

Mark Jones Author

Level 4

3,070 points

Feb 26, 2006 9:15 AM in response to bronson

Well I got that to work, but I now need it to go into a certain group in my Address Book.

Thanks for the help, much appreciated, as you can guess I don't do much with Address Book except put in contacts when I need them, I need to put them in bulk now for various reasons.

Mark

Reply

Answer 5

bronson

Level 2

282 points

Feb 26, 2006 11:35 AM in response to Mark Jones

As far as Groups are concerned, I don't think there is a way to import into a specific Group. I think you must create those manually.

I'm glad you got your contacts imported though.

--
Bronson

Reply

Answer 6

Mark Jones Author

Level 4

3,070 points

Feb 26, 2006 1:01 PM in response to bronson

Under the 'Last Import' section I dragged the imported contacts to the Group I created.

Thanks.

Mark

Reply