how to import contacts from numbers to adress book

Hi Pstefogo,

This is a bit involved, but the steps are simple.

Begin by dragging a contact from your AddressBook to a Numbers Blank Sheet. This establishes a table with the proper format for the import that you will do later.

Select the new table and hover over one of the column labels. Click the little triangle on the right side of the label and select Unhide All Columns.

Now you must copy/paste your source Numbers or Excel data into this new numbers table. You might have to do it one column at a time, or you could rearrange your source table to exactly match the new table before copying, and thus be able to move it all at once.

Once you have transferred the contact data to the new table, Export as CSV, which is the format that AddressBook wants to see on Import.

Go into AddressBook and select File > Import and select the CSV file that you just saved and import it.

Regards,

Jerry

Hi Jerry

I don't know which settings are used by the OP.

Here in France, the described scheme, which is the official one, give bad results.

I guess that it's due to the fact that AddressBook requires a CSV using commas to separate values when Numbers build files using semi-colons.

But it's not the sole oddity.

I replaced the semi-colons by commas and the result is always odd.

Maybe it's due to the fact that field names aren't localized the same way in AddressBook and Numbers.

This is why I posted a script fitting the gap some months ago.

Yvan KOENIG (VALLAURIS, France) vendredi 13 janvier 2012

iMac 21”5, i7, 2.8 GHz, 12 Gbytes, 1 Tbytes, mac OS X 10.6.8 and 10.7.2

My iDisk is : http://public.me.com/koenigyvan

Yvan,

I forgot about your script, and I have no idea what country the OP is writing from. Hopefully he will ask for further help if he has troubles.

Jerry

Jerry,

I was trying answer another question and seem unable in Mac OX X (10.8.2) to drag multiple addresses from "Contacts" to a blank Numbers sheet. Can you confirm that this is (or is not) possible?

Wayne

Wayne,

I just confirmed that it is possible to drag multiple contact selection to Numbers under 10.8.2. Also possible to drag a Group.

Jerry

Wierd. When I drag a contact card from the application "Contacts" to a blank sheet in Numbers the cursor changes to a card icon but when I release the mouse button the contact floats back to the application "Contacts" without depositing any information in the Numbers sheet.:

Here's what I get.

Jerry

I had the same question a year later, and you answered it. Thanks!

I am having the same problem. Dragging a contact into a blank numbers sheet doesn't deposit any information into the blank nubers sheet. I am using OS10.9 Mavericks on a brand new Mac.

ET

iWork '13 has not adopted iWork '09's drag and drop import of contacts.

Jerry

So how do I get the column headings right? My spreadsheet, which I imported from Access on my PC to Excel, then on a thumb drive to my Mac, opened in Excel for Mac, then copied and pasted into a Numbers spreadsheet, has headings that don't match with those in Address Book. Not sure how to change them to match address book. The headings are:

Xmas has Christmas or General in it to designate which people get religious or secular cards. I added Note in order to put Xmas Card in it. That way after importing into address book, I can use a smart group. Address1 has apartment numbers, etc. Address 2 has the main street address. SALUT comtains things such as "Mr. & Ms." or "Dr. & Ms" or "The Doctors" or "Mr." etc. I really would like all of these items imported into address book so I can use it's label function.

I would appreciate any suggestions.

Dophile

OS10.9 Mavericks

Contacts doesn't like missing fields, even ones that you didn't use, and it doesn't like custom fields, on import.

Here are the fields that you needed the last time I tried this. The ones you aren't using you don't need to worry about, just leave the data rows blank in those columns...

Jerry

Thanks. This is helpful! Do you know if there is any way I can map the fields from my current spreadsheet to the new one? Or do I have to copy and paste each column separately?

I have to say that this is really frustrating. I thought Mac was supposed to be easy and intuitive. So far, in changing from a PC to my new Mac, I have found things difficult, laborious, and very non-intuitive.

Dophile

Dophile,

I would bite the bullet once and be done with it. Copy and Paste the columns you use to the new table with all the columns, then Hide the ones you don't use and go on from there.

Jerry