Gaming Backlog Tracker: Setup & Scoring Method

A gaming backlog tracker only needs seven columns: title, platform, status, estimated hours, mood tags, a priority score, and a decision date. With a simple scoring formula, the list ranks itself and you stop spending evenings scrolling through your library instead of playing.

This guide shows how to build the tracker in any spreadsheet, how to score games, and a set of rules for finishing, pausing or dropping titles without guilt.

Why backlogs grow

Backlogs grow because buying a game is easier than finishing one. Sales, subscriptions and free giveaways add titles faster than anyone can play them. Without a system, choosing what to play becomes a decision made at the end of a long day, and that is when familiar favorites win.

A tracker fixes the decision in advance. It turns "what should I play?" into "what is next on the list?"

The seven columns

Create a spreadsheet with these columns:

1. Title.
2. Platform. PC, console, handheld.
3. Status. Not started, playing, paused, finished, dropped.
4. Estimated hours. The time to finish the main story, taken from a game-length database or the developer's estimate.
5. Mood tags. Words such as relaxed, intense, story, short sessions, co-op.
6. Priority score. Calculated by formula.
7. Decision date. The date by which you will start, drop or pass it on.

Add a filter row so you can sort by status and score. A spreadsheet works better than an app for most people because you control the columns.

The scoring formula

Score each game from 1 to 5 on three questions, then combine:

• Interest: how much do I want to play it now?
• Fit: does it suit the time I have, and my current mood?
• Length: how short is it? Give 5 to games under 10 hours and 1 to games over 60 hours.

Priority score = (Interest × 2) + Fit + Length

The maximum is 20. Interest counts double because wanting to play is the strongest predictor of finishing. Length rewards short games, which clear the list fast and create momentum.

Example:

The RPG is the game you are most excited about, yet the formula ranks it lower because it needs a lot of time. That is a signal to play it when you have a holiday week, or to start it after clearing shorter games.

The "now playing" limit

Set a limit of two games in progress at once: one main game and one light game for short sessions. More than that spreads attention and slows progress. When one finishes or is dropped, pull the next from the top of the sorted list.

If you use controller-based games for the light slot, tune the sticks first. Poor stick settings are a common reason people drop games early, and the guide to controller deadzone settings explained shows how to fix drift and sluggish aim.

The two-hour trial rule

Every new game gets a two-hour trial. After two hours, decide one of three things:

1. Continue, and mark it as playing.
2. Pause, and note why, for example "wrong mood".
3. Drop, and mark it as dropped.

Two hours is enough to see the core loop for most games. A game that does not hold you after that is unlikely to improve for you, and dropping it frees time for something better. Some slow-burn games improve later, and the pause option leaves room for them.

Rules for dropping games

Dropping is a skill. Use these tests:

• You dread starting a session.
• You keep choosing other games over it.
• The next hour is the same as the last.
• You are playing for the achievement, not the experience.

If two apply, drop it. Mark the date and one line explaining why, so future you does not buy a similar game by mistake. A game that you dropped is still a game you have experienced, so the money was not wasted.

Handling subscriptions & sales

Subscription libraries and discounts bring in many games at once. Add only titles that you actually plan to play to the tracker. For the rest, use a wishlist and revisit it once a month.

Subscriptions need their own check. Review what you played in the past month against what you pay for, using the approach in the subscription audit checklist. If you played a subscription for fewer than five hours in a month, pause it and resume when a title you want arrives.

A monthly review

Spend ten minutes at the start of each month:

1. Count finished, dropped and added games.
2. Update scores, since mood and time change.
3. Choose the next three games from the top of the list.
4. Delete games you no longer want.

Track the ratio of added to finished games. If you add more than you finish for several months, pause new purchases until the list is shorter.

Starting the tracker

Gather your library from each platform. Most storefronts have a list view with the game titles you can copy. Paste them into the Title column and set status to "Not started". Then spend an hour on estimated hours and mood tags for the first 30 games.

You do not need to score everything at once. Score the top 20 that interest you and leave the rest unscored until they appear on your radar. A tracker that is 80% complete is better than one that never gets built.

Tips for keeping it fun

• Add a "currently playing" cell at the top for the title and session goal.
• Use colors for status so the sheet is easy to scan.
• Log finished games with a one-line verdict.
• Set an end-of-year review to look back at what you finished.

If you tend to play for long sessions, keep gear in good shape so playing stays comfortable. A quick keyboard clean takes ten minutes.

FAQ

How many games are too many in a backlog?

There is no fixed number. A useful measure is how long it would take to finish them at your current pace. If the answer is more than two years, slow down purchases.

Should I finish every game I start?

No. Finishing is optional. The two-hour trial and the drop rules exist so that time goes to games that you enjoy.

Is a spreadsheet better than an app?

A spreadsheet gives complete control and works offline. Apps help with importing libraries and tracking playtime automatically. Use whichever you will actually keep updated.

How do I decide between a long game & a short one?

Check the time you have. For a week with an hour a night, a short game fits. Save long games for holidays or a period with open evenings.

Build it this week

Open a spreadsheet and create the seven columns. Add your first 30 games, score your top 10 with the formula, and pick your main and light game. Set a reminder for the first of next month to run the review.