Export Addresses To Excel

Discussion in 'macOS' started by Klew721, Dec 11, 2012.

  1. Klew721 macrumors newbie

    Joined:
    Mar 17, 2011
    #1
    Is there a way to export addresses from address book into Excel? I have been messing around with it all morning and can't figure it out.

    Thanks.
     
  2. Weaselboy Moderator

    Weaselboy

    Staff Member

    Joined:
    Jan 23, 2005
    Location:
    California
    #2
    Do command-a to select all addresses. Export the address entries as a VCF file by using the option under File/Export/Export VCard. Then run the VCF file through this convertor to make it a CSV (comma separated value) file. Then import the CSV file into Excel.
     
  3. CrescentAdam macrumors newbie

    Joined:
    Jan 8, 2013
    #3
    Install Thunderbird

    Download and install Mozilla Thunderbird. When installed it automatically detects your address book contacts and even preserves the groups. Click on the group you want to export, choose Tools/Export. Choose CSV and save. The CSV file will open in excel.
     
  4. looby macrumors newbie

    Joined:
    Apr 6, 2013
    #4
    No Groups

    I've just downloaded the Mozilla application and it has opened and downloaded my contacts but the groups are not present. The groups are the bit I need to allow me to filter and export to excel.

    Any ideas?

    Many thanks
     

Share This Page