Here is a good approach:

1. From Address Book:
File > Export > Other Address book... > Text File (Comma Separated Values)
The Wizard will permit you to select which fields are to be exported.

2. From Excel, just open the .csv file created in step #1

Oggy,

Gary's Student has given you a good way to get the entire address book into a sheet.

If you will be doing this often, you many wish to set up a query.  This will put them into
an existing workbook, rather than having to read them into a new workbook, as with the
File-Open method.  Data - Import External Data - Import Data.  Navigate to the file (don't
worry about data sources).  You still get the Import Wizard, as with opening the text file,
so you can set up columns to skip, formatting, etc.  Finish the process.  Then the next time
you want to get them, right-click in the area of the sheet where you've imported them, and
just click Refresh.  It remembers.  You'll still have to have exported a fresh copy of the
address book into a text file first.  If you use the same text file name, you'll be ready to
do the refresh in Excel.

If you have only a few, you can copy/paste them in.  Dragging doesn't seem to work,
unfortunately.  One hand over Ctrl-C (copy) and Ctrl-V (paste) can help make short work of
them.