Here is the shortcut to export SharePoint users and groups permission to Excel.
- Open your SharePoint site in Internet Explorer. Navigate to either site permissions or any User group.
- Right-click on the users list page, choose the “Export to Excel” item.
You may need to reformat it a bit! Here is it would look like:
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