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

Salaudeen Rajack

Salaudeen Rajack is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

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

  • September 13, 2021 at 6:10 PM

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

  • May 5, 2021 at 10:34 AM

    Thank you very much 😀 🙂

  • September 28, 2020 at 7:06 AM

    How to add Permission Levels at owssvr.iqy ?

  • November 20, 2019 at 10:04 PM

    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.

  • August 8, 2019 at 7:36 AM

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


Leave a Reply