Export Office 365 Distribution List to CSV

You need every address inside a distribution list, and Microsoft 365 gives you a screen to read, not a file to keep. Many guides still show Remote PowerShell with Basic authentication, which Microsoft is retiring. Below are three ways to export Office 365 distribution list members to CSV, with commands that use modern sign-in.

What do you need to export Office 365 distribution list members to CSV?

You need an admin role that can read recipients, Windows PowerShell and Exchange Online PowerShell module. Exchange Administrator role covers it. Without admin rights, ask your IT team to run commands for you.

1. Sign in to Microsoft 365 admin center with an account that holds Exchange Administrator role.
2. Open Windows PowerShell as administrator on your PC.
3. Install Exchange Online module with Install-Module -Name ExchangeOnlineManagement and accept prompts.
4. Create a folder for your CSV file with New-Item -ItemType Directory -Path C:\Reports -Force.

Microsoft documents how to connect to Exchange Online PowerShell with modern authentication, including multifactor sign-in. Copy list names or email addresses first. You pass one of them to every command below.

Can Exchange admin center export Office 365 distribution list members?

No. Exchange admin center lets you view members of a distribution list, but its Export option saves a list of groups, not people inside one. Use it to check names, then switch to PowerShell for a file.

1. Open Exchange admin center and select Recipients, then Groups.
2. Select Distribution list tab and click your list.
3. Open Members pane to read every address.

A user on Microsoft Q&A reported that Export data to CSV produced group names, not members of selected group. Their answer used PowerShell with Basic authentication, which is now retired, so use steps in next section.

How to export Office 365 distribution list members to CSV with PowerShell?

Connect with Connect-ExchangeOnline, read members with Get-DistributionGroupMember and save output with Export-Csv. It is free and gives you name, email address and recipient type.

1. Open Windows PowerShell and run Connect-ExchangeOnline. Sign in with your admin account in Microsoft window.
2. Run command below. Replace sales@yourdomain.com with your distribution list address.
3. Open C:\Reports\DLMembers.csv in Excel and check rows.
4. Run Disconnect-ExchangeOnline -Confirm:$false to close your session.

Get-DistributionGroupMember -Identity "sales@yourdomain.com" -ResultSize Unlimited | Select-Object DisplayName, PrimarySmtpAddress, RecipientType | Export-Csv -Path "C:\Reports\DLMembers.csv" -NoTypeInformation -Encoding UTF8

ManageEngine's knowledge base confirms that Exchange admin center cannot export members and points admins to that same cmdlet pair. Read Microsoft's page on Get-DistributionGroupMember for every parameter.

Old guides open a session with New-PSSession and Basic authentication, then load MSOnline or AzureAD modules. That route is deprecated. Connect-ExchangeOnline replaces it, and cmdlets after sign-in stay almost unchanged.

How to export members of all Office 365 distribution lists to CSV?

To export members of all Office 365 distribution lists, loop through every list with Get-DistributionGroup and add a Group column, so one CSV file shows who sits in which list.

1. Run Connect-ExchangeOnline if your session closed.
2. Paste command below into PowerShell and press Enter.
3. Open C:\Reports\AllDLMembers.csv and filter by Group column.

Get-DistributionGroup -ResultSize Unlimited | ForEach-Object { $g = $_; Get-DistributionGroupMember -Identity $g.PrimarySmtpAddress -ResultSize Unlimited | Select-Object @{n="Group";e={$g.DisplayName}}, DisplayName, PrimarySmtpAddress, RecipientType } | Export-Csv -Path "C:\Reports\AllDLMembers.csv" -NoTypeInformation -Encoding UTF8

Large tenants take time because command reads every Office 365 distribution list one at a time. Old versions of our guide had typos such as ForEach-Oject and a missing space in New-PSSession -ConfigurationName, and those broke copy-paste runs. Paste commands above exactly and check straight quotes if your editor swaps them for curly ones.

How to export nested Office 365 distribution list members?

Get-DistributionGroupMember returns direct members only. If a list contains another list, CSV shows that inner list as one row with its recipient type, not its people.

To flatten nested lists, run same command on every inner list you find in RecipientType column, or use a recursive script. A moderator shared one recursive function in a Microsoft Q&A thread on nested list export. That thread has no accepted answer, and loop protection is missing from its code, so test on a small list first.

Steps to save mailbox contacts and mail to CSV with software

1. Install Corbett Office 365 Backup Tool on your Windows PC and open it.
2. Add your Microsoft 365 account and sign in on Microsoft's page. No app password is needed.
3. Tick Contacts, Inbox or other mailbox folders you want.
4. Choose an output format such as CSV for mail or vCard for contacts.
5. Select a destination folder and start backup.
6. Open your output folder and check files before you buy.

Software helps when your goal is a local copy of people you email, not Office 365 distribution list members. Need to move mailboxes instead? Read how to migrate Outlook emails to Office 365 or move Office 365 email to Gmail.

Which way to export Office 365 distribution list to CSV is best?

To export Office 365 distribution list members to CSV, use PowerShell. Use Exchange admin center only to look at members. Use software when you want mailbox contacts and mail on disk.

Need addresses from mail instead of lists? See how to extract email addresses from Outlook.

Why does Office 365 distribution list export fail?

Connect-ExchangeOnline is not recognized

Install ExchangeOnlineManagement module first, then restart PowerShell. Run PowerShell as administrator during install.

Old Basic authentication script stops with an error

Remote PowerShell with Basic authentication is deprecated. Replace New-PSSession lines with Connect-ExchangeOnline and keep your Get-DistributionGroupMember line.

CSV has group names, not members

That output comes from Exchange admin center Export option. Run Get-DistributionGroupMember in PowerShell for people inside an Office 365 distribution list.

You do not have permission to run command

Your account needs an Exchange role that reads recipients. Ask a global admin to add Exchange Administrator role or to run command for you.

Export Office 365 distribution list members to CSV shows only some people

Add -ResultSize Unlimited so large lists return every row, and check RecipientType column for inner lists that need their own export.

What to do after you export Office 365 distribution list members to CSV?

Open CSV in Excel, check row count against Members pane and remove test rows. Store file in a protected folder, because it holds real email addresses. Keep a local copy of your mailbox with Office 365 Backup Tool, since cloud mail depends on your subscription.

Questions about Office 365 distribution list export