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. 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
- Export Outlook Global Address List or Address Book to Excel with Kutools for Outlook
Export Outlook Global Address List or Address Book to Excel
Please follow steps below to export the Global Address List or an Address Book from Outlook to Excel.
1. Create a new email by clicking "Home" > "New Email".
2. In the new Message window, click the "To" button in the message header.
3. In the Select Names box:
- Select the "Global Address List" from the "Address Book" drop-down list.
- Hold the "Shift" key, click the first and last contact to select all.
- Click the "To -->" button to add them as recipients.
- Click the "OK" button.
4. Back in the message window, select all recipients in the "To" field, right-click, and select "Copy".
5. Open a new workbook in Excel, right-click a blank cell, and select "Keep Text Only".
6. Click "Data" > "Text to Columns".
7. In the wizard, check "Delimited" and click "Next".
8. Check "Semicolon", and click "Finish".
9. Select and copy the contacts, right-click a blank cell and select "Transpose (T)".
10. Click "File" > "Save", specify the location, name the file, and click "Save".
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 first, and then export them to Excel.
Say goodbye to Outlook inefficiency! Kutools for Outlook makes batch email processing easier - now with free AI-powered features! Download Kutools for Outlook Now!!
1. In People view, create a new contact folder by clicking "Home" > "New Contact Folder".
2. In the Contact Group window, name the new contact group, then click "Contact Group" > "Add Members" > "From Address Book".
3. In Select Members:
- Select "Global Address List".
- Hold "Shift" and select all contacts.
- Click the "Members" button, then "OK".
4. Back in the Contact Group window, click "Save & Close".
5. Select the contact group, click "Kutools" > "Contact Group".
6. In the Break dialog, click "All" > "OK" > "Yes" when prompted.
7. Click "View" > "Change View" > "Phone".
8. Copy all contacts (Ctrl + A to select, Ctrl + C to copy), paste into Excel, and save the file.
Notes:
- Use "Ctrl + A" to select all contacts quickly.
- Use "Ctrl + C" to copy and "Ctrl + V" to paste into Excel.
Demo: Export Outlook Global Address List or Address Book to Excel
Related Articles
Best Office Productivity Tools
Breaking News: Kutools for Outlook Launches Free Version!
Experience the all-new Kutools for Outlook with 100+ incredible features! Click to download now!
📧 Email Automation: Auto Reply (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: Recall Emails / Block Scam Emails by Subjects and Others / Delete Duplicate Emails / Advanced Search / Consolidate Folders ...
📁 Attachments Pro: Batch Save / Batch Detach / Batch Compress / Auto Save / Auto Detach / Auto Compress ...
🌟 Interface Magic: 😊More Pretty and Cool Emojis / Remind you when important emails come / Minimize Outlook Instead of Closing ...
👍 One-click Wonders: Reply All with 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 ...
Use Kutools in your preferred language – supports English, Spanish, German, French, Chinese, and 40+ others!
🚀 One-Click Download — Get All Office Add-ins
Strongly Recommended: Kutools for Office (5-in-1)
One click to download five installers at once — Kutools for Excel, Outlook, Word, PowerPoint and Office Tab Pro. Click to download now!
- ✅ One-click convenience: Download all five setup packages in a single action.
- 🚀 Ready for any Office task: Install the add-ins you need, when you need them.
- 🧰 Included: Kutools for Excel / Kutools for Outlook / Kutools for Word / Office Tab Pro / Kutools for PowerPoint