It is a common request in any office: "Can you send me everyone on the All Staff list in Excel?" Outlook has no Export button for a distribution list, but there are two reliable ways to get the names and email addresses into a spreadsheet. Any user can do the first one in Outlook. The second uses PowerShell and is the better choice for admins, because it handles big lists and nested groups properly.
Quick answer
In Outlook, put the distribution list in the To field of a new email, click the + to expand it, copy all the names, paste them into Word and replace ; with ^p to put each person on a line. Paste that into Excel and use Data > Text to Columns with < as the delimiter to split names from emails. Admins can export it in one step with Get-DistributionGroupMember in Exchange Online PowerShell.
Method 1: Export a distribution list from Outlook (no admin rights)
This works in classic Outlook for Windows. It is good for lists up to a few hundred people.
Step 1: Expand the list in a new email
- Open a new email and type the distribution list name in the To field.
- Click the small + next to the list name. Outlook warns that it will replace the list with its members; click OK. You are not sending anything, so this is safe.
Step 2: Copy everyone into Word
- Click in the To field, press Ctrl + A to select all the names, then Ctrl + C.
- Open a blank Word document and paste with Ctrl + V. Everyone appears on one long line, separated by semicolons.
- Press Ctrl + H. In Find what type
;and in Replace with type^p, which is Word's code for a new line. Click Replace All.
Each person is now on their own line, in the format Name <email@company.com>.
Step 3: Split names and emails in Excel
- Copy everything from Word and paste it into cell A1 of a new Excel sheet.
- Select column A, then go to Data > Text to Columns.
- Choose Delimited, click Next, tick Other and type
<. Click Finish.
- Column A now has the names and column B the emails, each ending with
>. Select column B, press Ctrl + H, put>in Find what, leave Replace with empty and click Replace All.
Close the email without sending it, and choose not to save the draft.
Limits of the Outlook method
- Lists inside the list (nested groups) show up as a group name. Click their + as well to expand them.
- Dynamic distribution lists cannot be expanded in Outlook at all, because their members are worked out at send time. Use Method 2.
- New Outlook and Outlook on the web do not always offer the expand button. If you do not see the +, use classic Outlook or ask your admin.
Method 2: Export members with PowerShell (Microsoft 365 admins)
For large lists, or when someone needs the export regularly, this is faster and cleaner. You need an Exchange admin role or the Recipient Management role.
Install-Module ExchangeOnlineManagement -Scope CurrentUser
Connect-ExchangeOnline -UserPrincipalName admin@yourcompany.com
Get-DistributionGroupMember -Identity "Sales Team" -ResultSize Unlimited |
Select-Object DisplayName, PrimarySmtpAddress, RecipientType |
Export-Csv "$env:USERPROFILE\Desktop\sales-team-members.csv" -NoTypeInformation -Encoding UTF8The CSV lands on your desktop and opens straight in Excel. A few variations I use:
| Need | Command |
|---|---|
| Microsoft 365 group instead of a distribution list | Get-UnifiedGroupLinks -Identity "Group name" -LinkType Members |
| Dynamic distribution list | Get-Recipient -RecipientPreviewFilter (Get-DynamicDistributionGroup "List name").RecipientFilter |
| Find the exact list name | Get-DistributionGroup -Identity "*sales*" |
When you are done, run Disconnect-ExchangeOnline to close the session.
Which method should you use?
| Situation | Use |
|---|---|
| A one-off export of a small list | Method 1: Outlook, Word and Excel |
| Hundreds or thousands of members | Method 2: PowerShell |
| Dynamic or nested lists | Method 2: PowerShell |
| You are not an admin | Method 1, or ask IT for Method 2 |
More Outlook housekeeping guides: Microsoft 365 online archives and moving emails from Outlook 365 to Gmail.
Frequently asked questions
Can I export a distribution list from Outlook to Excel?
Yes. Expand the list in the To field of a new email, copy the names into Word, replace semicolons with ^p, then paste into Excel and split the columns with Text to Columns using the less-than sign. Admins can export it directly with PowerShell.
Why can I not expand my distribution list in Outlook?
Dynamic distribution lists cannot be expanded because their members are calculated when the email is sent. Some versions of new Outlook and Outlook on the web also hide the expand option. Use classic Outlook or ask an admin to export it with PowerShell.
How do I export distribution list members with PowerShell?
Connect with Connect-ExchangeOnline, then run Get-DistributionGroupMember -Identity "List name" -ResultSize Unlimited, select DisplayName and PrimarySmtpAddress, and pipe it to Export-Csv.
Does expanding the list change it for everyone?
No. Expanding only replaces the list with its members inside your draft email. The distribution list itself is not changed. Just close the draft without sending it.
Can I export a Microsoft 365 group the same way?
In Outlook, yes, if it can be expanded. In PowerShell, use Get-UnifiedGroupLinks with -LinkType Members instead of Get-DistributionGroupMember.