The Scenario
You are a platform architect. Your company has grown to 60+ repositories across a Bitbucket workspace and the annual cost and access review is due next Friday. Engineering leadership wants an inventory of every repo — name, main language, size, visibility, and last-updated date — in an Excel workbook on SharePoint so they can identify dead repos and repos that should not be public.
Nobody has this list. Bitbucket's UI shows repos in a paginated grid of tiles. Clicking into each one to copy metadata would take most of the week.
The bad version of this month:
- You open Bitbucket workspace settings and start scrolling through repos
- You create an Excel workbook with columns: name, language, size, visibility, last updated
- You click into repo 1, copy the metadata, paste
- By repo 15 you notice the size field shows KB for some repos and MB for others
- By repo 30 the VP wants the workbook at 3 PM and you have not reached the private/public visibility column yet
- You send a workbook with 30 rows and a note saying "remaining 30+ repos still in progress."
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that lists every repo in the workspace via the Bitbucket API, normalizes the size units, and writes the full inventory in one pass.
Open the SheetXAI sidebar and type:
List all repositories in Bitbucket workspace 'acme-corp'. For each repo, write name, main language, size in MB normalized from whatever unit the API returns, visibility (public or private), and the last-updated date in columns A through E of the Inventory tab. Sort by last-updated date ascending so the oldest repos appear first.
SheetXAI queries the workspace repo list, handles pagination for 60+ repos, normalizes the size values to MB, and writes the full inventory.
What You Get
A complete repo inventory in the workbook:
- Name — the repo slug and display name
- Main language — the primary language Bitbucket detected
- Size in MB — normalized from whatever unit the API returned
- Visibility — public or private
- Last-updated date — formatted as YYYY-MM-DD, sorted ascending
All 60+ repos in one pass. Not 30 and a note about the rest.
Want to flag repos that have not been updated in over a year? Ask SheetXAI to add a "Stale" column in the same prompt.
What If the Data Is Not Quite Ready
Repository inventories from workspaces that have grown organically have a few wrinkles.
When some repos have no detected language
Repos containing only configuration files or documentation often show no language. You want those flagged.
List all repositories in Bitbucket workspace 'acme-corp'. Write name, main language, size in MB, visibility, and last-updated date in columns A through E of the Inventory tab. In column F, write "No language detected" if the language field is blank.
When the team also wants fork count and watcher count as a popularity signal
Leadership wants to know which repos are actively watched as a proxy for which ones matter.
List all repositories in Bitbucket workspace 'acme-corp'. Write name, visibility, main language, size in MB, last-updated date, fork count, and watcher count in columns A through G of the Inventory tab. Sort by watcher count descending.
When the access review only covers private repos
The public repo list goes to a separate team. Your workbook should only show private repos.
List all private repositories in Bitbucket workspace 'acme-corp'. Write name, main language, size in MB, and last-updated date in columns A through D of the Inventory tab. In column E, write "Stale" if the repo has not been updated in the last 12 months.
When leadership also wants a language breakdown summary
The CTO wants to see the distribution of languages across the workspace before the architecture review.
List all repositories in Bitbucket workspace 'acme-corp'. Write the full inventory — name, main language, size in MB, visibility, last-updated date — on the Inventory tab. On the Summary tab, write each unique language and the count of repos using it, sorted descending by count. Add a row at the bottom for repos with no detected language.
The pattern: the full inventory and the language breakdown summary come from one prompt. The architecture review has both views ready without building them separately.
Try It
Get the 7-day free trial of SheetXAI and ask it to list all repositories in your Bitbucket workspace into a blank Excel workbook. The Bitbucket integration is included in every SheetXAI plan. For related workflows, see how to export open pull requests across all repos in Excel or the Bitbucket in Excel overview.