How to Export the Members of a Group into a Spreadsheet

%3CLINGO-SUB%20id%3D%22lingo-sub-5250%22%20slang%3D%22en-US%22%3EHow%20to%20Export%20the%20Members%20of%20a%20Group%20into%20a%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-5250%22%20slang%3D%22en-US%22%3E%3CP%3EOne%20need%20that%20came%20up%20in%20the%20old%20IT%20Pro%20network%20was%20exporting%20the%20membership%20of%20a%20Yammer%20group%20into%20a%20spreadsheet.%26nbsp%3B%20There%20are%20several%20methods%2C%20including%20calling%20the%20well%20documented%20APIs%2C%20%3CA%20href%3D%22https%3A%2F%2Fdeveloper.yammer.com%2Fdocs%2Fusersin_groupidjson%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Eone%20based%20on%20group%3C%2FA%3E%20and%20the%20other%20%3CA%20href%3D%22https%3A%2F%2Fdeveloper.yammer.com%2Fdocs%2Fdata-export-api%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ebased%20on%20exports%3C%2FA%3E.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20it%20originally%20came%20up%2C%20I%20composed%20the%20guide%20attached%20to%20this%20post%2C%20based%20on%20the%20first%20API%20I%20mentioned%20above.%26nbsp%3B%20Honestly%20this%20is%20something%20any%20administrator%20is%20capable%20of%20doing%3B%20you%20don't%20really%20need%20to%20be%20some%20big%20engineer.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20then%2C%20I've%20learned%20that%20instead%20of%20using%20JSON%2C%20you%20can%20use%20XML%20and%20open%20the%20files%20directly%20in%20Excel%20and%20convert%20to%20a%20spreadsheet.%26nbsp%3B%20It's%20really%20not%20complicated%2C%20and%20if%2Fwhen%20I%20get%20the%20time%20I'll%20update%20the%20document%20and%20post%20it%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20encourage%20others%20to%20note%20their%20solutions%20as%20well%2C%20as%20they%20are%20excellent.%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F3761%22%20target%3D%22_blank%22%3E%40Antoine%20Snow%3C%2FA%3E%2C%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F3260%22%20target%3D%22_blank%22%3E%40Joe%20Francis%3C%2FA%3E%2C%20and%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F335%22%20target%3D%22_blank%22%3E%40Julian%20Knight%3C%2FA%3E%2C%20would%20you%20please%20be%20so%20kind%20as%20to%20add%20your%20thoughts%20to%20this%20thread%20for%20cohesiveness%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-5250%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAPI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EREST%20API%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EYammer%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-9420%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Export%20the%20Members%20of%20a%20Group%20into%20a%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-9420%22%20slang%3D%22en-US%22%3E%3CP%3EI%20wrote%20this%20info%20out%20here%20to%20be%20easier%20to%20consume.%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Fnetwork.office.com%2Ft5%2FYammer%2FHow-to-Export-the-Members-of-a-Group-into-a-Spreadsheet%2Fm-p%2F9418%23M522%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fnetwork.office.com%2Ft5%2FYammer%2FHow-to-Export-the-Members-of-a-Group-into-a-Spreadsheet%2Fm-p%2F9418%23M522%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-6804%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Export%20the%20Members%20of%20a%20Group%20into%20a%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-6804%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F3761%22%20target%3D%22_blank%22%3E%40Antoine%20Snow%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20checked%20out%20the%20article%20that%20you%20sent%20and%20on%20the%20surface%20it%20looks%20great%20but%20none%20of%20the%20links%20appear%20to%20work%20anymore.%3C%2FP%3E%3CP%3EAny%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-5628%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20Export%20the%20Members%20of%20a%20Group%20into%20a%20Spreadsheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-5628%22%20slang%3D%22en-US%22%3E%3CP%3ETo%20add%20to%20this%20-%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20those%20who%20would%20like%20to%20get%26nbsp%3Ba%20bit%20more%20out%20of%20their%20data%20exports%2C%20utilizing%20PowerBI%20in%20conjunction%20with%20the%20export%20method%20outlined%20by%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F55%22%20target%3D%22_blank%22%3E%40Tom%20Kretzmer%3C%2FA%3E%26nbsp%3Bis%20extremely%20powerful.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20use%20the%20excel%20spreadsheet%20as%20a%20data%20set%20that%20you%20can%20then%20manipulate%20the%20raw%20data%20and%20create%20visualizations%20based%20on%20the%20content.%20It%20does%20require%20the%20creation%20of%20relationships%20between%20the%20data%20points%2C%20but%20once%20that's%20done%20PowerBI%20will%20give%20you%20so%20much%20more%20out%20of%20your%20data.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDashboards%20can%20also%20be%20created%20surrounding%20this%20data%20and%20shared%20out%20with%20the%20appropriate%20admins%2Fusers%2Fetc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20additional%20information%2C%20check%20out%20%3CA%20href%3D%22https%3A%2F%2Fblogs.msdn.microsoft.com%2Frichard_dizeregas_blog%2F2014%2F04%2F09%2Fyammer-analytics-with-excel-and-power-bi%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ethis%3C%2FA%3E%20article.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20a%20tad%20bit%20dated%20but%20contains%20the%20basis%20behind%20everything%20discussed%20above.%20I%20personally%20vouch%20for%20this%20as%20this%20is%20what%20I've%20implemented%20in%20my%20company.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20to%20Tom%20for%20starting%20this%20thread!%20I%20hope%20I've%20helped.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Contributor

One need that came up in the old IT Pro network was exporting the membership of a Yammer group into a spreadsheet.  There are several methods, including calling the well documented APIs, one based on group and the other based on exports

 

When it originally came up, I composed the guide attached to this post, based on the first API I mentioned above.  Honestly this is something any administrator is capable of doing; you don't really need to be some big engineer.

 

Since then, I've learned that instead of using JSON, you can use XML and open the files directly in Excel and convert to a spreadsheet.  It's really not complicated, and if/when I get the time I'll update the document and post it here.

 

I encourage others to note their solutions as well, as they are excellent.  @Antoine Snow, @Joe Francis, and @Julian Knight, would you please be so kind as to add your thoughts to this thread for cohesiveness?

3 Replies

To add to this - 

 

For those who would like to get a bit more out of their data exports, utilizing PowerBI in conjunction with the export method outlined by @Tom Kretzmer is extremely powerful. 

 

You can use the excel spreadsheet as a data set that you can then manipulate the raw data and create visualizations based on the content. It does require the creation of relationships between the data points, but once that's done PowerBI will give you so much more out of your data. 

 

Dashboards can also be created surrounding this data and shared out with the appropriate admins/users/etc.

 

For additional information, check out this article.

 

It's a tad bit dated but contains the basis behind everything discussed above. I personally vouch for this as this is what I've implemented in my company.

 

Thanks to Tom for starting this thread! I hope I've helped.

@Antoine Snow

I checked out the article that you sent and on the surface it looks great but none of the links appear to work anymore.

Any ideas?