nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Exporting a CSV from Confluence of all the articles, their owners and when they were last updated

andrea_hermansson

We host our internal help centre in Confluence and I want to be able to export a CSV file with the titles of the articles, the owner/author, and the date when it was last updated, so that I can manage our help centre better (I'm also revamping the help centre and it's easier being able to pull it out of Confluence in order to plan recategorising etc)

I was able to export the whole space, but this only gave me a document with the titles but not any other information. Is there a way to export a file with the contents of the space, along with the details of who wrote them and when they were last updated?

Accepted answers

Kristian Klima_gtcuat

HI @andrea_hermansson and welcome to the Community

You can create a databse of all pages in your space (you can read my Community article about how to do that here - it's from mid last year so some elements might look/act different but you should be able to achieve the goal).

Once you have the database, you can configure the columns to show owner, last updater, dates, etc.

Then you can export the whole DB with all details as a CSV file. But it's manageable - I know as I have a DB exactly like that

The only downside is that, as far as I know, there's no way to automate adding new pages into a databse.

Various space manager apps that I know do not offer export feature but the Marketplace is big so there might be something.

All comments

Kristian Klima_gtcuat

HI @andrea_hermansson and welcome to the Community

Once you have the database, you can configure the columns to show owner, last updater, dates, etc.

Then you can export the whole DB with all details as a CSV file. But it's manageable - I know as I have a DB exactly like that

The only downside is that, as far as I know, there's no way to automate adding new pages into a databse.

Various space manager apps that I know do not offer export feature but the Marketplace is big so there might be something.

andrea_hermansson

Hi Kristian!

Thank you so much for your help here. I wasn't even aware I could set up a database in Confluence.

It doesn't seem like it's possible to add the HTML into the DB the way you have described anymore, and I can only really add the articles one by one into the page link field. Connecting it with Confluence doesn't let me filter and choose content by space and importing CSV only imports to text fields. I can see other commenters have mentioned this on your article, so will keep an eye on any updates there

For now, I can manually add the articles and get the information and use I need from the database, so this solves my problem. Thank you!

Kristian Klima_gtcuat

Hi @andrea_hermansson

So I connect Confluence, it loaded all pages from Confluence... then I organized the DB by Space, selected pages from the spaces I did not want, deleted the content and was left with the space I wanted.

Edit, actually, applying filter worked too

I deleted the pages BEFORE without saving the view with the filter applied.

I need to update the article.

Thanks!

andrea_hermansson

Ah! That's it. Saved me loads of time. Thank you!

Adrian Hülsmann - B1NARY

Hi @andrea_hermansson

Besides the method mentioned by Kristian, you might look at the data export functionality of Breeze.

While the main use cases of Breeze are Confluence review and approval workflows, it also provides a simple, yet powerful CSV data export feature, giving you both a high-level overview of your space data, or a more detailed page-level export.

Based on your questions, I think the page-level export is what you are looking for.

It includes:

Space key
Space name
Space owner
Page ID
Page title
Status
Created at
Last viewed
Last updated
Page creator
Last contributor
All contributors
Page owners
URL
Labels

You can give Breeze a try via the Atlassian Marketplace or schedule a personal demo with me to see if it fits your purpose.

All the best,
Adrian from B1NARY (we are the developers of Breeze)

Keeley Sorokti

We use Breeze for this purpose and it is fabulous!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

confluence%2ccloud