Tuesday, April 23, 2013

Export SharePoint Permissions to Excel


Export SharePoint Permissions to Excel

Just now I had requested from the users asking to Export SharePoint permissions to Excel Sheet. 

Now there is a way to export it from SharePoint.

One of the easiest ways to export SharePoint permission using excel itself. To do this , you will have to Open 

Excel Sheet , Navigate to Data Tab – Click on “From Web”, as shown in the below Screen shot






Once you click on that, it will bring up a New Web Query pop up Box, You will have to enter the URL and 

Select the check boxes Highlighted in yellow to import it in Excel.

 

















Select the desired users, Click on Import. All the users imported. that's it.



Reference

No comments:

Post a Comment