Importing Entourage address book data to Excel

[yvdh]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I have compiled a list of contacts in my address book in Entourage. How can I easily create an Excel spreadsheet with the address book information?

To be more specific, I would like to create a new table in Excel comprised of Columns with Name, Address, etc... that come directly from my Address Book in Entourage. After spending the time typing all those names and addresses in the Entourage Address Book it would seem silly to have to type everything again in Excel.

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I have compiled a list of contacts in my address book in Entourage. How can I
easily create an Excel spreadsheet with the address book information?

To be more specific, I would like to create a new table in Excel comprised of
Columns with Name, Address, etc... that come directly from my Address Book in
Entourage. After spending the time typing all those names and addresses in the
Entourage Address Book it would seem silly to have to type everything again in
Excel.

You don't have to retype them. Just use Entourage to export them as a text
file, then open the exported file with Excel.

 

[yvdh]

On 4/8/08 5:31 PM, in article (e-mail address removed)9absDaxw,

:

> Version: 2008
> Operating System: Mac OS X 10.5 (Leopard)
>
> I have compiled a list of contacts in my address book in Entourage. How can I
> easily create an Excel spreadsheet with the address book information?
>
> To be more specific, I would like to create a new table in Excel comprised of
> Columns with Name, Address, etc... that come directly from my Address Book in
> Entourage. After spending the time typing all those names and addresses in the
> Entourage Address Book it would seem silly to have to type everything again in
> Excel.
You don't have to retype them. Just use Entourage to export them as a text
file, then open the exported file with Excel.

Thank you very much! It worked.