Is there a way to export the data in a 'page properties report' macro?

[Sandra Lawrence]

I am using the page properties report macro to organize and display a concentrated list of project (like a portfolio).

I have Leadership that is interested in exporting this data to either an excel or other output.  Not the whole page, just the data in the macro.  Is this possible to do without buying an app or addon (I need to find a solution out-of-the-box).  Thanks!

[Katerina Kovriga {Stiltsoft}]

Hi @Sandra Lawrence ,

Maybe one of the options will be to create another separate page just for exporting to Word or PDF and duplicate your Page Properties Report there.

If you need to export manually created tables, then you may use Excerpt/Excerpt Include macros - place the Excerpt Include macro on the special page for exporting, show (reuse) the required table and export the page.

Nothing more comes up to my mind if we consider only out-of-the-box solutions.

What concerns the 3rd party apps, of course, we can suggest trying our own addon - Table Filter and Charts for Confluence.)))

The app supports the dynamically changing tabular macros (such as your Page Properties Report) and you'll be able to filter it, aggregate and visualize your data. The export options are also very flexible, you'll be able to export both the source table and the result dashboards.

[Tiele Declercq]

Hi, I was struggling with the same issue and managed to get 'something'.

Actions I took:

1. Open your browser DevTools
2. Search for a value listed in this table
3. Locate the TABLE element
4. Right click and copy outerHTML
5. Paste into a text editor and safe as HTML file
6. In excel, Data, From Web
7. Paste the path to your locally saved HTML file
8. Select the second element next to Document
9. Load

Tadaa.. 

[Bruno Bellini]

Using Google Sheets it works just making an import of the HTML file

Nice trick @Tiele Declercq !

[Kishan Sharma]

Hi @Sandra Lawrence Using out of the box functionality, you can only export whole page to Word or PDF format, post which you can manually copy paste the text into an excel. I know there is lot of manual effort required if you have large number of pages, but this is the most you can do with the built-in functionality.