Export SharePoint Permissions to Excel

Posted: September 6, 2011 in Excel, sharepoint 2007, Sharepoint 2010
Tags: ,

I have seen multiple requests from the users asking to Export SharePoint permissions to Excel Sheet. Now there is a way to export it from sharepoint

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 and Voila . All the users imported.

Hope this Helps.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s