Contents
Here is method I used.
- Navigate to the People and Groups tab under Site Settings [Site Settings > People and Groups]
- Copy the URL of the People and Groups page.
- Open up your Excel workbook, and click on the Data tab.
- Click “From Web” and paste the URL from the People and Groups page into the Address Bar.
Export SharePoint Users and Group Permissions 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.
How to export SharePoint user information into Excel?
1 Open Excel. 2 Go to ‘Data’ then ‘Get Data’ then ‘From SharePoint Online List’. 3 Put in your SharePoint site “home” directory https://sharepoint.com/sites/. 4 From the list, choose ‘User Information List’ Share Improve this answer answered Mar 26 ’19 at 17:49 Jeremy F. Jeremy F. 167 2 2 silver badges 5 5
The PersonProperties.UserProfileProperties returns all the user profile properties for the user. So in the above code snippet, we first fetch all the user profile properties for the specific user and then using the Key property we fetch all the property names for the user and using the Value we find the value for each user.
With SharePoint 2013, Microsoft has provided the ability to fetch User Profile information client side using CSOM API’s. User Profiles and user profile properties provide information about the SharePoint Users.
How to import SharePoint group members into Excel?
Click “From Web” and paste the URL from the People and Groups page into the Address Bar. After the page loads, you will see an arrow pointing to the list of group members. Upon hovering over this arrow, the list of group members will be highlighted. Click this arrow, then click Import, then OK.