This discussion is archived
6144 Views 19 Replies Latest reply: Jan 13, 2011 6:42 PM by drexgreen
Currently Being ModeratedNov 14, 2010 5:42 PM (in response to Steven Shmerler)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|http://www.google.com/search?client=safari&rls=en&q=vcardtocsv&ie=UTF-8&oe=UTF-8] to convert them.1.8 SP G5/iMac G4 FP/MBP 2.33/iPhone, Mac OS X (10.6.4)
Currently Being ModeratedNov 15, 2010 10:26 AM (in response to Barney-15E)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.Mac Pro 3.0 GHz Quad-Core, iPad WiFi + 3G, Mac OS X (10.6.4), 30" HP LP3065 Monitor, 22" Cinema Display
Currently Being ModeratedNov 15, 2010 3:39 PM (in response to Barney-15E)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?Mac Pro 3.0 GHz Quad-Core, iPad WiFi + 3G, Mac OS X (10.6.4), 30" HP LP3065 Monitor, 22" Cinema Display
Currently Being ModeratedNov 15, 2010 6:08 PM (in response to Barney-15E)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.
Thanks Barney for pointing me/us here.
StevenMac Pro 3.0 GHz Quad-Core, iPad WiFi + 3G, Mac OS X (10.6.4), 30" HP LP3065 Monitor, 22" Cinema Display
Currently Being ModeratedNov 16, 2010 3:21 PM (in response to Steven Shmerler)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.1.8 SP G5/iMac G4 FP/MBP 2.33/iPhone, Mac OS X (10.6.4)
Currently Being ModeratedNov 22, 2010 9:14 AM (in response to Steven Shmerler)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?Mac Pro, iPhone 4, Mac OS X (10.6.5)
Currently Being ModeratedNov 22, 2010 10:31 AM (in response to mjkaufman)This being the first time I've used this method, I don't know the answer. Sorry. Anyone else know!
Currently Being ModeratedNov 22, 2010 12:21 PM (in response to Steven Shmerler)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?24" intel iMac, Mac OS X (10.6)
Currently Being ModeratedNov 22, 2010 1:24 PM (in response to bneely)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.