I recently needed to ability to export just addresses from a group in Apple’s Address Book application. While there are a number of solutions out there for exporting data from Apple’s handy Address Book app, none were quite what I was looking for. So, being the developer that I am, I wrote one.
Address Book Exporter is simple to use — just select a group, hit export, and choose a file to export it to. ABE exports to a CSV file ready for use in Excel or other spreadsheet applications. It pays attention to distribution lists — so set up which addresses you want to go with the list in Address Book — go to Edit/Edit Distribution List
[edit: updated to 1.0.1, which places first and last names in separate columns]