How to Export a SharePoint User List to Excel

There may come a time when you may need to export your user list to excel.  It’s not that difficult.

  1. Copy the following path into notepad/word pad:[LISTID]&View=[VIEWID]&CacheControl
  2. Minimize the text editor and navigate to Site Actions à Site Setting à People and Groups à All People.
  3. Click Settings on the option bar and click List Settings
  4. Click on “List View” under views.   This will take you to the “Edit View” screen
  5. Copy the url of the list view.  It will look similar to the following:
  6. Copy the “List” and “View” IDs for the url that was created in step 5.  You list id will follow “List=”.  The same applies for the view id.  Here is the example from above: List=%7B02ACF6F6%2D8343%2D4244%2D81B8%2D68BF95F9C6D0%7D&View=%7B56BB9BDD%2DABB0%2D4CB6%2DA946%2D59A85A8EC2F9%7D
  7. From this example, copy %7B02ACF6F6%2D8343%2D4244%2D81B8%2D68BF95F9C6D0%7D and replace [LISTID] from step one.  This includes replacing the LISTID and the brackets.  Also, do not include the & symbol.  Follow the same steps for the “View”.
  8. Once you have finished, your completed url should look like this:
  9. Open a browser, and copy and paste the completed url that you completed in step 8.
  10. A window will pop up asking you to open or save the file.  Click open and the file will open in excel.
  11. A security warning will also pop up.  Click enable.






12.  After you are finished making your changes, you can save this like any other Excel file.




11 thoughts on “How to Export a SharePoint User List to Excel

  1. I just tried this and get the following error….what am I doing wrong? Have you seen this before? Thanks for your help.

    Internet explorer cannot download owssvr.dll from sitename
    Internet explorer was not able to open this internet site. the requested site is either unavailable or cannot be found. Please try again later.

  2. Hi
    Is it possible to export the users of a particular group with the GroupMembership ID ?

    Any Ideas ?

    Thanks in Advance.

  3. I try it its very good but i want that when i export Auto open exel and the window to print the table who i do it?

  4. it’s work.. great article.., now i can get all email address from all user on AD and sharepoint

  5. hi, great tips. but actually i was looking for a solution how to export a sharepoint list to excel including email addresses (site column is person/group). At the moment the email adresses show up as ‘lastname, firstname’. could you help me?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.