Can I pull details from a page into a spreadsheet?

Tamara Witkowski
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 22, 2024

We create pages for contracts to track year over year cost and to document the approval process. There are details from several documents that we enter into a table in the page. I would like to pull the details from this table into one spreadsheet and eliminate a process of manually adding the information to the spreadsheet for reporting purposes. 

Our current process requires a lot of manual entry and we are having a lot of entry errors with this process. I'm looking to improve the process for all involved.

2 answers

2 votes
Shawn Doyle - ReleaseTEAM
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 22, 2024

Hi @Tamara Witkowski 

Take a look at Page Properties and the Page Properties Report Macros.

This would allow you to have a report on one page that has all the different page tables values.  At this point you could export it to a spreadsheet if needed.

https://support.atlassian.com/confluence-cloud/docs/insert-the-page-properties-report-macro/

0 votes
Tomislav Tobijas _Koios_
Solutions Partner
Solution Partners provide consulting, sales, and technical services on Atlassian products.
November 22, 2024

Hey @Tamara Witkowski ,

To say if it's possible or not, it kinda depends on how the tables are actually structured and used.
Nevertheless, the best native solution I can think of is Confluence Databases.

For example, you would have one database that would contain all data, and then on each page, you would have a separate entry from that database. This entry can be editable from within that page, but all data you enter there is also 'reflected' to the complete database which you can then use for reporting.

2024-11-22_21-15-31.png

Apart from that, Atlassian Marketplace might be a good place to search for solutions. I just can't give any suggestions as we didn't encounter this specific scenario.

Cheers,
Tom

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events