Exporting Spaces from Confluence to Excel Spreadsheet

[TJ Shanahan]

Hi All,

Is it possible to export the Spaces names into a spreadsheet? Possibly a macro or plugin? (without having to copy every single name click by click from confluence)

Thanks,

TJ

[Earl McCutcheon · Accepted solution]

Hi TJ,

This might prove to be difficult, since the content from Confluence export will not necessaly be on a table. The best thing I can think of would be to export the data to XML and import it to Excel.

[Rodrigo Girardi Adami]

Hi TJ,

You can export the results of the query below to a XLS spreadsheet which will contain just the spacenames:

SELECT spacename FROM spaces INTO OUTFILE 'path_to_file/example.txt';

Cheers,

Rodrigo

[Elisa [Atlassian]]

Hi,

You can do the XML export. First, find the space you want to export. When you are on it, click on Browse (upper menu) > Space Admin > Space Operations and then XML export.

Hope this helps! :)

Cheers!