Skip to main content

How to export Outlook Global Address List (address book) to Excel?

As we know, the Global Address List or Address books are virtual folders in Outlook. We can view and use contacts in these virtual folders, but it’s hard to print or export the contacts from them. But, this article will introduce a roundabout way to export Global Address List or Address book from Outlook to Excel.


Export Outlook Global Address List or Address Book to Excel

Please follow below steps to export the Global Address List or an Address Book from Outlook to Excel.

1. Create a new email with clicking Home > New Email.

2. Go to the new Message window, and click the To button in the message header. See screenshot:

3. In the Select Names box, please (see screenshot below):

(1) Select the Global Address List from the Address Book drop down list;
(2) Select all contacts with holding the Shift key and clicking the first contact and the last one;
(3) Click the To --> button to add all contacts as email recipients.
(4) Click the OK button.

4. Now you get back to the message window. Please select all recipients in the To filed, right click and select Copy from the right-clicking menu. See screenshot:

5. Create a new workbook, right click a blank cell and select Keep Text Only in right-clicking menu.

Now all contacts of the Global Address List are pasted into the selected cell in Excel.

6. Keep selecting the cell, and click Data > Text to Columns.

7. In the Convert Text to Columns Wizard – Step 1 of 3, please check the Delimited option and click the Next button.

8. In the Convert Text to Columns Wizard – Step 2 of 3, please only check the Semicolon option, and click the Finish button.

And now all contacts of the Global Address List are pasted into a row in Excel.

9. Select and copy the cell with contacts, right click a blank cell and select Transpose (T) from the right clicking menu.

And now all contact of the Global Address List are pasted into a column (See screenshot above). And you can delete the row of contacts as you need.

10. Click File > Save, and then in the Save As dialog box, please: (1) Specify the destination folder you will save the workbook into; (2) Name the new workbook in the File name box; (3) Click the Save button.

So far we have exported the contacts of Global Address List from Outlook to Excel already.


Export Outlook Global Address List or Address Book to Excel with Kutools for Outlook

This method will guide you to save the Global Address list as individual contacts in a new contact folder firstly, and then export these contacts to Excel.

Kutools for Outlook: Ultimate Outlook toolkit with over 100 handy tools. Try it FREE for 60 days, no limitations, no worries!   Read More...   Start Free Trial Now!

1. Go to the People (or Contact) view, create a new contact folder, and then in the new contact folder click Home > New Contact Folder.

2. In the Contact Group window, type a name for the new contact folder in the Name box, and then click Contact Group > Add Members > From Address Book. See screenshot:

3. Now in the Select Members dialog box, please: (1) Select the Global Address List from the Address Book drop down list; (2) Holding the Shift, select all contacts with clicking the first contact and the last one; (3) Click the Members button; (4) Click the OK button.

4. Now you return to the Contact Group window. Please click the Save & Close button.

5. Now select the new contact group, and click Kutools > Contact Group.
doc export global address book to excel 001

6. In the Break dialog, click the All button to select all members, click the Ok button, and finally click the Yes button in the new Kutools for Outlook dialog. See screenshot:
doc export global address book to excel 002

7. Change the contact folder view with clicking View > Change View > Phone.

8. Select and copy all contacts in the contact folder, paste into a new workbook, and finally save the new workbook.

Notes:
(1) You can select all contacts in a contact folder with selecting any contact in it and pressing the Ctrl + A keys at the same time;
(2) Press Ctrl + C keys simultaneously to copy selected contacts, and press Ctrl + V keys simultaneously to paste.

Kutools for Outlook: Supercharge Outlook with over 100 must-have tools. Test drive it for FREE for 60 days, no strings attached!   Read More...   Download Now!


Demo: Export Outlook Global Address List or Address Book to Excel


Tip: In this Video, Kutools tab is added by Kutools for Outlook. If you need it, please click here to have a 60-day free trial without limitation!

One click to save/export multiple emails to text/PDF/HTML/CSV files in bulk in Outlook

Normally we can export/save an email message as a text file with the Save As feature in Outlook. But, for batch saving/exporting multiple emails to individual text files, you have to manually handle each message one by one. Time-consuming! Tedious! Now, Kutools for Outlook's Save as File feature can help you quickly save multiple email messages to individual text files, PDF files, HTML files, etc. with only one click!


ad batch save as excel csv 9.50

Related Articles


Best Office Productivity Tools

Kutools for Outlook - Over 100 Powerful Features to Supercharge Your Outlook

πŸ€– AI Mail Assistant: Instant pro emails with AI magic--one-click to genius replies, perfect tone, multilingual mastery. Transform emailing effortlessly! ...

πŸ“§ Email Automation: Out of Office (Available for POP and IMAP)  /  Schedule Send Emails  /  Auto CC/BCC by Rules When Sending Email  /  Auto Forward (Advanced Rules)   /  Auto Add Greeting   /  Automatically Split Multi-Recipient Emails into Individual Messages ...

πŸ“¨ Email Management: Easily Recall Emails  /  Block Scam Emails by Subjects and Others  /  Delete Duplicate Emails  /  Advanced Search  /  Consolidate Folders ...

πŸ“ Attachments ProBatch Save  /  Batch Detach  /  Batch Compress  /  Auto Save   /  Auto Detach  /  Auto Compress ...

🌟 Interface Magic: 😊More Pretty and Cool Emojis   /  Boost Your Outlook Productivity with Tabbed Views  /  Minimize Outlook Instead of Closing ...

πŸ‘ One-click Wonders: Reply All with Incoming Attachments  /   Anti-Phishing Emails  /  πŸ•˜Show Sender's Time Zone ...

πŸ‘©πŸΌβ€πŸ€β€πŸ‘©πŸ» Contacts & Calendar: Batch Add Contacts From Selected Emails  /  Split a Contact Group to Individual Groups  /  Remove Birthday Reminders ...

Over 100 Features Await Your Exploration! Click Here to Discover More.

Read More       Free Download      Purchase
 

 

Comments (1)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Thank You very much for new Trick. How to get Phone number against email id? Kindly Reply
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
Rate this post:
0   Characters
Suggested Locations