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? Well, here is how you can do that:

  • Login to Site Collection >> Navigate to Site Settings
  • Click on “People and Groups” link and pick the desired group to get group members . Now the URL should look like: Https://crescent.sharepoint.com/sites/marketing/_layouts/15/people.aspx?MembershipGroupId=4 , 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
  • Now frame the URL: (Replace YourTenant and GroupID values with yours) https://YOURTENANT.sharepoint.com/_api/Web/SiteGroups/getbyid(GROUPID)/Users
  • Open Microsoft Excel >> under “Data” tab, Click “From OData Data Feed” link.sharepoint online export group members to excel
  • Enter the URL you framed and click on “Next”. In my case it was: https://crescent.sharepoint.com/_api/Web/SiteGroups/getbyid(4)/Usersexport sharepoint online group members
  • In the data connection wizard, Select the “Users” table and click on Next button. sharepoint online export group membership
  • Provide a name to your connection and click on the “Finish” button. sharepoint online get group members
  • 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 my another post on PowerShell way to export members from all groups: SharePoint Online: Export Group Members to Excel using PowerShell

Salaudeen Rajack

Information Technology Professional with Two decades of SharePoint Experience.

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

  • May 28, 2021 at 4:02 PM

    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 ?

    Reply
  • May 7, 2020 at 8:26 PM

    muy practico, muchisimas gracias!!

    Reply
  • March 2, 2020 at 12:35 PM

    thanks a lot, exactly what I was looking for!

    Reply
  • March 2, 2020 at 12:35 PM

    thanks a lot, exactly what I was looking for!

    Reply

Leave a Reply