Export a SharePoint User List to an Excel Sheet

In this post I'm going to explain an easy way to view a list of SharePoint Users in an Excel sheet.

First go to Site Actions and select Site Settings. Then select People and groups under the Users and Permissions category

Then go to Settings and then select List Settings.

Then you will get the List Settings page. Go to the bottom of that page and select List View under the Views category

Then you will get the Edit View of the List Settings. Now copy that page URL and copy paste it on a notepad.

Example URL :

http://camintdev01.domainx.local/_layouts/ViewEdit.aspx?List=%7BA1EA3A11%2D7F67%2D40BE%2D890B%2D7DB85EDDA7FF%7D&View=%7B8914C42E%2D5E0D%2D41D2%2D80C7%2D75E302D91FEE%7D&Source=%252F%255Flayouts%252Flistedit%252Easpx%253FList%253Da1ea3a11%252D7f67%252D40be%252D890b%252D7db85edda7ff%2526Source%253Dhttp%25253A%25252F%25252Fcamintdev01%25252Edomainx%25252Elocal%25252F%25255Flayouts%25252Fpeople%25252Easpx%25253FMembershipGroupId%25253D5

Now get the Site Name, List ID and the View ID from that URL

Example:

Site Name : camintdev01.domainx.local

List ID      : %7BA1EA3A11%2D7F67%2D40BE%2D890B%2D7DB85EDDA7FF%7D

View ID    : %7B8914C42E%2D5E0D%2D41D2%2D80C7%2D75E302D91FEE%7D

Then copy the below URL and add the Site Name, List ID and View ID to the correct places.

 http://[site]/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=[LISTID]&View=[VIEWID]&CacheControl

Example URL:

http://camintdev01.domainx.local/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=%7BA1EA3A11%2D7F67%2D40BE%2D890B%2D7DB85EDDA7FF%7D&View=%7B8914C42E%2D5E0D%2D41D2%2D80C7%2D75E302D91FEE%7D&CacheControl

Navigate to the above URL and then download and save the owssvr.jqy file. Finally open it in Excel. Now you  can view the SharePoint Users list.