1 2 Previous Next 18 Replies Latest reply: Dec 14, 2013 11:49 AM by Jerrold Green1
pstefoglo Level 1 Level 1 (0 points)

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
  • 1. Re: how to import contacts from numbers to adress book
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    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

  • 2. Re: how to import contacts from numbers to adress book
    Level 8 Level 8 (41,760 points)

    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

  • 3. Re: how to import contacts from numbers to adress book
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    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

  • 4. Re: how to import contacts from numbers to adress book
    Wayne Contello Level 6 Level 6 (13,620 points)

    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

  • 5. Re: how to import contacts from numbers to adress book
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    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

  • 6. Re: how to import contacts from numbers to adress book
    Wayne Contello Level 6 Level 6 (13,620 points)

    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.:

    Screen Shot 2013-02-09 at 9.14.59 AM.png

  • 7. Re: how to import contacts from numbers to adress book
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    Here's what I get.

     

    Jerry

  • 8. Re: how to import contacts from numbers to adress book
    TipToeTippy Level 1 Level 1 (0 points)

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

  • 9. Re: how to import contacts from numbers to adress book
    pstefoglo Level 1 Level 1 (0 points)

    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."

  • 10. Re: how to import contacts from numbers to adress book
    dophile Level 1 Level 1 (0 points)

    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

  • 11. Re: how to import contacts from numbers to adress book
    Jerrold Green1 Level 7 Level 7 (28,995 points)

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

     

    Jerry

  • 12. Re: how to import contacts from numbers to adress book
    dophile Level 1 Level 1 (0 points)

    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

  • 13. Re: how to import contacts from numbers to adress book
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    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...

     

    PrefixLast nameFirst nameSuffixNicknameMaiden nameJob titleDepartmentCompanyPhoneMain phoneWork phoneHome phoneMobileHome faxWork faxPagerOther phoneEmailWork emailHome emailOther emailURLWork URLHome URLOther URLBirthdayAIMWork AIMHome AIMOther AIMYahooWork YahooHome YahooOther YahooJabberWork JabberHome JabberOther JabberAddressStreet addressCityStateZIPCountryWork AddressWork street addressWork cityWork stateWork ZIPWork countryHome AddressHome street addressHome cityHome stateHome ZIPHome countryOther AddressOther street addressOther cityOther stateOther ZIPOther countryNoteImage

     

    Jerry

  • 14. Re: how to import contacts from numbers to adress book
    dophile Level 1 Level 1 (0 points)

    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

1 2 Previous Next