SharePoint
provides you “Export to Spreadsheet” feature across almost all list, allowing
you to export your list content to Excel. But not all lists have such
functionality. For example, this option is not available for User list.
Here
are the details:
We
can achieve this by using two methods:
1.
OWSSVR Functionality
2.
Open with access
OWSSVR Functionality:
This
export functionality is just using owssvr.dll, so you can use the following URL
to open your users in Excel
Everything
you need is getting the right ID of the list and its view. To get these values
follow the next steps:
·
Go to the “People
and Groups” page of your site
·
Navigate to
“Settings->List Settings” options via Toolbar
·
Click on “List
View” in “View” section to edit the List View.
·
Choose the fields
you want to export (need to click OK and open view for edit again)
·
Copy the “List”
and “View” IDs from URL in this the page, where you edit List View.
·
Save copy-pasted
ID and replace [LISTID] and [VIEWID] in our URL.
·
Open original URL
http://[site]/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy
in browser, with the right values
Open with access method: this is the most
simple method to extract the data.
·
Open any custom
list by using the option “open with access”
·
When the list
will open in access then you will see the option of “user information list” in
the left hand side.
·
Copy and paste it
in excel and that’s it. You are done.
