SharePoint Online: Export Group Members to Excel

Requirement: Export SharePoint Online group members to Excel.

How to Export SharePoint Online Group Members to Excel?

Have you ever wanted to export all members of a SharePoint Online group to Excel? Maybe you want to create a report or simply want to audit the SharePoint groups and their members or track changes to the membership over time. In this guide, I’ll walk you through the process of exporting group members to Excel without using PowerShell or any 3rd party tools. Here is how you can do that:

  1. Login to Site Collection >> Navigate to Site Settings.
  2. Click on the “People and Groups” link and pick the desired group to get group members. The URL should look like this:, We need the ID of the group to retrieve all members of a SharePoint Online group. The value of “MembershipGroupId” parameter is the ID of the group. In this case, its: 4
  3. Now frame the URL: (Replace YourTenant and GroupID values with yours)
  4. Open Microsoft Excel >> under “Data” tab, Click “From OData Data Feed” link.sharepoint online export group members to excel
  5. Enter the URL you framed and click on “Next”. In my case it was: sharepoint online group members
  6. In the data connection wizard, select the “Users” table and click on the Next button. 
  7. Provide a name to your connection and click on the “Finish” button. 
  8. Now, Excel pulls the data and populates the Excel sheet with all members of the group and their details, such as ID, Login Name, Title, Email, etc.
    sharepoint online export group members to excel

Here is another post on PowerShell way to export members from all groups: SharePoint Online: Export Group Members to Excel using PowerShell

Salaudeen Rajack

Salaudeen Rajack - SharePoint Expert with Two decades of SharePoint Experience. Love to Share my knowledge and experience with the SharePoint community, through real-time articles!

3 thoughts on “SharePoint Online: Export Group Members to Excel

  • When I tried this I got this error while connecting from ODD feed:

    OData: Request failed (404): The remote server returned an error: (404) Not Found. (Cannot find resource for the request $metadata.)
    We have on premise hosted sharepoint. What could be the issue ?

  • muy practico, muchisimas gracias!!

  • thanks a lot, exactly what I was looking for!


Leave a Reply

Your email address will not be published. Required fields are marked *