How to track a Pokémon card collection: spreadsheet vs app
The point of tracking is not the list. It is answering three questions instantly: what do I own, what is it worth, and what do I still need. Any method that answers those is fine. Most fail on the second one because prices move and nobody updates a spreadsheet every week.
What to record for every card
| Field | Why it matters |
|---|---|
| Set and collector number | Identifies the exact printing; the name alone is ambiguous. |
| Finish / variant | Reverse holo, holo, regular and special patterns have different prices. |
| Condition | Near Mint vs Lightly Played can be a 20 to 30 percent difference. |
| Quantity | Duplicates add up, and you need the count when trading. |
| Price paid | Without it you can never tell whether you are up or down. |
| Where it lives | Binder, box, toploader, or slab. Saves an hour of hunting. |
Spreadsheet
Good for: full control, custom columns, working on a laptop, exporting anywhere. Bad at: prices. You either paste them in by hand or build lookups that break when a site changes. Most spreadsheet collections stop being updated within a few months, and a value column from last spring is worse than no value column.
Checklist sites
Sites like TCG Collector and Pokellector are excellent for set completion: every card, every variant, tick what you own. They are weaker on portfolio questions like cost basis and profit, and prices are either absent or behind a paid tier.
Collection apps with scanning
Apps identify the card from the camera, attach a live market price, and keep the running totals. The trade-off is that you depend on the app’s catalogue and price feed. Questions worth asking before you commit to one:
- Does it distinguish finishes and the same card across sets, or just the name?
- Is the value a real market number or an estimate? Are graded values kept separate?
- Can you record what you paid and see profit or loss?
- Is there a scan cap or a subscription to unlock basic features?
- Can you export your data (CSV) if you leave?
Get Cimela free
Habits that make any method work
- Log cards the day they arrive, with the price paid. Backfilling is the step everyone skips.
- Track sealed product separately from singles. A booster box you have not opened is inventory, not cards.
- Decide what a “set” means for you (regular set or master set) before you start ticking boxes.
- Review the movers once a month. The interesting information is in what changed, not the total.
Set price lists
Every card, its current value and what it costs to finish the set: 30th Celebration · 151 · Prismatic Evolutions · Evolving Skies · Surging Sparks · Destined Rivals · Base Set · all sets