Export SharePoint Users and Group Permissions to Excel

Requirement: Export users and group permissions to Excel in SharePoint.

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 the “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 SharePoint 2016! Here is the PowerShell way to Export users and group permissions to excel: Export SharePoint Users and Groups to Excel using PowerShell

Salaudeen Rajack

Salaudeen Rajack - SharePoint Expert with Two decades of SharePoint Experience. Love to Share my knowledge and experience with the SharePoint community, through real-time articles!

6 thoughts on “Export SharePoint Users and Group Permissions to Excel

  • I don’t have PowerShell access but when I attempted the initial instruction the export feature does not turnup

  • Thank you very much 😀 🙂

  • How to add Permission Levels at owssvr.iqy ?

  • 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.

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


Leave a Reply

Your email address will not be published. Required fields are marked *