List of Confluence pages filtered by label

[Laura Jiménez]

Hi everyone,

I’m using Confluence Cloud (Standard plan) and I need to generate a list of pages that have a specific label.

My goals are:

Get a complete list of pages that contain a given label.

Export that list to Excel (or CSV).

I’ve seen the Filter by Label macro, but I haven’t found an easy way to export the results.

Does anyone know if this can be done via the Confluence UI? Maybe with databases?

Any guidance or examples would be greatly appreciated!

Thanks in advance!

[Christos Markoulatos]

Hey @Laura Jiménez  👋

Unfortunately there’s no built-in way in Confluence Cloud to export a list of pages by label directly from the UI, but you can easily do this using the REST API.

Here’s the simplest approach:

1. Use the Confluence Cloud REST API with a CQL query:

   GET /wiki/rest/api/content/search?cql=type=page AND label="your-label"

2. Replace your-label with the label you want to filter by.

3. This will return a JSON response with all pages that have that label, including their titles and IDs.

4. From there, you can copy the data into a CSV or Excel file. If you’re comfortable with scripting, you can use Python or any language to parse the JSON and export it.

Unfortunately, the Filter by Label macro only displays results on a page—it doesn’t offer an export option.

If you prefer a no-code solution, there are Marketplace apps like Table Filter and Charts for Confluence or Table Exporter for Confluence that can help you export lists.

Hope this helps! 😊

[David Nickell]

You can use the rest API to pull your results into Excel.   I haven't done this specific set of REST calls yet (I've done a bunch), but here are the steps:

The Atlassian Piece (REST)

this call gets all the labels you have (in the event you need a list and/or need the ids)

https://developer.atlassian.com/cloud/confluence/rest/v2/api-group-label/#api-labels-get

this call gets you the pages for the label

https://developer.atlassian.com/cloud/confluence/rest/v2/api-group-page/#api-labels-id-pages-get

Here are some examples you may be able to click on (or replace the ecosystem with your URL)

https://ecosystem.atlassian.net/wiki/api/v2/labels

https://ecosystem.atlassian.net/wiki/api/v2/labels/1343493/pages

The Excel Piece

Like anything else, if you've never executed a REST call through Excel, it can be a bit intimidating. 

The code is Power Query (exact same code as is used in Power BI)

1. In short... in Excel you go to the data tab and launch power query
2. Then add a new source
3. Paste your URL and add an Authorization Header
4. Then there are a few clicks to format the results

Screen shots below

This is a very cursory glance at the steps -- I didn't want to put too much more time into it unless it is something you would like to pursue.  (I don't mind expanding the write up or providing a functional file for free -- I just want oe make sure you think you will use it before I do)

Let me know your thoughts and good luck!

---

---

---