How to Export a SharePoint 2007 User List to Excel

We almost all faced this question from our users, “can you extract me the list of accounts we have in our site collection?”.

You can easily display the list of users by going in Site Actions > Site Settings > People And Groups, but there is no easy way under WSS 3.0, MOSS 2007, SharePoint Foundation and Server 2010 to export user list.

Here is the trick to export the list of users:

1. The following url will make the extraction:

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

You just need to replace the [site], [LISTID] and [VIEWID]. You may guess what [site] is :-)

2. To get the other elements, go on Site Actions > Site Settings > People and Groups and click on All People on the quick launch.

3. Go to Settings > List Settings

4. Go down to Views section and click on List View. This will bring you to the Edit List page.

5. If you check on the page url, you can identify the "List=" and "View=". Copy those ID’s and replace placeholders on the url given in step one.

6. Navigate to this created url. You will be prompted to open or save the Internet Query File owssvr.iqy file that can be opened with Excel.