It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

User list export from Confluence

Hi Team,

We're doing some audit of users in our confluence_users list, I would like to know is there a way to export it from portal to an excel file or CSV file format? Thanks.

 

3 answers

1 vote
Scott_Theus Community Leader Feb 01, 2019

Hi @Christine Cagakit-Ingco,

You can export the users from the Site Administration tools if you are a site-admin. You'd go to user management, click on Export Users, and select check box for "Group Membership" and the drop-down for your Confluence Users group.

Hope this helps, 

-Scott

Bill_Bailey Community Leader Feb 02, 2019

N.B. I think that only applies to the Cloud version. I don't find the same option for the server version.

Yes, same here, I don't see the option. Confluence version is 6.13.0

Scott_Theus Community Leader Feb 28, 2019

In that case I think you need to use a third party app to export the users to CSV. There is a free one here:

https://marketplace.atlassian.com/apps/126/bulk-user-upload-management-utility?hosting=server&tab=overview

-Scott

Like # people like this

A server method...

1. Open a blank Excel sheet

Note: This was done in Confluence (Data Center) v6.15.4 and logged in as a Confluence Admin

2. Using KEYSIGHT ADMIN SUPPORT (v1.9.4) Free App; Note: version is not supported in DC. Go to the Active User List.

3. Let it completely generate the user table under "Has Logged In" 

4. With your mouse, highlight the first couple of rows within the table.

5. Hold down the Shift key and scroll all the way to the bottom of the table and select the right-most table cell. (You should have all the fields in the table highlighted.) You can let go of your shift key now...

6. Copy "Ctrl C"

7. Go to your open Excel sheet and land your cursor in cell A2

8. Select Paste Options then select Paste Special... Then select the "Text" option (It should paste in the formatted rows below A2 and across)

9. Add the header in A1 and across(Count, Login Name, User Name, Last Login and Logged in X Days) to your list so you can sort and filter.

Hi,

You can use the Confluence User Export to do the export. It supports JSON, CSV, XML and XLSX.

Regards

Lasse Langhorn

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

What project did you transition or start on Confluence with the shift to remote work?

It’s been great to hear from fellow users over the last few weeks about the best tips and fun moments you’ve had working on Confluence since the transition to working remote. I’d love to keep the c...

109 views 3 7
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you