Board Game Collection Inventory

Who this is for

Every game on the shelf, with its numbers. List each board game with its player count, length, condition, what you paid, what you think it is worth and how often it has been played, and the sheet works out the cost per play.

Board game owners whose shelves are full, households choosing what to play on a given night, and anyone deciding which games to sell or give away.

What this helps you track

• Which games you own and where the collection is kept
• How many players each game suits and how long it takes
• What each game cost and what you reckon it is worth now
• How often each game has come out, and the cost per play
• Which games have never been played and which you have marked to sell

How to use it

1. Write the owner, the shelf or room the collection lives in and the date of the list.
2. Go along the shelf writing each game's title, player range and rough playing time in minutes.
3. Add its condition, what you paid and your own estimate of what it would fetch.
4. Enter the number of plays, using 0 for games never played, so the unplayed count is right.
5. Cost per play and the totals are worked out in the browser and the workbook; on paper, divide cost by plays.
6. Mark each game keep or sell, and update the plays column after game nights.

Formats

• Printable PDF (A4 and US Letter)
• Fillable PDF with form fields
• Fill in online, saved in your browser
• Excel / Google Sheets workbook

The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.

How to print

Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.

Questions

Where does the estimated value come from?

From you. Look at recent sales where you are, or put what you would accept for it. No values are supplied, because prices for the same game vary a lot with edition, condition and demand.

How do I count plays for games I have owned for years?

Put your best guess once and count properly from then on, or start every game at 0 on the day you make the list. Either works as long as you note which you chose.

Why does cost per play stay blank for some games?

It needs a cost and at least one play. A game with no plays has no cost per play; it shows in the unplayed count instead.

Can I record expansions?

Give each expansion its own row with the base game's name in front, so its cost and value are counted. Leave its plays at 0 or count it with the base game, whichever you prefer.