Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

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, 


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.

Like Nicolas Casel likes this

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

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:


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.


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


Lasse Langhorn

hi Lasse

We tried this plugin in our on-prem Server instance and it is working great.

Currently this plugin can only be accessed by someone with System Administrator access. How do we allow access to someone with Confluence Administrator access? 

Please advise.

Hi @Lai Feng Min

This is currently not supported but I will look into supporting this.


Lasse Langhorn

Like # people like this

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence

🏑 Atlympic Event: Confluence

Hello Community!  Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...

517 views 18 17
Read article

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