Export Groups

Path: Community Topbar >> Apps Icon >> Reporting >> Export data >> Export Groups

The export groups report displays a report with detailed information on all groups within the community along with activities and other data. Data can be generated in Excel or XML format. Clicking on Export Data will generate a link to the file which can then be downloaded. The file can be accessed at a later date from Reporting >> Data Export Log.


1) Output format: Idea data can be exported in the following formats

  • Microsoft Excel sheet (.xls) format

  • XML (RSS 2.0)

2) Group Type: The group type can be selected depending upon the data you wish to export. It can be All Group Types, Groups, or as per Group Based Moderation.

By selecting the "Groups" option, you will be able to specify particular group reports that you wish to export. 

Screenshot 2025-01-23 at 1.14.52 PM

3) Select your timezone: You may select your preferred timezone for viewing the exported data, allowing for a more personalized experience instead of adhering to the community's default timezone.

Fields on Exported Excel sheet

Sheet 1:
The first sheet contains all the groups created in the community with its name, the number of members assigned to the group, member assignment method, and if the group is private.

Sheet 2:
The second sheet onwards contains each group's details in a different sheet with the following columns member id, email address of the member, username, display name, registered date and time, source, status, ideas, votes, and comments.

Last Updated: January 30, 2025