Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

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

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

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

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. Click for 60-day free trial without limitation!
ad add senders recipients to contact groups 9.50

Kutools for Outlook: 100+ New Advanced Tools for Outlook.
Office Tab: Enable Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.
Classic Menu: Bring Old Menus and Toolbars Back to Office 2007, 2010, 2013, 2016 and 2019.

arrow blue right bubble 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

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!


arrow blue right bubble 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

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!


arrow blue right bubbleRelated Articles

 

Recommended Productivity Tools

shot kutools outlook kutools tab 1180x121
shot kutools outlook kutools plus tab 1180x121

Kutools for Outlook - More than 100 Advanced Functions for Outlook, Improve 70% Efficiency For you

  • Complicated and repeated operations can be done a one-time processing in seconds.
  • Forward multiple emails individually with one-click, and auto forward by rules.
  • Auto CC/BCC every sending email and easy for customizing rules, and auto reply without requiring exchange server.
  • Powerful junk emails filter, remove duplicate emails, reply with attachment, bunch of one-click operations, and so on...
  • 60-day unlimited free trial. 60-day money back guarantee. 2 years free upgrade and support. Buy once, use forever.
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.