Hello friends, in this article we will see how we can export a list of all users present in a SharePoint group.

Export all users from SharePoint group in Excel

  1. Open Microsoft Excel and Click on From OData Data Feed as shown below:

    Click on "From OData Data Feed

  2. In ‘Data Connection Wizard’ Enter the REST URL as below:

    https://myclassbook.sharepoint.com/teams/TestSite/_api/Web/SiteGroups/getbyid(142)/Users

  3. Make sure that you have entered the correct site URL and group ID. You can find the group ID by opening specific group URL: 


  4. Click on Next and you will ask to choose the required Data. In this case we will only get the option for Users. Check it and click on Next.


  5. You can then see that the data will be loading in your Excel:


  6. Once it retrieves all the users from SharePoint group, you can save the file