Xbl CLI is a powerful command line tool designed to provide detailed statistics on your Xbox achievements.
Whether you’re using Xbox Live or have an old Xbox 360 profile, this tool has you covered.
- Comprehensive Compatibility: Works with both online Xbox Live and offline Xbox 360 profiles, as well as Xbox Store and legacy Marketplace data. (Kudos to xbl.io and dbox.tools)
- Built-in Queries: Utilize pre-defined queries to quickly access the data you need.
- KQL Capabilities: Leverage Kusto Query Language (KQL) for advanced data analysis and custom queries.
- Versatile Output Formats: Beautiful console outputs, JSON data and interactive HTML charts export.
Xbl CLI is built on OpenXBL, an unofficial Xbox Live API.
In order to use Xbl CLI first you are going to need an OpenXBL registration and a personal API key.
- Go to xbl.io
- Login with your Xbox Live account
- On the profile page create a new API key
- Save it, as you won't be able to recover it from the site later
Warning
The free tier of OpenXBL gives you 150 requests/day only. Please note that the "requests/hour" title is not correct on the OpenXBL profile page, moreover it takes about 25 hours to reset the counter.
Because of the daily limitations of OpenXBL you probably won't be able to get all your data at once, but do not worry Xbl CLI can work with partial data as well and can incrementally update your data later. By default Xbl CLI downloads both achievements and stats, but in order to save requests and giving you the power to focus on the data you want you can limit update to either achievements or stats.
Xbl -a={YourApiKey} -u
Xbl -a={YourApiKey} -u=all
Xbl -a={YourApiKey} -u=achievements
Xbl -a={YourApiKey} -u=stats
Note
If you limit your update to achievements you can update 149 titles at one try, while stats works in pages (100 games per page), so if you have about 500 games you'll need four days to download everything anyway.
Xbl CLI can also import old Xbox 360 profiles (also known as STFS packages).
To get your Xbox 360 profile file, follow the steps of the official Xbox Support article.
Or if you have an RGH console can use my old GODspeed tool.
Once you have your profile file, you can use the following command to import your data:
Xbl -p={YourProfilePath}
This command gives you a small aggregation of data:
- number of games
- number of unlocked achievements
- number of Gamerscore
- the recorded hours of gameplay (Xbox Live only)
In the footer you'll get a sum of all games / unique titles.
Xbl -q=summary
This command orders your games based on progress percentage.
Xbl -q=completeness
This command generates a detailed breakdown chart showcasing the games you’ve logged the most hours on.
Please note that not all games support this feature, so you might not see data for certain titles, like The Witcher 3. :)
Xbl -q=time
This command orders your achievements based on their rarity.
Xbl -q=rarity
This command uses an exponential scale to order your games with the most valuable achievements.
The R/A/T column stands for Rare/Achieved/Total.
Xbl -q=weighted-rarity
The default item limit of the queries above is 50. To change that use the -l argument.
Xbl {YourCommand} -l={MaxNumberOfItems}
All commands (except the quick summary) supports JSON output so you can import the generated data in other tools like Excel or Flourish Studio (see below).
Xbl {YourCommand} -o=json
Tip
This bubble chart was created with Flourish based on the following query: Xbl -q=weighted-rarity -l=1000 -o=json
If you would like to play with custom queries and harness the capabilities of KQL, use the -k argument.
Both .kql files and inline queries are supported.
Xbl -k=MyKustomQuery.kql
Xbl -k="achievements | summarize count() by Platform"
In your KQL query you can use three different data tables: titles, achievements and stats. Stats are only available for Xbox Live data.
{
"TitleId": "1915865634",
"Name": "Lorem Ipsum: The Game",
"CompatibleWith": "PC|Mobile|Xbox360|XboxOne|XboxSeries",
"CurrentAchievements": 18,
"TotalAchievements": 0,
"CurrentGamerscore": 560,
"TotalGamerscore": 1000,
"ProgressPercentage": 56,
"LastTimePlayed": "2025-02-02T16:54:38.4848326+01:00",
"Category": "Shooter",
"Xbox360ProductId": "66acd000-77fe-1000-9115-d802305807d3",
"XboxOneProductId": "9MVHHT21X5F6",
"XboxSeriesProductId": "bx3zk30jl2dl",
"Xbox360ReleaseDate": "2020-01-01T01:00:00+01:00",
"XboxOneReleaseDate": "2020-01-01T01:00:00+01:00",
"XboxSeriesReleaseDate": "2020-01-01T01:00:00+01:00"
}{
"Name": "Lorem ipsum",
"TitleId": "10027721",
"TitleName": "dolor sit amet",
"IsUnlocked": true,
"TimeUnlocked": "2016-09-11T14:25:10.686+02:00",
"Platform": "Xbox360|XboxOne|XboxSeries",
"IsSecret": false,
"Description": "Lorem ipsum",
"LockedDescription": "dolor sit amet",
"Gamerscore": 100,
"IsRare": false,
"RarityPercentage": 12.34
}{
"XUID": "2533274845176708",
"SCID": "40950100-bb3f-4769-906a-5eae3b67330a",
"TitleId": "996619018",
"Minutes": 341
}Tip
To get the schema of the given tables you can use the -e (Extended help) argument as well.
Xbl -e
Xbl CLI uses Kusto-Loco to support KQL queries that can also render the results as a chart. Charts are rendered to HTML files using the Vega-Lite charting library.
This Stacked Area Chart was created using the following, rather complex, query as a demonstration.
It aggregates all unlocked achievements from the last three Xbox generations and displays them on a timeline. Additionally, it performs fuzzy data cleanup to ensure no achievements are shown before the purchase of my very first Xbox 360.
let x360purchase = datetime(2009-04-01);
let xonepurchase = datetime(2014-09-01);
let calculated = achievements
| join (titles) on TitleId
| where IsUnlocked
| extend unlocked = iff(datetime_part('year', TimeUnlocked) == 2005 and TimeUnlocked < Xbox360ReleaseDate, Xbox360ReleaseDate, TimeUnlocked)
| extend month = todatetime(format_datetime(unlocked, 'yyyy-MM-01'))
| summarize Gamerscore = sum(Gamerscore) by month, Platform;
let sumlow = toscalar(calculated | where month < x360purchase | summarize sum(Gamerscore));
let months = range month from x360purchase to xonepurchase step 1d where dayofmonth(month) == 1;
let countmonths = toscalar(months | summarize count());
let projected = months | project month, Gamerscore = sumlow / countmonths, Platform = "Xbox360";
let mid = calculated | where month between (x360purchase .. xonepurchase) | project month, Gamerscore, Platform;
let high = calculated | where month > xonepurchase | project month, Gamerscore, Platform;
let midext = projected | join kind=leftouter (mid) on month, Platform | project month, Gamerscore = Gamerscore + coalesce(Gamerscore1,0), Platform;
union midext, high | order by month asc | render stackedareachart