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.
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
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.
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...
Prefix Last name First name Suffix Nickname Maiden name Job title Department Company Phone Main phone Work phone Home phone Mobile Home fax Work fax Pager Other phone Work email Home email Other email URL Work URL Home URL Other URL Birthday AIM Work AIM Home AIM Other AIM Yahoo Work Yahoo Home Yahoo Other Yahoo Jabber Work Jabber Home Jabber Other Jabber Address Street address City State ZIP Country Work Address Work street address Work city Work state Work ZIP Work country Home Address Home street address Home city Home state Home ZIP Home country Other Address Other street address Other city Other state Other ZIP Other country Note Image
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.