I would like to export the User Information List to a file including the ID of each user. It doesn't matter if the solution is in C#/PowerShell/SharePoint UI.

1 Answer 1


  1. Go to "Site Settings -> Users and Permissions -> People and groups"
  2. Click on the "Settings" menu and "List Settings"
  3. Scroll to the bottom of the page and click on the view that you want to export.
  4. Copy the url and in particular the List and View IDs


  5. Go to the following url "http://[sitename]/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=[LISTID]&View=[VIEWID]&CacheControl=1" replacing sitename, listid, and viewid with your own information.

  6. When opening this in the browser you will get a save to excel option and from there you just have to open the file.

I got my solution from Explore the SharePoint and SharePoint Blogs.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.