Need app to convert Vcards to Excel

Discussion in 'Mac Apps and Mac App Store' started by tuckerdogavl, Jul 5, 2009.

  1. tuckerdogavl macrumors newbie

    tuckerdogavl

    Joined:
    Jan 13, 2009
    #1
    There was a thread about a year ago where the person was asking exactly what I need to do, but it just died.

    I have an address book-created VCARD list that I need to get into some form of comma delimited or Excel.

    I have not touched WINDOWS in 9 years so please don't suggest anything that has anything to do with Windows. I am a MAC user.

    Being forced to use OFFICE in this Word/Excel/powerpoint world I attempted to do something through Entourage.

    After I wasted an hour with that, I posted this on this forum.

    If anyone knows of any program that will allow you to create an address list so a MAC user who has created vCARDS in address book can share with Excel users, let me know. I appreciate it.
     
  2. tuckerdogavl thread starter macrumors newbie

    tuckerdogavl

    Joined:
    Jan 13, 2009
    #3
    yes, did that

    Prior to your response, I had found this, and I spent about 45 mins on this site trying to find the MAC apps that are supposedly there if you type in MAC apps but all you get is WINDOWS apps. Which is usual. And if you try to "search" anything specific you just get this page of 45,345 WINDOWS apps. So, this was no help.

    I did find a program after about an hour called Address Book export.app but it was very squirrelly. It seems to be very close to what I need, but I'm not lovin' it yet.

    I'll keep everyone posted who has tried to get this answer - based on the forum threads - for about 4 years now.
     
  3. bji macrumors newbie

    Joined:
    Jun 9, 2009
    #4
    any solutions?

    I am trying to do the same thing, import my address book contacts into excel. Anyone have any good solutions?
     
  4. MooneyFlyer macrumors 65816

    MooneyFlyer

    Joined:
    Nov 18, 2007
    Location:
    Boston
    #5
    It's not all that elegant but I was able to get Address Book sync'ing with my Google account. Once that was in place I was able to export from Google Contacts to a CSV...
     
  5. bji macrumors newbie

    Joined:
    Jun 9, 2009
    #6
    Thanks for that info. That seems to work except for one glitch, which is that it doesn't import mailing address information into excel, even though it does import it into Google contacts.

    There's also a site for converting from vcard to csv. That's at: http://labs.brotherli.ch/vcfconvert/

    Any ideas about that address issue?
     
  6. MooneyFlyer macrumors 65816

    MooneyFlyer

    Joined:
    Nov 18, 2007
    Location:
    Boston
    #7
    Not sure -- do you mean that you can't send from Google to excel and keep the address info? I'll check that out..
     
  7. MooneyFlyer macrumors 65816

    MooneyFlyer

    Joined:
    Nov 18, 2007
    Location:
    Boston
    #8
    This might be another option. Found this in another thread for a different reason. It's a set of scripts...

    Export Addresses (Address Book)
    Export addresses from the Address Book into tab-delimited text files. You can select which groups and which fields you want to export.

    http://homepage.mac.com/aamann/Mail_Scripts.html

    Good luck
     
  8. GGJstudios, Dec 7, 2009
    Last edited: Nov 14, 2011

    GGJstudios macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #9
    1. Export your Address Book as vCards
    2. Convert to .csv using this
    3. Import .csv file into Excel.
     
  9. mjmacuser macrumors newbie

    Joined:
    Jan 8, 2011
    #10
    that worked like a charm on my mac

    thank you so much for posting that link :), as googling didn't find that for me. Note that I had to use a comma as a delimiter instead of a tab in order to get the fields to show up in separate columns.
     
  10. gadenino macrumors newbie

    Joined:
    Mar 8, 2004
    Location:
    Westerville, OH
    #11
    Address Book Contacts to Excel - the easy way

    1. Download and install Mail Scripts: http://andreasamann.com/MacOSX/Mail_Scripts

    2. Run the Export Addresses app. and save as a comma delimited file.

    You'll be asked to choose what fields you want to export and whether you want header fields. I recommend exporting the header fields.

    3. Highlight and change the extension on the exported file from .txt to .csv and agree to the extension change when asked.

    4. The .csv file will import directly into Excel.
     
  11. LxHunter macrumors 6502

    Joined:
    Nov 14, 2010
    #12
    If you have Numbers on your Mac just select all your contacts in Address Book and drag to a Numbers spreadsheet. Be sure to expand all the colums in the table.
     
  12. JanSKay macrumors newbie

    Joined:
    Nov 26, 2009
    #13
    Excellent tool!

    Someone needed a group of addresses converted and I didn't want to import into my own address book and this tool was exactly what I needed! Thank you SO much! :D
     

Share This Page