how to import contacts from numbers to adress book
I am trying to import my contacts from Numbers/Excell to Adress Book, my question is:
How to import contacts from numbers to adress book?
Mac Pro, iOS 5.0.1, How to import contacts from numbers
Apple Event: May 7th at 7 am PT
I am trying to import my contacts from Numbers/Excell to Adress Book, my question is:
How to import contacts from numbers to adress book?
Mac Pro, iOS 5.0.1, How to import contacts from numbers
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 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
I had the same question a year later, and you answered it. Thanks!
I did follow the instructions, but as I was importing CSV file to the Address book, this is the messge I get:
"The selected file does not appear to be a valid comma separated values (csv) file or a valid tab delimited file. Choose a different file."
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 | ZIP | STATE | City | SALUT | Last | First | ADDRESS1 | ADDRESS2 | CITY | Note |
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...
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 |
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
how to import contacts from numbers to adress book