Skip to main content

How to export GAL (Global Address List) to CSV file in Outlook?

Author: Kelly Last Modified: 2020-05-26

We can easily to apply the Import and Export feature and follow the wizard to export a contact folder to a CSV file in Outlook. But, how to export a virtual folder of Global Address List to CSV file Outlook? Below method may help you.


Export GAL (Global Address List) to CSV file with Import and Export feature

Please follow below steps to export the Global Address List to a CSV file in Outlook.

1. Shift to contact view, and create a new contact folder with right clicking the default contact folder and selecting New Folder from the right-clicking menu. See screenshot:

2. In the opening Create New Folder dialog box, type a name for the new folder into the Name box, and click the OK button. See screenshot above:
Note: In our case, we name the new folder as Temporary.

3. Repeat above Step 1 and Step 2 to create another new contact folder and name as GAL.

4. Go into the default contact folder, select all contacts in it, and drag to the new Temporary folder.
Note: To select all contacts in a contact folder, please select one contact in the folder firstly, and then press the Ctrl + A keys at the same time.

And now the default contact folder is empty.

5. Click Home > Address Book.

6. In the opening Address Book, please:
(1) Specify the Global Address List from the Address Book drop down list;
(2) Holding the Shift key and click the first contact and the last one to select all contacts, right click and select Add to Contacts from the right clicking menu.

Now all contacts in the Global Address List are added into the default contact folder. Please close the Address Book dialog box.

7. Go to the default contact folder, select all contacts in it, and drag to the new GAL folder.

8. Click File > Open & Export > Import/Export or File > Open > Import.

9. In the Import and Export Wizard, please click to select the Export to a file option, and click the Next button.

10. In the first Export to a File dialog box, please click to select the Comma Separated Values option, and click the Next button.

11. In the second Export to a File dialog box, please click to select the GAL folder, and click the Next button.

12. In the third Export to a File dialog box, please (see screenshot below):

(1) Click the Browse button;
(2) In the Browse dialog box, specify a destination folder to save the CSV file, name the CSV file in the File name box, and click the OK button;
(3) Click the Next button.

13. In the last Export to a File dialog box, please click the Finish button.

So far we have exported all contacts in the Global Address List in Outlook to an individual CSV file already.

Notes:
(1) Please remember to restore original contacts in the default contact folder: shift to the Temporary folder, select all contacts, and drag to the default contact folder.
(2) Delete the Temporary folder as you need.

Demo: export GAL (Global Address List) to CSV file in Outlook


Discover the Kutools / Kutools Plus tab in this video, added by Kutools for Outlook. Now, most features, including AI functionalities, are free! Pro features come with a 30-day trial without limitations!

Easily add contact group members from emails' senders or recipients in Outlook

Normally, we can copy a sender or a recipient from an email, and then add it as a contact group member with Add Members > From Address Book, and it seems no way to add multiple emails' multiple senders or recipients into a contact group in bulk. But, with the excellent Add to Groups feature of Kutools for Outlook, you can easily add multiple emails' senders or recipients into contacts groups in Outlook with several clicks only.


ad add senders recipients to contact groups 9.50

Export GAL (Global Address List) to CSV file with Contact Group

This method will introduce a roundabout way to export the Global Address List to csv file with a new contact group in Outlook.

1. In the People (or Contacts) view, create a new contact group with clicking Home > New Contact Group.

2. In the new Contact Group window, name the new contact group as Global Address List in the Name box, and then click Contact Group > Add Members > From Address Book. See screenshot:

3. In the opening Select Members dialog box, please:
(1) Select the Global Address List from the Address Book drop down list;
(2) Holding the Shift key, and select all contacts with clicking the first contact and the last one;
(3) Click the Members button, and then click the OK button. See screenshot:

And now all contacts in the Global Address List have been added as members of the new contact group.

4. Go back to the Contact Group window, and click File > Save As.

5. In the Save As dialog box, please:
(1) Open the destination folder you will save the contact group into;
(2) Name the contact group in the File name box;
(3) Select the Text Only (*.txt) from the Save as type drop down list;
(4) Click the Save button.

6. Now open the new Txt file, copy all data about the contact group members from it, and paste into a new workbook.

7. Save the new workbook as a CSV file with clicking File > Save As.

8. In the Save As dialog box, please:
(1) Open the destination folder you will save the new CSV file into;
(2) Type a name for the new CSV file into the File name box;
(3) Select the CSV (Comma delimited) (*.csv) from the Save as type drop down list;
(4) Click the Save button.

So far, you have saved the Global Address List as a CSV file already.

Demo: Export GAL (Global Address List) to CSV file with Contact Group in Outlook


Discover the Kutools / Kutools Plus tab in this video, added by Kutools for Outlook. Now, most features, including AI functionalities, are free! Pro features come with a 30-day trial without limitations!


Related Articles


Best Office Productivity Tools

Breaking News: Kutools for Outlook Launches Free Version!

Experience the all-new Kutools for Outlook FREE version with 70+ incredible features, yours to use FOREVER! Click to download now!

🤖 Kutools AI : Instant pro emails with AI magic--one-click to genius replies, perfect tone, multilingual mastery. Transform emailing effortlessly! ...

📧 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 ProBatch 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 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 ...

Instantly unlock Kutools for Outlook with a single click—permanently free. Don't wait, download now and boost your efficiency!

 

 

 

Comments (4)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
very usefull
This comment was minimized by the moderator on the site
nice with the KMS files there showing you dint pay for windows.
nice.
This comment was minimized by the moderator on the site
Awesome. Thank you!
This comment was minimized by the moderator on the site
This was SO helpful! Much appreciated!
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations