[Macworld]

Post your comments for Exporting Address Book to a spreadsheet here

[rorybowman]

If one has iWork '08, one can simply open up Numbers and Address Book at the same time. Select several contacts (Command+A to select all) and simply drag them onto a Numbers sheet. Numbers will automatically create a table which can then be worked with or exported.
A quick look at Numbers help will show other ways that Address book can tie into existing spreadsheets.

[rogbar]

Very good point. The important thing to remember is that when you first drag Address Book contacts into Numbers, you won't see all the fields display. You have to go into the Tables menu and select Unhide All Columns before you see every field from the contact.

[quamelle]

For people like me stuck in the stone age with mac os tiger it is really easy to, just go to export and choose, spreadsheet, alternatively you can export as a vcard and then import into the spreadsheet, but then you have to do that separately for every single contact.

[angusbegg]

hi all - im stumped.

How do I export an Excel database to my Address book?

Desperate!

[EGM]

It's not difficult.

1. (optional, but helps) Give your Excel a header row with field names. If those happen to match Address Book field names, it will make a good guess at what matches what.

2. Put your data under those names. Blank cells are no problem. Not everyone has a nickname or a company, for example.

3. Save your Excel file in CSV (comma-separated values) format.

4. Switch to Address Book and select the group where you want the new contacts. Last Import is the only one that won't work. (All Contacts is fine.)

5. Select File>Import (command-O). Navigate to the file you just saved.

6. Make any necessary adjustments to the column mapping in the equivalence panes that show up. Make sure "Ignore first card" is checked if have column headers and you don't want them imported as a contact. You can check the mapping via the navigation arrows at the bottom of the dialogue box. When you're happy with it, click OK.

7. Check the new cards in the Last Import group to confirm that it worked.

[Platinum]

The Free Way

Get Directmail App (which i s great App anyway)

Go to Addresses
Import Addresses
1. Select which group you want to import
2. Highlight the contacts you want to import from that group
3. Customize the fields (remember your field names)
4. Import
5. Highlight which addresses you want to export
6. Go to Addresses
7. Export

Open Excel
8 . Open a new Sheet
9. Then import your CSV file to a new excel sheet - follow the steps

Then you can export to excel

There's a few more, just checking