Export SharePoint Users and Group Permissions to Excel

Here is the shortcut to export SharePoint users and groups permission to Excel.
  1. Open your SharePoint site in Internet Explorer. Navigate to either Site permissions or any User group. 
  2. Right click on the users list page, choose "Export to Excel" item.export sharepoint user groups to excel
You may need to reformat it a bit! Here is it would look like:
export sharepoint user permissions to excel
This trick works in all versions of SharePoint including, SharePoint 2010, SharePoint 2013, and in SharePoint 2016! Here is the PowerShell way to Export users and group permissions to excel: Export SharePoint Users and Groups to Excel using PowerShell


  1. I cant file Export to Excel when I right click. I'm using IE browser and Chrome. Please help me.

  2. When I try this on a specific group page it doesn't seem to work. Instead it exports the list of users/group as they appear on the site permissions page. I'm trying to get an export of the group members for specific groups.

  3. How to add Permission Levels at owssvr.iqy ?


Please Login and comment to get your questions answered!

Powered by Blogger.