How can I export group members to an excel file without a direct db query?

Ellen Krischer May 3, 2023

I understand from previous questions that it used to be possible to export a list of the members of a group into an Excel file.  Where would this feature be located?

I am on Confluence cloud and I am working with groups under Directory->Groups.

I can put a list on a page, but that doesn't get me what a want - an Excel file where each group member is on a separate line.

Thanks in advance!

1 answer

1 accepted

1 vote
Answer accepted
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 3, 2023

Hello @Ellen Krischer 

Welcome to the Atlassian community.

You can get that information from https://admin.atlassian.com, if you have sufficient access.

After access that page, select your site.

Then select Users under User Management. That should display a list of users for your site.

There should be an Export Users button above the list. Click it.

You can then select the setting for exporting uses from specified group(s). This process will create a CSV file that you can open in Excel.

Screen Shot 2023-05-03 at 1.16.59 PM.png

Ellen Krischer May 8, 2023

Thanks - that worked!  But a couple of notes about possible future improvements:

-- The 'Export button' is not obvious to find unless you know it is there as it is hidden under the "..."  

- From an 'ease of use' standpoint, the export function for groups should live on the "groups" menu.  It is not at all intuitive that you would look under a menu for all users when you want a listing for groups.

Thanks again.

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 8, 2023

Hello @Ellen Krischer 

Since this is a user community you may want to provide that feedback directly to Atlassian by contacting their technical support team through

https://support.atlassian.com/contact/#/

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events