How to export certain parts of a confluence page into a table?

[Vera Sinnamon]

Hi,

I'd like to know, if it's possible to create several pages in a space on confluence, eg. one page per site and then export this data into a table.

All pages would have the same structure, but other details, eg contact details. I then would like to export a list so I can see all contacts over the different pages in one table/spreadsheet.

Thanks :)

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

Hi @Vera Sinnamon ,

We can also suggest trying our Table Filter and Charts for Confluence app and its Table Excerpt/Table Excerpt Include macros.

These macros are an amplified version of the Page Properties/Page Properties Report macros, they allow you to collect multiple-row tables into one master report along with the source page meta data if required.

Later this combined report can be filtered and aggregated if necessary and even exported to csv, pdf, Word formats to use it outside Confluence.

[Max Foerster - K15t]

Hey @Vera Sinnamon, and welcome to the Atlassian Community! 👋🏼

What kind of data do you want to store on each page? It sounds like contact details, that would easily fit into a two-column table. If that's the case, you can use the build-in page properties, and page properties report macros! You add data to a table in the macro and can pull it into a report based on a page label. The table exists on the page in Confluence and can even be hidden if you like. It's pretty straightforward.

That's an example of the table design on the page inside the macro

And this is an example of the report table:

You can read more about it in the Confluence documentation:

• Insert the page properties macro 
• Insert the page properties report macro 

You should definitely have a look at these macros. 🤘🏼 The only downside of page properties is that they are not very feature-rich in terms of support of other macros (like labels or the newly introduced page statuses, which you might want to use for your contacts as well!) and difficult to maintain. You will always have to edit the data on the page and cannot do this in the report itself. Like I said before, the feature is straightforward but also limited.

If you're looking for a more versatile way to easily structure and maintain that kind of information, I suggest looking at our app Orderly Databases for Confluence on the Atlassian Marketplace. In Orderly, the data exists not only on the page but in a smarter table, more like a little database, and you could also edit or add new entries/data from there. The screenshot below shows an example of a people directory in a company. We built our own internal people directory with it and a lightweight CRM. I'm sure it will also be a good fit for your use case. 😄 

On the page itself, it looks very similar to page properties:

The nice thing is that you can even switch to a different view with cards in the database table and on the page with the data itself.

If I got you curious, you find the use case documented here Create a Database for Your Employee Data and can easily adapt it.

Let me know if you have further questions. I'm happy to help. :)

Best, Max

P.S. I totally forgot to mention that you could also maintain the information in the database only and then maybe just pull an entry onto a page where necessary. Or re-use one entry of the database on multiple pages. That's something you would have a hard time with using page properties as it causes duplicate entries in the report.

[Vera Sinnamon]

Hi Max,

This is awesome! I started using this, however still got a few questions. I'd like to have one Confluence page per site, however different headings within the page, eg. site details, metering details. 

Do I create different data bases for each heading? If yes, that's what I did, but it will only show one database on the confluence page.

Thanks,

Vera

[Max Foerster - K15t]

Hey @Vera Sinnamon

You should have an email from me in your inbox, let's get your questions answered in a call. 😄

Best, Max

[Fabio Racobaldo _Catworkx_]

Hi @Vera Sinnamon ,

welcome to the Atlassian Community!

My suggestion is to add a specific label to each single page and retrieve all of them through a search via CQL.

Hope this helps,

Fabio