Onibakuapps

Search Confluence with CQL, export to Excel

CQL Search & Table Export is a Confluence Cloud app. Find exactly the content you need with Confluence Query Language, show live results on any page, and get results or page tables into a spreadsheet in one click.

Get it on the Atlassian Marketplace

Built on Forge. Runs on Atlassian’s infrastructure.

The CQL Search page in Confluence: a query for pages and blog posts changed in the last 7 days, saved searches, 186 results in a table with title, space, last updated by and date, and Columns, Export Excel and Export CSV buttons
The CQL Search page: type a query, sort the results, export every match.

One app, three jobs

CQL Search page

Run any CQL query across your site, or build one from simple filters. Sort, pick columns and save searches you use often.

CQL results macro

Embed a live list on any page: recent updates in this space, everything under a page, all pages with a label.

Export to Excel and CSV

Export every search result, or the tables on a page, with merged cells expanded and one sheet per table.

CQL quick reference

Eight queries to start from. Paste one into the search page or a results macro and change the names.

Common CQL queries and what each one finds
You wantWrite
Pages in one spacespace = ENG AND type = page
Either of two labelslabel in ("q3", "okr")
Changed in the last 30 dayslastmodified >= now("-30d")
Untouched for a yearlastmodified < now("-52w")
Things you createdcreator = currentUser()
Titles starting with a wordtitle ~ "retro*"
Exact phrase in the texttext ~ "\"release plan\""
PDF attachmentstype = attachment AND title ~ "*.pdf"

Atlassian’s full reference: Advanced searching using CQL.

Getting started

Search

Open Apps → CQL Search in Confluence. Type a query and press Search (or Ctrl+Enter), or use Build with filters if you’d rather not write CQL. Click a column header to sort by it, and use Columns to choose what’s shown.

Save search keeps the query and your chosen columns so you can run it again in one click. Saved searches are private to you.

Embed results on a page

While editing a page, type /CQL results and pick the macro. Enter a query, press Test query to check it, choose columns, and save. The list updates every time someone views the page. Two functions make macros reusable:

A Confluence page, Engineering home, with a live CQL results list: Recently updated in Engineering, 186 results with title, last updated by, date and labels, and Export Excel and Export CSV buttons
The macro on an Engineering home page: a live list that updates itself.
Macro queries that work on any page, and what each shows
QueryShows
space = currentSpace() AND type = page ORDER BY lastmodified DESCRecently updated pages in the space the macro is in
ancestor = currentContent() ORDER BY titleEvery page below the current one
label = "meeting-notes" AND created >= now("-30d")Meeting notes from the last 30 days
The CQL results macro settings: heading, CQL query with a Test query button, an Examples list, column checkboxes, how many results to show first, and options to show the result count and the export buttons
The macro’s settings: query, columns, how many results to show first.

Export

Export Excel and Export CSV on the search page (and optionally on the macro) download every matching result, up to 10,000, not just the rows on screen. Dates are exported as YYYY-MM-DD so spreadsheets can sort them, and a link to each item is always included. For content audits, add the Page ID, Parent page and Page path columns.

To export the tables on a page, open the page’s ••• menu and choose Export tables to Excel or CSV. Tick the tables you want and download them as one Excel workbook (a sheet per table) or a single CSV. Merged cells are filled in so every row lines up, and things like status lozenges come through as text.

The Export tables to Excel or CSV dialog for a page with 3 tables: Release scope, Risks and Rollout, each ticked, with a preview of the first table and Download CSV and Download Excel buttons
Export tables to Excel or CSV: three tables on a page, one sheet each.

Security and your data

  • Runs on Atlassian. The app is built on Forge and runs entirely on Atlassian’s infrastructure. No content is sent to Onibaku or any other server.
  • Respects permissions. Searches and exports run as the person using the app, so they only ever see content they already have access to.
  • Stores almost nothing. The only data kept is each person’s saved searches (a name, the query and column choices), in Atlassian’s Forge storage. Exports are generated in your browser.

Details are in our privacy policy.

Help

Found a bug, or want a feature? Email admin@onibaku.co.uk.

See support for what to include.

Your query, one click from Excel

Get it on the Atlassian Marketplace

Confluence Cloud. Runs as the person using it, so permissions stay as they are.