Is there a way to export a SharePoint group to an excel file?

Posted on 2009-02-16
Medium Priority
Last Modified: 2012-05-06
I am going to export a SharePoint Group to an excel file and it is not working.  Can anyone help me?  There is no export option for security groups
Question by:PortalSlave
  • 2
  • 2
  • 2
  • +1

Expert Comment

ID: 23655692
well there is no way to export to excel, however if you are just looking to get a list of users added to the site you could run an export on the site and use the switch -includesecurity (dirrect the outpout to text >>export.txt or just look at the export.log) it should give you the list.


Expert Comment

ID: 23655693
switch is -includeusersecurity
LVL 27

Expert Comment

ID: 23655704
I'm not aware of any OOTB feature in SharePoint site or in SPD to make this happen.

You can look at some programmatic way of generating this detail:

SPSite mySiteCollection = new SPSite("http://servername/");
SPWeb site = mySiteCollection.AllWebs["Site_Name"]; 
SPGroupCollection siteGroups = site.SiteGroups; 
foreach (SPGroup group in siteGroups) 
   // this never runs!
   string s =  group.Name; 

Open in new window

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.


Author Comment

ID: 23662109
Hi MeiMc,
I did try that but we do not have SIP configured and this is for a SharePoint Security group with Contribute access.  I do not know how to grab the ListID or ViewID for this security group.  It seems like the export to excel would work but it gives all the groups and users for the site collection.  

Accepted Solution

MelMc earned 2000 total points
ID: 23662165
What is SIP?
To get the list ID
1. Go to the settings of the user list
2. At the end of the URL there is LIst = , the ID is everything after that

To get the View ID
1. Navigate to the view you want to use, choose Modify this view.
2. Everyhing after View= and before &Source is the ID

Author Comment

ID: 23672397
Hi MeiMc,
Here is some info on SIP http://www.voip-news.com/sp/itx/sipswitchfaq.htm#g1. In the example, the screenshot showed Call/Message Selected users which requires SIP to be enabled with SharePoint probably using Microsofts Live Communication Server.

I will try your suggestions.




Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses
Course of the Month15 days, 21 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question