Best Way to Track a Pokémon Card Collection (Free Excel Template Layout)

Once a collection grows past a few binders, it gets hard to remember what you have, what you paid and what it's worth. A tracker solves that — and it helps with insurance, selling, trading and simply enjoying the collection. You can use a spreadsheet, a collection app, or both. This guide gives you a spreadsheet layout you can start with today and explains how to keep it up to date.

What a good tracker records

The key is recording enough detail to identify the exact printing. A card's name alone isn't enough, because the same character appears in many sets and finishes. Use these columns:

If you're unsure how to read the set and number on your cards, see how to read a card's set number. For the condition column, use the scale from our condition guide.

A spreadsheet layout you can copy

Create these headers in row 1 of Excel or Google Sheets, then add one row per card (or per group of identical copies):

A: Card   B: Set   C: Number   D: Variant   E: Condition   F: Grade
G: Qty    H: Purchase price   I: Market (each)   J: Condition factor
K: Est. value (each)   L: Total value   M: Gain/loss   N: Location   O: Notes

Then add formulas in row 2 and copy them down:

K2  =I2*J2                  estimated value of one copy
L2  =G2*K2                  total value of the row
M2  =L2-G2*H2               gain or loss vs what you paid

Totals (below your data, or on a Summary sheet):
=SUM(L2:L1000)              collection value
=SUM(M2:M1000)              total gain/loss

Column J is a condition factor: 1 for Near Mint and lower numbers for played cards, so played copies aren't valued at Near Mint prices. Our condition guide shows the estimated factors we use. Turn on filters on row 1 so you can sort by value or filter by set.

The hard part: keeping values current

A spreadsheet is only as good as its prices, and card prices change constantly. Typing in new market prices by hand works for a few dozen cards, but it quickly becomes a chore. A few ways to handle it:

• Update only your top cards regularly, and refresh the rest a few times a year.
• Record the date you last updated prices, so you know how stale a number is.
• Use a tracker that updates automatically and export it to a spreadsheet when you need one.

Tracking with CheckCardValue

CheckCardValue combines both approaches. Scan a card and the exact printing is identified for you — set, number and variant — so you don't type anything. Subscribers can save it to a collection with condition, quantity and purchase price; values are refreshed from market data every day, and the collection page shows your total value and gain or loss.

When you want a spreadsheet, export the collection to Excel (.xlsx) or CSV. The export includes card, set, number, rarity, variant, condition, grade, quantity, purchase price, market price, estimated value, total value, gain/loss and a link to each card's page, plus a summary sheet — the same structure as the layout above, filled in for you. Export is included in all paid plans.

Tips for a tracker that lasts

• Add cards as you get them; catching up on a whole binder later is tedious.
• Keep graded cards in their own rows, with the grading company and grade, and update the price from sold listings of that grade.
• Back up your spreadsheet or export regularly.
• Photograph your most valuable cards and keep the photos with your records — useful for insurance and selling.

Once your collection is tracked, deciding what to sell, trade or grade gets much easier. See our guides on how to sell cards and how to store them.