Blog Stats
  • Posts - 40
  • Articles - 0
  • Comments - 28
  • Trackbacks - 0

 

How to Export Users inside group in Excel in SharePoint 2010

1.In SharePoint, navigate to the group you want to export.
2.Copy the URL from the browser.
3.In Excel Toolbar Goto Data > From Web and paste the URL in address and click Go.

You will see yellow arrows in the page, just select the user group table and click on import, it will import all the users in the group in Excel. It is not very fancy so you need to reformat it

The second method is simple and pretty good

1. Go to the “People and Groups” page of site
2. Navigate to “Settings->List Settings” options via Toolbar
3. Click on “List View” in “View” section to edit the List View.
4. Choose the fields you want to export
5. Copy the “List” and “View” IDs from URL in this the page, where we edit List View.
6. Save copy-pasted ID and replace [LISTID] and [VIEWID] in our URL.
Open original URL: 

URL Format:  {Site URL}/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={List GUID}&View={View GUID}&CacheControl=1


Thanks-Jayant


Feedback

# re: How to Export Users inside group in Excel in SharePoint 2010

Gravatar Tried the 2nd method - found to be very helpful once I found applicable ListId and ViewId (see http://nickgrattan.wordpress.com/2008/04/29/finding-the-id-guid-for-a-sharepoint-list/ for more).
Many thanks 1/28/2014 9:49 PM | jablob

# re: How to Export Users inside group in Excel in SharePoint 2010

Gravatar It is not working for me, my list contains some lookup columns, is it the reason or something else, please let me know how can we export list data having lookup columns..

Thanks 7/10/2014 11:03 PM | Mayank

Post A Comment
Title:
Name:
Email:
Comment:
Verification:
 

 

 

Copyright © Jayant Kumar