How to Track Your Board Game Collection in a Spreadsheet: 14 Shelf Columns and a Play Log

PlayPick

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

  1. Mind Games, “How to Choose Board Games That Get Played” (2026) https://www.m-g.com.au/how-to-choose-board-games/
  2. 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

Copied title and URL