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; } } }

Count of Pages in a Space

Christopher Taverna

I would like to get a count of the number of pages in a space and place it on a page. I'm guessing writing a macro will accomplish this but I am not sure how to write it. I've looked over all of the documentation, but it hasn't really helped.

On the page itself it would look like: "There are {PageCountMacro} pages in this Space." and rendered it might look like: "There are 8 pages in this Space." if there were 8 pages in that particular space...

Accepted answers

All comments

AnnWorley

Hi Christopher,

I found a similar question in the Community which had lots of answers: How many pages in a space? Some user macros were recommended, including Count pages in space. So you may not have to write your own macro.

Thanks,

Ann

Christopher Taverna

Thank you Ann! I've tried $spaceManager.findPageTotal($space) which does return a number. However, it appears to be returning a number that is double the number of pages. Any suggestions?

Update - I tried on a few other spaces, and it is not always double the number, but it is always more... I don't have any pages in the trash, so that shouldn't be an issue.... Thank you!

Max Haley

Hello,

I have just found that if you create an 'index' using the '/index' option, it will give you the number of pages start start with each letter of the alphabet. You can then just knock the total up in calculator

Hope it helps.

Yuri Makaruk

Always amazed by the ability of Confluence to make simple operations difficult to do)))

unknown

A silly but functional workaround to find how many pages are in a Confluence space:

1. Click "Space Settings"

2. Click "Export space"

3. Click "PDF"

4. Click "Next"

5. Click "Custom Export"

6. Click and hold down the mouse button before the title of the first page at the top of the list

7. While holding down mouse button, hit "End" key

8. While holding down mouse button, drag cursor to the end of the last page title in the list

9. Ctrl/Cmd+C to copy the text

10. Open Microsoft Word

11. Paste text into Microsoft Word

12. Remove any incidental line breaks at the top or bottom of the list

13. Use the "Word Count" function, this will count the number of lines, since every page is on its own line, this will give you a total page count for your Confluence space

Angela L_

This worked for me, but I found a few ways to make it simpler. After you copy the list of pages (step 9 above):

Paste it into Notepad or some other similar program to strip out all of the formatting.
Then copy and paste it into Excel.
Scroll to the bottom of the spreadsheet, and ta-da! The bottom row is your page count.

Dragos Suciu

Hi there,

A quick note to this workaround. I've just discovered that pages with edit/view restrictions (or inherited restrictions from parent pages) will not be displayed on this list.

If you want to be sure you have all pages displayed, go to 'Space Tools' > 'Content Tools' > 'Reorder Pages' and expand all collapsed pages in the tree. Then you can copy this list and follow the tip above.

Alternatively, if you have access to the database, it's easiest to just run this query:

SELECT c.CONTENTID, c.TITLE
FROM SPACES s
JOIN CONTENT c ON s.SPACEID = c.SPACEID
WHERE s.SPACEKEY = '<space_key>' 
AND c.CONTENTTYPE = 'PAGE';

Hope this helps!

Johan Theunissen

Why isn't this a simple metric on a space!

Tia Marciel

If you have Confluence Cloud Analytics:

To find the number of pages in a Confluence Cloud space,

Use the Space Analytics feature (for Premium and higher) by:
Navigate to Analytics in the space's left-hand menu.
Check the "Pages" overview for a total count or exporting the list for manual counting.

Or, site administrators can generate a comprehensive Space Report from Confluence Cloud administration to get page counts for all spaces.