EXPORT Address Book contacts to Excel?

Discussion in 'OS X' started by flyingfishgirl, Dec 13, 2007.

  1. macrumors newbie

    Joined:
    Dec 13, 2007
    Location:
    NYC
    #1
    I currently keep all of my contacts in Address Book, and need to create mailing labels from a group of them (I already created and populated the group). If I try to "print labels" from address book, it tries to print a label for every address in the group -- so in cases where a contact has multiple addresses, it wants to print more than one. This process also won't let me edit the labels to modify names, add "Mr. & Mrs." etc.

    I want to export the group of contacts to excel, so that I can delete the fields that I don't need for this particular project and then do a mail merge between excel and word, in which I can create the labels. But Address Book and excel don't seem to want to play together.

    I downloaded Palm Desktop with the hope that I could use it as a conduit, but it won't accept the group v-card either.

    I have searched everywhere for hints, but mostly just come up with hints for importing contacts to address book, and not exporting. I hope someone can help!


    Thanks!
     
  2. macrumors member

    unknown.exe

    Joined:
    Sep 22, 2007
    Location:
    Somewhere on Earth
    #2
    Open excel and go to file > inport (i'm pretty sure that's an option on all office apps). Import your address book entries into excel... that's your best advice.:apple:
     
  3. thread starter macrumors newbie

    Joined:
    Dec 13, 2007
    Location:
    NYC
    #3
    Excel doesn't give you that option. I've tried using the "import"option in Enterouge, but it only seems to want to let me import mail or calendar files, and not contact files. Same for Palm Desktop. I also tried the Address Book to CSV exporter utility, but that didn't work.
     
  4. macrumors 603

    iSaint

    Joined:
    May 26, 2004
    Location:
    South Mississippi y'all, near the water!
    #4
    I'm not going to test it out, but there's an Export option in Address Book that allows you to create an archive. I don't think there's an option to select certain entries to export. I know other database programs such as ACT will do that for you.

    Since we only send 80 Christmas cards, and I have 1,200 contacts, I keep a spreadsheet and make changes year to year.

    BTW if you do export into a tab delimited file you can import that into Excel with ease.
     
  5. macrumors newbie

    Joined:
    Dec 14, 2007
    #5
    Mac Address Book Export

    This is easy and I do it all the time:

    http://gwenhiver.net/address-book-exporter.html

    Download that which will export your address book to a .txt file. Then simply open in Excel and your good to go!

    Hope this helps!
     
  6. macrumors newbie

    Joined:
    Aug 20, 2008
    #6
    Address book

    Thank you very much top solve:)
     
  7. macrumors newbie

    Joined:
    Sep 3, 2008
    #7
  8. macrumors newbie

    Joined:
    Sep 3, 2008
    #8
    Address Book to CSV Exporter --- not good if you want entries kelp in csv

    "Address Book to CSV Exporter 1.3a" tool I mentioned above isn't good if you would like to export contacts to a csv file and preserve it that way because the csv output isn't easy to read in spreadsheet; not sure if it works by splitting the csv to spreadsheet columns based on some separator. The tool download site says that the csv output is good for creating an export csv to later import using gmail's import functionality; however i did not try that out.
    Instead, I started using gmail to store all my contact and its csv output goes good in spreadsheet.
     
  9. macrumors newbie

    Joined:
    Jun 3, 2010
    #9
    Export Vcards into Excel from Address Book

    I searched and searched, I downloaded shareware solutions, I tried what Apple recommended on their own website, and finally found the easiest way to overcome this problem by thinking like a MAC user, not a PC user.

    Remember that Excel is made by MICROSOFT. So, use your MAC software to create what you need (for me, I needed an Excel file of my contacts as the service I use for email marketing requires this for uploading):

    1. Open Mac's Numbers software program.
    2. Open Address Book, and click on the group or selection of contacts you need exported.
    3. Drag them into an empty spreadsheet into Numbers.
    4. If needed, re-save your new Numbers file while in Excel.

    Seriously, it is that simple. NO export, NO import, NO headaches.

    NOTE TO SELF: Next time, don't think like a PC user -- think INTUITIVELY.
     
  10. macrumors newbie

    Joined:
    Oct 22, 2007
    #10
    Numbers worked great!

    MelRichBan:

    GREAT suggestion! Highlighting names in AB and dragging them straight to a Numbers spreadsheet works like a charm. And I was looking for a third-party export tool. Fah!
     
  11. macrumors newbie

    Joined:
    Jun 29, 2010
    #11
    a little help

    sounds easy, when I tried it, I highlighted the contacts (turned them blue) tried to just move them over to an empty Numbers sheet and they wouldn't take - do I need to format the numbers page in any particular way or point the mouse to a specific field. thanks from a newbie http://forums.macrumors.com/images/smilies/smile.gif
     
  12. macrumors newbie

    Joined:
    Mar 20, 2005
    #12
    Here is another option!

    I use a great system for sending out cards, postcards and even gifts! Check it out.... www.ikathie.com

    Let me know if you have any questions!
     
  13. macrumors newbie

    Joined:
    Aug 7, 2010
    #13
    Nice, but not quite there

    MelRichBan's solutions is certainly the easiest and most 'mac-like'.
    However it didn't quite work for me. When dragging a card from Address Book (v5.0.2 on OSX 10.6.4) into Numbers 09 (v2.0.3), all I got was Last Name, First Name, mobile phone, and email address.

    Does anyone know how to tweak the process to get more data? Such as the address?
    Thanks
     
  14. macrumors newbie

    Joined:
    Aug 11, 2010
    #14
    You just need to unhide hidden columns - ALL address book fields are there (more than one needs)
     
  15. macrumors newbie

    Joined:
    Sep 30, 2010
    #15
    I tried doing this and it doesn't let me drop into Numbers. The image that I'm dragging over just flies back into Address Book. Any idea why?
     
  16. Mal
    macrumors 603

    Mal

    Joined:
    Jan 6, 2002
    Location:
    Orlando
    #16
    Make sure you're dropping them directly onto the spreadsheet cells, which will highlight in blue to indicate they are the destination.

    jW
     
  17. macrumors newbie

    Joined:
    Sep 30, 2010
    #17
    I highlight the cell in Numbers, then go to AB and highlight the contacts (tried doing all at once then opted to try just one contact to see if it worked). No luck. As I drag from AB to Numbers, Numbers is in the background and it doesnt register that I want to drop....

    * I figured it out. I had to select contacts under "on my mac" as opposed to the list I was trying to use.
     
  18. Mal
    macrumors 603

    Mal

    Joined:
    Jan 6, 2002
    Location:
    Orlando
    #18
    Ok, so just tested this. When I just dropped onto a blank spreadsheet, it wanted to create a new table with the information. When I edited the column headers to First Name, Last Name, etc, then it highlighted in blue and let me drop directly onto the table without creating a new one. Both ways, however, it did pull the information from Address Book, and didn't just snap back.


    afh163, glad you figured it out, that wasn't the solution I would have suggested, so glad you saved me the trouble of being wrong, too.:cool:

    jW
     
  19. macrumors newbie

    Joined:
    Mar 31, 2004
    Location:
    Florida
    #19
    export to numbers you are brilliant!

    This is brilliant!!! KISS--keep it simple stupid we forget what we love about mac sometimes.

    Remember that Excel is made by MICROSOFT. So, use your MAC software to create what you need (for me, I needed an Excel file of my contacts as the service I use for email marketing requires this for uploading):

    1. Open Mac's Numbers software program.
    2. Open Address Book, and click on the group or selection of contacts you need exported.
    3. Drag them into an empty spreadsheet into Numbers.
    4. If needed, re-save your new Numbers file while in Excel.

    Seriously, it is that simple. NO export, NO import, NO headaches.

    NOTE TO SELF: Next time, don't think like a PC user -- think INTUITIVELY.[/QUOTE]
     
  20. macrumors newbie

    Joined:
    Jan 23, 2008
    #20
    How do you do that?

    TIA
     
  21. macrumors newbie

    Joined:
    Jul 22, 2008
    #21
    this absolutely works! Terrific.
     
  22. macrumors newbie

    Joined:
    Apr 29, 2010
    #22
    unhide columns

    In Numbers, select the Table, then under Table menu, UNHIDE all columns.

    voila!
     
  23. macrumors newbie

    Joined:
    Mar 25, 2008
    #23
    Many Thanks

    Worked like a charm. Thanks for the neat trick! You've make me look good for the boss.

    :D

     
  24. macrumors 6502

    montycat

    Joined:
    Mar 19, 2007
    Location:
    Florida
    #24
    Thanks for the info
     
  25. macrumors newbie

    Joined:
    Jan 28, 2011
    #25
    This was the BEST advice! I created a Christmas Card List of 65 names within a half hour, including formatting the Numbers page, colors, fonts, etc. Thank you so much!



     

Share This Page