Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Is it possible to export Confluence table of contents into excel?

YC December 6, 2021 edited

I am required to export the table of contents for our confluence page into a index flow structure in excel. Is it possible to just fully export the entire table of contents rather than writing it out word for word?

 

 

2 answers

0 votes
Bill Bailey
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 6, 2021

Good Lord, Is this a managment request? What is wrong with a bulleted list?

0 votes
Andy Gladstone
Community Champion
December 6, 2021

@YC are you referring to an entire space's page index, or a page that has the Table of Contents macro embedded in it? I have pasted an image below depicting both. The answer will be similar based on the choice, but not the same...

Let me know so I can try to point you in the right direction.

 

Capture1.JPG

YC December 6, 2021 edited

Hi there,

 

I am trying to export the entire page's space index, so the marked section on the left would be correct. I would like to it be appropriately mapped within an excel spreadsheet, perhaps like this:

 

Using your example

Level 1Level 2Level 3  
2020 Service Leadership meeting    
 Confluence Coffee CornerTesting Confluence Options   
 Confluence KB Links and Articles   
     
     

 

 

Thank you

YC December 7, 2021

hey Andy, would really appreciate a solution. cheers

Andy Gladstone
Community Champion
December 7, 2021

@YC I was experimenting last night with different ideas. 

One was exhorting the space as .xml, and extracting the page tree. That was pretty laborious and did not produce the results I desired. 

I also tried using the Page Tree macro to create a listing on a single page of all of the pages in the space, and export that to Microsoft Word, but it only brings in the page title since the output is just coming from a Macro.

The best output actually came from creating the macro as mentioned above, and then expanding the entire page tree, copying and pasting in to Excel. 

Dirty, ugly, but accomplishes the goal. 

I have not been able to find a better method. Yet.

Like • YC likes this
YC December 8, 2021

thank you for your help

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, atlassian community, loom ai, atlassian loom ai, loom, atlassian ai, record recaps of meetings, meeting recaps, loom recaps, share meeting recaps,

Loom’s guide to great meetings 📹

Join us to learn how your team can stay fully engaged in meetings without worrying about writing everything down. Dive into Loom's newest feature, Loom AI for meetings, which automatically takes notes and tracks action items.

Register today!
AUG Leaders

Atlassian Community Events