Forum Discussion
Help exporting 1000+ contacts
Hello and thank you in advance,
I have a list of 1000+ email addresses. i need to export the full contact info for them from the global address list to a CSV file ( need title and department field specifically). These emails are not currently in my personal contacts. Is there a way to do this quickly, without manually searching up each email and adding it to my contacts? I tried pasting the email addresses into a contact group and saving it as a text file, but that only pulled in the contacts name. Is there a way I can either:
A: Quickly add 1000+ emails to my contacts from the global address list?
or
B: export the contacts directly from the GAL?
Thank you again for your help!
2 Replies
You can easily export the GAL contacts and any metadata stamped on them via PowerShell, however you need admin privileged to do that. Best contact your IT support staff.
Outlook itself can’t export full contact details like Title or Department from the Global Address List (GAL). It only lets you view or manually add them one by one. There’s no built-in feature to bulk export or convert GAL entries to personal contacts with those fields. If the contacts aren’t already in your personal list, Outlook can’t pull that extra data into a CSV. In short, within Outlook alone, this can’t be done automatically, You’d need to add each contact manually to your contacts folder first before exporting.
