Contents
1 Answer
- Go to “Site Settings -> Users and Permissions -> People and groups”
- Click on the “Settings” menu and “List Settings”
- Scroll to the bottom of the page and click on the view that you want to export.
- When opening this in the browser you will get a save to excel option and from there you just have to open the file.
What is User Information List? As per the Name SharePoint User Information List stores information about a user by having some metadata set up for the user. Some examples are User Picture, Email, DisplayName, LoginName etc. For a complete list of fields, see further down this blog.
How to get all users from Site collection?
Below is the code to get all users using Pnp-PowerShell. This will list all the users as below. These are the ways to list all users from SharePoint Site Collection using PowerShell. Also, you can find some More PowerShell script examples related to SharePoint.
Where can I find the SharePoint user information list?
The list is available in SharePoint 2013, SharePoint 2016, and guess in SharePoint 2019 and SharePoint Online also. How SharePoint User Information List gets data? As soon as you add/grant access to a user at subsite/ Site Collection level SharePoint added a new entry in this list with the latest information of that user from AD.
By using a below PowerShell Script, you can download all users from SharePoint site collection in CSV formatted file.
Just replace the value for “MembershipGroupId” to “0” to get the “All People” view which lists all users of the site (which is nothing but “User Information List”). From here, Get the GUIDs of your User Information List and view. Here is How to Get the GUID of SharePoint list or View?