Use two sheets, not one. A board game collection tracker works best as a Shelf sheet with one row per game and a Plays sheet with one row per play. Try to squeeze both into a single sheet and every game night adds columns until the thing is unreadable.
Below are the columns for each sheet, how to fill them in, the formulas that connect them, and a filled-in example. The same layout works in Google Sheets, Excel or a paper notebook.
Plenty of collectors use BoardGameGeek to log their collection. Others would rather not create an account, or own editions whose titles are easier to type the way the box says, for example a local-language edition. A sheet of your own works either way.
It’s written by the developer of PlayPick, an iPhone app for your board game shelf and play log. One box photo adds a game, and each game night becomes a play log entry (app page · view on the App Store).
Sheet 1: Shelf (one row per game)
| Column | What to write | Used for |
|---|---|---|
| Title | As printed on your box | Searching and sorting |
| Status | Owned, Lent, Wishlist, Gone, Not mine | Deciding what counts |
| Base game | For an expansion, its base game’s title | Keeping expansions with their base game |
| Players | Min–max (2–5). Split into two columns if you’ll filter by count | Filtering by tonight’s count |
| Best count | The count your group likes most (4) | Narrowing on indecisive nights |
| Time | Minutes from the box | Filtering by time available |
| Weight | 1 to 5, very light to very heavy | Matching the mood of the night |
| Tags | Co-op, party, two-player and so on | Browsing by type |
| Location | Shelf, row or closet | Finding the box |
| Bought on | Date | Seeing how long a game has sat unplayed |
| Price | What you paid | Cost per play |
| Store | Where you bought it | Reference for next time |
| Plays | Counted from the Plays sheet | H-index and games with 10+ plays |
| Last played | Pulled from the Plays sheet | Sorting by longest unplayed |
Keep the box player range and your best count in separate columns. A box that says 2–5 can be “excellent at four and clunky at two”[1].
Don’t type Plays and Last played by hand. Calculate them from the Plays sheet. If the Plays sheet has the game in column B and the play count in column H:
- Plays:
=SUMIF(Plays!B:B,A2,Plays!H:H) - Last played:
=MAXIFS(Plays!A:A,Plays!B:B,A2)(MAXIFS works in Google Sheets and Excel 2019 or later)
Status values
One common layout keeps owned, wishlist and sold games in the same sheet with a Status column[2]. That lets you decide what counts (the names and rules below are one example):
| Status | Meaning | Counts toward |
|---|---|---|
| Owned | On your shelf | Shelf size and unplayed count |
| Lent | Lent to a friend | Shelf size, but skip it when picking tonight’s game |
| Wishlist | Not bought yet | Nothing on the shelf |
| Gone | Sold or traded away | Nothing on the shelf, but keep the row and its plays |
| Not mine | Played at a friend’s place or a café | Play counts only |
Don’t delete a row when you sell a game. You’d lose its play history. Change the status instead.
Sheet 2: Plays (one row per play)
| Column | What to write |
|---|---|
| Date | The day you played |
| Game | The same title as the Shelf sheet (a dropdown from the Shelf sheet keeps spelling consistent) |
| Players | Names, separated by commas |
| Winner | A name, or “All won” / “All lost” for co-op games |
| Scores | Each player’s score, or blank |
| Expansions used | Expansion titles |
| Minutes | How long it took |
| Count | Plays in a row of the same game (usually 1) |
| Place | Home, a friend’s place, a café |
| Notes | Rules you got wrong, things to try next time |
The Count column lets you log three back-to-back games as one row. Add up Count, not the number of rows, when you total plays.
Filled-in example
Shelf (made-up game names)
| Title | Status | Players | Best | Time | Weight | Location | Bought on | Plays | Last played |
|---|---|---|---|---|---|---|---|---|---|
| Game A | Owned | 2–4 | 3 | 45 | 3 | Shelf 2 | 2025-04-12 | 12 | 2026-10-25 |
| Game D | Owned | 2–5 | 4 | 60 | 4 | Shelf 3 | 2026-09-20 | 0 | — |
| Game J | Lent | 3–6 | 5 | 30 | 2 | Shelf 1 | 2024-12-01 | 7 | 2026-08-30 |
Plays
| Date | Game | Players | Winner | Scores | Count | Place |
|---|---|---|---|---|---|---|
| 2026-10-25 | Game A | Three names | One name | Each score | 1 | Home |
| 2026-11-08 | Game B | Five names | One name | — | 3 | A friend’s place |
Notebook vs. spreadsheet vs. app
| Paper notebook | Spreadsheet | Tracking app | |
|---|---|---|---|
| Getting started | Instant | Set up columns first | Fields are ready |
| Plays and last played | Count by hand | Formulas | Automatic |
| Filter by players and time | Scan by eye | Filters | Depends on the app |
| Photos | Paste in, or none | Awkward | Easy |
| Logging at the table | Easy | Often later, at a computer | On your phone, right after the game |
Whichever you use, the structure is the same: keep the shelf and the plays separate, and keep titles spelled the same way.
Why collection trackers stall
- Filling in every column on day one. Start with Title, Status, Players and Time, and add the rest later
- Entering the whole shelf in one sitting. Add games as you play them
- Inconsistent titles. “Game A 2nd Edition” and “Game A” become two rows and split the play count
- Logging plays days later. Winners and scores are gone by then. Write one row the same night
- Giving expansions their own counted rows. Your shelf size balloons. Use the Base game column
For choosing what to play from this sheet, see Shelf of shame: how to pick tonight’s board game. For the numbers you can pull from the Plays sheet, see What is a board game H-index?
How PlayPick turns a box photo into a shelf row
PlayPick keeps both sheets on your iPhone.
- Shoot a box and it becomes a game on your shelf. Shoot boxes in a row, or add several from your photos
- PlayPick reads the title from the box photo on your iPhone. Tap it, then tap players and time. There’s no game database to search, and titles in any language go in the way your box says
- Status: owned, lent, wishlist, gone (sold or traded), or not mine (played at a friend’s or a café). Expansions sit inside their base game
- Best count, weight, tags, location, store, price and bought date, plus up to 3 photos per game (box, contents, table)
- The play log covers who played and who won, scores, a play count, expansions used, minutes, place, notes and table photos. Plays and last played are counted for you
- Sort the shelf by title, last played, play count, weight, time or date added, and filter and search
You can export games, plays, players and photos as one ZIP file and import it on a new iPhone. Everything is stored on your device with no account, and the games and plays you log are never sent to an external server.
Every feature is free. The free version holds 30 games on your shelf (expansions, wishlist, gone and not-mine games don’t count, and plays and players are unlimited). PlayPick Pro is a one-time purchase that removes the 30-game limit and the watermark on share cards (app page · view on the App Store).
Summary
- Use two sheets: Shelf (one row per game) and Plays (one row per play)
- Start the Shelf sheet with Title, Status, Players, Best count and Time
- Use a Status column for owned, wishlist and gone games, and never delete rows
- Calculate Plays and Last played from the Plays sheet with formulas
- Keep titles consistent and log one row the night you play
Sources
- Mind Games, “How to Choose Board Games That Get Played” (2026) https://www.m-g.com.au/how-to-choose-board-games/
- SheetFlux, “The Board Gamer’s Guide to Tracking Cost Per Play” (2026) https://sheetflux.pages.dev/blog/board-game-cost-per-play
(All checked November 18, 2026.)
About the sources for this article This article is based on information from public agencies, official sites and specialist media, reorganized by the editors from a recording and organizing perspective. Figures and statements about specifications or safety were checked against primary sources where possible.
This article organizes information from a recording and organizing perspective. If you notice an error or outdated information, please contact us. Last verified: November 2026

