Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,298,379
Community Members
 
Community Events
165
Community Groups

Exporting the complete list of my Confluence users

Hi,

I'm trying to export the complete list of my confluence users. Is there a way to do this other than cut and pasting from the user management screen? I'm trying to find duplicate accounts and doing it that way takes a while.

If I could export the whole list, I could do some manipulations and get to the data I need quicker.

Any suggestions are welcome.

Thank you

Pierre

2 answers

1 accepted

Hello, @Pierre Rochefort 

For Server or Data Center – feel free to use our User Management for Confluence app on evaluation license for free

In Bulk User Actions screen there is functionality to export users and their groups to CSV in bulk, including in formats suitable for import into Crowd and providing to Atlassian Support for Cloud migrations when not using CCMA.

Do note that your own user won't be exported (for historical security reasons).

If you have any questions please don't hesitate to reach out to our 24x7 support

This is exactly what I needed. This will save me a lot of time.

Thank you again for this answer.

Have a great day

Pierre

0 votes
carlosughini Community Leader May 16, 2022

Hi Pierre,

I'm not sure if you are using Confluence Server or Cloud, so I will provide the solution for both.

Cloud

To export on Cloud, you can just access the User Management page and click on ... > Export Users:

Screen Shot 2022-05-17 at 7.45.03 am.png

Server

For Server, unfortunately, there is no built-in functionality to export the users. One of the solutions might be to use Confluence User Export to do the export of Confluence users. It support JSON, XML, CSV and XLSX. But I never tried it.

The other is by following this documentation that shows you some queries that can be used in the database to gather the data from the users.

Please give it a try and let me know how it goes.

Regards,

Carlos

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
7.13.5
TAGS
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

181 views 1 3
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