How to extract Teams Members email addresses?

Hi RobinsonJoanL-2865 

Welcome to the Q&A Community, 

I’m here to assist your problem. 

Extracting a list of Microsoft Teams members' email addresses can be done in several ways, depending on your role (e.g., team owner, admin) and technical comfort level. Since you're asking about exporting this data and have access to Microsoft 365 (based on prior queries), I'll provide methods ranging from manual to automated, with a focus on security and simplicity. The process doesn't require advanced tools for basic extraction, but some methods need admin privileges or scripts. Here’s how you can do it 

Manual method (No Admin access, Team Owner): 

If you're a team owner and want a quick, no-code solution, this works for small teams: 

-Open Microsoft Teams on the web (teams.microsoft.com) or desktop app. 

-Go to the Teams tab > Select the team > Click the three dots (...) next to the team name > Choose "Manage team." 

-In the Members tab, expand the "Members and guests" or "Owners" sections (scroll to load all members if the list is long). 

-Highlight the names (click and drag from the "Name" column header down) > Right-click > Copy. 

-Paste into a text editor (e.g., Notepad) or Excel. 

-To get emails, create a new email in Outlook:  

-Click "To" > Type the team name (if it’s an Office 365 group) > Expand the group by clicking the "+" > Copy the email list. 

-Paste into Excel > Use Text to Columns (Data tab > Text to Columns > Delimited > Semicolon > Finish) to separate emails. 2/ Teams Admin Center (Admin Access Required)

If you’re an admin, this method provides a controlled export: 

-Sign in to the Microsoft Teams admin center (admin.teams.microsoft.com). 

-Go to Teams > Manage teams. 

-Select the team > Click "Members" > Use the "Download members" option (under Bulk operations) to export a CSV file. 

-The CSV includes names and email addresses (e.g., User Principal Name or SMTP address). 

• If you’re a Team Owner: Start with the manual Outlook method—it’s quick and sufficient for small teams. 
• If you’re an Admin: Use the Teams Admin Center for an official export. 
• For automation: Try PowerShell or Graph API if you handle multiple teams. 

If you encounter issues (e.g., no emails in the export, permission errors), let me know your role, team size, or any error messages, and I’ll adjust the guidance. 

As a forum moderator with a limited scope of knowledge, I hope you find my answer helpful. Please know that I've done my best to assist you."  

Thank you for your kindness and understanding. If you need anything else, please feel free to contact me.  

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment" 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.