Export Addresses To Excel

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

  1. Klew721 macrumors newbie

    Mar 17, 2011
    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.

  2. Weaselboy Moderator


    Staff Member

    Jan 23, 2005
    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

    Jan 8, 2013
    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

    Apr 6, 2013
    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