In this article we are going to see how we can fetch data from SharePoint 2010 to Excel.
Step 1
Open an Excel workbook, go to “Data” tab as shown below.
Then “From Web” from the ribbon.
Step 2
Now we need to provide the URL of SharePoint groups as shown below.
Provide the URL - http://<domain.com>/sites/<Sitename>/_layouts/groups.aspx
Then select the circled arrow icon -> and click the button “Import” to import all the users and groups into excel sheet as shown below.
Now you can use filters to refine the groups you want.
You can use the same approach for fetching data from other websites also.