Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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.

share|improve this question
add comment

1 Answer

up vote 7 down vote accepted

  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

    http://sitename/_layouts/ViewEdit.aspx?List=%7B64DAB4AC%2DD043%2D4DA4%2D85C7%2D9D4521C3F4CC%7D&View=%7B0FAE8D90%2D59D5%2D48F4%2DA54E%2DF02333777C7F%7D&Source=%252F%255Flayouts%252Flistedit%252Easpx%253FList%253D64dab4ac%252Dd043%252D4da4%252D85c7%252D9d4521c3f4cc%2526Source%253DhttpFlayouts%25252Fpeople%25252Easpx%25253FMembershipGroupId%25253D6

  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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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