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! 😊

[Solved]

Hey! Confluence Cloud's UI does not support exporting filters directly through label results. A common solution is to use the Confluence REST API to retrieve pages by label and then export the data to CSV or Excel. Otherwise, some marketplace apps can help make it easier.

[Mattia _Communardo_]

Hello Laura,

If you're willing to use a third-party app, our Viewtracker app offers the Content & Usage Report. This report allows you to filter by label and export the results as a CSV file.

Kind regards,
Mattia

[Barbara Szczesniak]

@Laura Jiménez I found a way to get the information in a nice table, but not to copy it to paste into Excel:

If you use the Content manager feature under Space settings, you can select a Label in the dropdown to get a table with all pages with that label. You can also specify a page Status, Owner, and More filters, along with what Columns you want to include in the table.

However, there is no way I can see to select the information displayed in the table to copy it anywhere. ☹️ If you didn't want to export it to Excel, this would be ideal. Maybe someone else knows of a trick to do this.

[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!

---

---

---