Importing contacts into Address book

Discussion in 'Mac Apps and Mac App Store' started by tcamposr, Feb 23, 2007.

  1. tcamposr macrumors newbie

    Joined:
    Nov 6, 2006
    #1
    Hi;
    I have all of my contacts in a Excel document. I use that to make labels all the time, but I was wondering if it's possible to import that info into Address book. I tried with the labels in Word and couldn't import. do you know of any easy way to do this?

    Thanks

    TC
     
  2. mkrishnan Moderator emeritus

    mkrishnan

    Joined:
    Jan 9, 2004
    Location:
    Grand Rapids, MI, USA
    #2
    What you can do is export the Excel file as comma separated values (CSV -- a text file) and then get them into Address Book. It's a little tricky, but doable. See this:

    http://www.macosxhints.com/article.php?story=20050828200319417

    You can actually import the CSV straight into Ad Book, but you have to get the columns sorted correctly first. I don't think Address Book lets you *export* a CSV, which is a problem, because otherwise you could make a dummy one, use that as a template by importing it into Excel, adding your contacts to the appropriate columns, and then re-exporting the CSV.
     
  3. tcamposr thread starter macrumors newbie

    Joined:
    Nov 6, 2006
    #3
    Thanks very much! It worked. Now I have all my contacts in Address Book. all I did was to open the excel doc and save as a csv file. The rest was taken care by Address Book

    Thanks again

    TC
     

Share This Page