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 - Information Technology Expert with Two decades of hands-on experience, specializing in SharePoint, PowerShell, Microsoft 365, and related products. Passionate about sharing the deep technical knowledge and experience to help others, through the real-world articles!

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

  • I also do not have the option to select Export to Excel. Is there a solution for this?

    • Same here, but I just clicked and held the left mouse button, and dragged the selection over all of the groups. Copied and pasted as values into a blank worksheet – rough and ready, but it worked!

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