Monitor Work from Home Employees with Employee Desktop Live Viewer.

Read More

How to Export Offline Global Address List from Outlook?

Megha Sharma    Megha Sharma     Updated On - 30 Apr 2021

It is easy for Outlook users to export their contacts to Outlook PST file or CSV file. But what about Global Address List? This also can be exported, but with a slightly different procedure.

Exchange Global Address List can be exported to CSV file format as a backup, for offline use, and for sharing with others, but the process is not direct as using the Import/Export feature to export Outlook 2016 contacts to CSV file. Exchange administrators require a different approach, including using Contact Group or creating new Contacts folders to move GAL contacts to the default Contacts folder and then exporting them using the Import/Export feature. In this blog, we would go through both processes one by one.

Exporting Offline Global Address List (GAL) from Outlook

There are two ways using which you can export your Exchange Server offline Global Address List (GAL) from Outlook to CSV file format, which we are going to discuss in detail with the sequential process.

Using Contact Group

  1. Open the People (Contacts) section in your Outlook application by clicking on the same icon.
  2. Click on the Home menu and then select Contact Group from the drop-down list of the New Contact section.
  3. Select Contact Group

  4. A new window with the Contact Group name will open. Here, click on the Add Members section and then select From Address Book from the drop-down list.
  5. Add Members section

  6. In the next window, select the desired Global Address List from the drop-down of the Address Book section to list down the contacts within it. Use Shift, Ctrl, and arrow keys to select desired contacts in the list. Click the Members option at the bottom, check the selected contacts and then click OK.
  7. Next, follow File > Save as in the Contact Group window.
  8. Browse and select the destination folder, add a file name, and select Text only (.txt) from the Save as type section and click on the Save option.
  9. select the destination folder

  10. A Text file will be created. Open the file, copy, and paste its content to the Excel workbook.
  11. Now, follow File > Save as in the Excel workbook and browse a new saving location along with a new file name and select the Save as type for the file as CSV (Comma delimited) (*.csv). Finally, click Save.
  12. Save file in csv format

  13. The Global Address List from Outlook is successfully exported to the CSV file format.

Using the Import/Export Feature in Outlook

  1. Open the Outlook application and navigate to the People (Contacts) view.
  2. Right-click on the default Contacts folder from the left panel and follow New Folder > Add a name to the folder (say Carrier) and click OK. Similarly, create another Contacts folder (say GAL) for GAL.
  3. create another Contacts folder

  4. Now, select all the contacts (with Ctrl + A) from the default folder, drag them all to the new folder created in the first place.
  5. Now, from the Home menu, click the Address Book option from the right corner, and in the newly opened window, select the desired GAL under the Address Book section to list out its contacts.
  6. select the desired GAL under the Address Book

  7. Select all the listed contacts, right-click and then select Add to Contacts option. The contacts from the selected GAL are now added to the default Contacts folder.
  8. Next, you need to select all the contacts from the default Contacts folder and move them to the second folder created for GAL using the drag-drop action.
  9. Now, we can export this GAL folder to the CSV file format using the Import/Export feature in Outlook easily.
  10. In the Outlook application, go to File > Open & Export > Import/Export.
  11. Import/Export

  12. In the Import and Export wizard, select Export to a file and click Next.
  13. Select Export to a file

  14. In the Export to a file wizard, select Comma Separated Values and click Next.
  15. Select Comma Separated Values

  16. Next, under the Contacts section, select the GAL folder and click Next.
  17. GAL folder

  18. Click the Browse option to provide the destination and name for the file to be exported. Click Next to continue.
  19. provide the destination

  20. Click Finish in the next wizard.
  21. Click on finish

  22. Now, the GAL contacts along with the default contacts are exported to the CSV file format successfully.
  23. Now, you can move contacts saved in the 3rd or step c to their original location (default Contacts folder) using the drag/drop action and then delete the created one (Carrier).

For quick and secure backup of Exchange Server Global Address Lists, you can try the professional solution known as Kernel Exchange Backup & Restore, standalone software for the backup of complete Exchange data to PST file and also restore of PST files to Exchange. The tool is easy to use and delivers outstanding performance. Get your hands on the tool with the trial version.

Download Now