Previous 1 2 Next 19 Replies Latest reply: Jan 13, 2011 6:42 PM by drexgreen
Steven Shmerler Level 1 Level 1 (70 points)
WOW. How did Apple get away with this for all these years? I recently migrated from Now Up To Date to Addressbook so I could be "all Mac" and now my contact content is stuck inside?

There seems to be a program for sale for $18 (Export Address Book), but I have to say as HUGE Apple supporter evangelist, this is a bit odd of a missing option that we shouldn't have to pay for IMHO.

I'll keep checking for other solutions. I can afford the $18, it's the principle. I'm just stunned there's now export within AB I can open in a spreadsheet. Very odd.

Unless I'm missing something?

Mac Pro 3.0 GHz Quad-Core, iPad WiFi + 3G, Mac OS X (10.6.4), 30" HP LP3065 Monitor, 22" Cinema Display
  • Barney-15E Level 8 Level 8 (41,185 points)
    Why doesn't the open source standard vCard format suffice?
    You can always write an Applescript that will output a csv file if your non-standards compliant destination does not support a vCard.

    Or, you could use a freely available [vcard to csv web application|] to convert them.
  • Barney-15E Level 8 Level 8 (41,185 points)
    Sorry, it is not "open source." I thought it was, but it is not.
  • Steven Shmerler Level 1 Level 1 (70 points)
    Since posting, I've found several solutions via searching the web. I don't know if we are allowed to mention apps here, but there's Export Address Book ($18) and Address Book Export (free/shareware) for starters. So it can be done. My point is more that Apple usually tries to make things easy and logical. So not having a comma or tab delimited export seems out of line with usual Apple UI.

    Also, I've not used VCards being new to Addressbook, I've been using a contact manager for years and just migrated to it.

    What I need to do is see my contacts in a spreadsheet to whittle it down to a call list I need to make. But being able to see the list in Excel in a big open format is what I need in this case.

    I selected my entire contact list inside Addressbook and exported vCards and got one 455kb card which Excel won't open, so I will need to use one of the available 3rd party applications.

    I just think Apple should have an Export built in.
  • Barney-15E Level 8 Level 8 (41,185 points)
    Use Automator's built in action to get Contact info. Set it to export as tab separated and then have Excel open it.
  • Whitecity Level 2 Level 2 (340 points)
    Wow. would it kill them to include that option?
  • Barney-15E Level 8 Level 8 (41,185 points)
    They did. Just not where you want it.
  • Steven Shmerler Level 1 Level 1 (70 points)
    Are you referring to using 3rd party apps or you can export a comma or tab delimited file from within Addressbook? If so, where do we find it?
  • Barney-15E Level 8 Level 8 (41,185 points)
    No, I'm referring to Automator Action that I referred to before.
  • Steven Shmerler Level 1 Level 1 (70 points)
    Oh, I totally missed that sorry. I'm in Automator now and see what you mean.

    For those not familiar with Automator, it's in your Applications folder. Launch it and then you'll see a window of several icons.

    Select and Choose the Application icon.

    Then in the left column of Automator you'll see Library and Contacts under it along with other choices. Single click "Contacts" and in the middle column you'll now see a new list of options, drag "Get Contact Information" to the far right column (Drag actions to build workflow).

    Now you'll see all your Contact fields and in the top row: "Export Format" with a pulldown menu with: Formatted Text, Spreadsheet (tabs) and AppleScript Lists.

    Choose Spreadsheet (tabs) if you want a file of your contacts that you can open in a program like Excel.

    You'll also note that you can check or uncheck which fields you want to export.

    I assume that when you are ready, you click "Run" in the upper right of the window.

    Right Barney?

    Thanks Barney for pointing me/us here.
  • Barney-15E Level 8 Level 8 (41,185 points)
    Yes, you can just hit run, or you can save it as an application or workflow and run it via double-click.
    I think you have to choose what type of workflow it is before you start building it, though.
  • mjkaufman Level 1 Level 1 (10 points)
    I just tried this and got an error message:
    "The action "Get Contact Information" was not supplied with the required data" and "The variable label_row is not defined (-2753)".
    What's all this about?
  • Steven Shmerler Level 1 Level 1 (70 points)
    This being the first time I've used this method, I don't know the answer. Sorry. Anyone else know!
  • bneely Level 5 Level 5 (5,255 points)
    Do you already own Bento? Bento is an application from FileMaker (owned by Apple), and you can use it to view and edit your contacts.

    Separately, could you explain what a spreadsheet can do that Address Book can't currently do?
  • Steven Shmerler Level 1 Level 1 (70 points)
    Don't own bento, but I do own Filemaker. I hadn't thought of using that or bento since I just wanted a simple spreadsheet compatible export to view in Excel.

    The reason for this is because I have about 1,000 records in Addressbook and needed to be able to quickly and easily see all the records and then delete down to just the ones I wanted for a mailing. It is easier to do this in Excel then in Addressbook. Plus you can sort on each column for different views of your database that you can't do in Addressbook.
Previous 1 2 Next