Is there a way to export the space directory list into CSV?

[Andrew Zimmerman]

I'm just wondering if there is a simple way to export a list of active Confluence spaces into a simple CSV. Ideally, it would be directly from the Space Directory where the space name, key, description, and category are shown.

Anything like this possible?

[Prashant Sultania · Accepted solution]

Hello @Andrew Zimmerman _Appfire_

There isn't any option in confluence to fetch the complete list of active confluence spaces into CSV format.

By the way, there is one option to fetch the list of the active spaces from the database below SQL query will help to identify those spaces. It will give you space_id, space name, etc.. you will need to modify the SQL query a bit as per your requirement.

In SQL Developer, right-click on the result/output section and select export and select .csv format.

I found it on the Atlassian documentation:

https://confluence.atlassian.com/confkb/how-to-get-a-list-of-all-the-active-personal-spaces-938860816.html



Thanks

Note: Upvote, Like or Accept Answer if it resolves your query.

[Andrew Zimmerman]

Got it. Thanks, @Prashant Sultania. 

[Mirka Osojca]

@Prashant Sultania in the linked article it is marked as 'only for Server version'. I need something for Cloud instance, as this is really hectic to go through the spaces and pick those that belonged to once active users. Also it would be useful to see how much MBs is each of these spaces taking up. You think that @Atlassian is going to do something about it?