{"id":47390,"date":"2019-11-25T16:07:42","date_gmt":"2019-11-25T16:07:42","guid":{"rendered":"https:\/\/www.stellarinfo.com\/blog\/?p=47390"},"modified":"2026-02-11T11:54:16","modified_gmt":"2026-02-11T11:54:16","slug":"export-global-address-list-gal-to-csv","status":"publish","type":"post","link":"https:\/\/www.stellarinfo.com\/blog\/export-global-address-list-gal-to-csv\/","title":{"rendered":"How to Export Global Address List (GAL) to CSV?"},"content":{"rendered":"
You can export the Global Address List (GAL) to CSV file by using PowerShell commands in Exchange Management Shell or by using Outlook. However, these native methods have certain limitations. An effective and easy method to export the GAL is by using Stellar Converter for EDB – a specialized EDB to PST converter tool. In this post, we will explain how to use these methods to export Global Address List (GAL) to CSV file.<\/p>
What is Global Address List (GAL) in Exchange Server?<\/h2>
Global Address List (GAL) is a central address book in Exchange Server, which serves as the primary directory for address book lookups in Outlook and other clients. It lists all mail-enabled objects in an organization, like users, groups, and resources along with their contact details. Clients such as Outlook use GAL to find names and email addresses for all email users.<\/p>
Methods to Export Global Address List (GAL) to CSV<\/h2>
You need to export the GAL to CSV for various purposes, such as migration to another platform, backing up the organization’s contacts, enabling offline access, etc. Whatever be the reason, you can follow the methods mentioned below to export GAL to CSV.<\/p>
\n
Export Global Address List (GAL) to CSV by using PowerShell<\/li>\n\n\n\n
Export Global Address List (GAL) to CSV via Outlook<\/li>\n\n\n\n
Export Global Address List (GAL) to CSV by using EDB to PST Converter Tool<\/li>\n<\/ul>
How to Export Global Address List (GAL) to CSV by using PowerShell?<\/h2>
You can use PowerShell commands in Exchange Management Shell (EMS) to export Global Address List (GAL) to CSV file. Let’s take a look at the stepwise process.<\/p>
First, you need to get the list of all the mailboxes. So, open the EMS as an administrator and then use the Get-Mailbox cmdlet to fetch the list of all mailboxes. By default, Exchange outputs 1000 mailboxes when you run this cmdlet. However, you can also increase or decrease the size of result, based on the number of mailboxes in your organization. In the below example, we are setting unlimited value for the resultsize parameter to display all the mailboxes.<\/p>
This command will list all the mailboxes, even those that are marked as hidden. If you open the mailbox from the Exchange Admin Center (EAC), you will find the “Hide from address lists” tick box enabled.<\/p><\/figure>
These mailboxes are system or notification mailboxes, which might not be needed. So, you can skip listing these mailboxes by adding an exception to the command:<\/p>
In case, you want to list these hidden mailboxes, use the command as given below:<\/p>
get-mailbox -resultsize unlimited<\/code><\/pre>
The next part is to export all the necessary details from the mailboxes to get your address book by using the Get-User PowerShell cmdlet. After that, you can filter out the details needed by using the Select cmdlet. If you use the Get-User cmdlet alone, it will export all the details of mailboxes, like Object Category, Creation date, and other items that you wouldn’t need in your export.<\/p>
To fetch field names of your choice, you can use the Get-User | Select * command like this:<\/p>
Once the criteria for export is ready, you can build the Select command to choose specific fields you need. In the example below, we are selecting Display Name, Work Phone, and Email Address. However, you can customize the Select command to add other fields such as department, alias, etc.<\/p>
Lastly, export the results of the command to a CSV file. You can do this by using the Export-CSV <destination path> command (see the below example):<\/p>
export-csv c:\\GAL-Export.csv<\/code><\/pre>
Enclose the path in inverted commas. This prevents the command from failing. However, it has one issue—it exports a Type information row in your CSV. So, if you want to automate this process, you need to add a switch parameter to remove the first row.<\/p><\/figure>
In order to remove this row, you can add –NoTypeInformation at the end of the command:<\/p>
Once you have all this settled and in place, you need to add all the steps together to export the whole address book as desired. The example below will export the Display Name, Work Phone, and Email Address for all users which are not hidden in the address book to a CSV in C:\\GAL-Export.csv.<\/p>
One thing to note is that this command only works if your Exchange Server is in good working condition.<\/p>
How to Export Global Address List (GAL) to CSV via Outlook?<\/h2>
To export GAL via Outlook, you need to first move the GAL to a personal Contacts folder. Open the Address Book and select the list that contains the global address book copy (OAB).<\/p><\/figure>
Select all the contacts you wish to export, right-click on the selection, and select Add to Contacts<\/strong>. After that, you can export these contacts to CSV file.<\/p><\/figure>
It is to be noted that OAB only includes visible entries, which means hidden mailboxes cannot be exported via Outlook. Another thing to consider is that exporting large number of contacts from Outlook can be very time-consuming. Such exports may noticeably degrade Outlook performance during the process.<\/p>
How to Export Global Address List (GAL) to CSV by using an EDB to PST Converter Tool?<\/h2>
![\"setting](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/11\/1-9.png\")
<\/figure>![\"tick](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/11\/2-6.png\")
<\/figure>![\"skip](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/11\/3-4.png\")
<\/figure>![\"fetch](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/11\/4-4.png\")
<\/figure>![\"add](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/11\/5-2.png\")
<\/figure>![\"switch](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/11\/6-4.png\")
<\/figure>![\"GAL-Export.csv](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/11\/7-3-1024x552.png\")
<\/figure>![\"Global](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/11\/8-2.png\")
<\/figure>![\"Select](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/11\/9-1.png\")
<\/figure>![\"open](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/11\/10-1.png\")
<\/figure>![\"save](\"https:\/\/www.stellarinfo.com\/blog\/wp-content\/uploads\/2019\/11\/14-1.png\")
<\/figure>