Fetch Users Or Groups Or List Items From SharePoint 2010 Using Excel 2010

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.

SharePoint

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

SharePoint

Then select the circled arrow icon -> and click the button “Import” to import all the users and groups into excel sheet as shown below.

SharePoint

Now you can use filters to refine the groups you want.

You can use the same approach for fetching data from other websites also.