Your photocard collection probably lives in three places at once — your camera roll, a notes app, and a tangle of trade-board screenshots. It works right up until you forget which version you already own, buy a double of a card you have, or lose track of a trade you agreed to. The K-Pop Photocard Collection & Trading Tracker pulls all of it into one catalog you actually own.
It’s a designed, seven-tab spreadsheet — not an Excel-only file. It opens natively in Microsoft Excel, LibreOffice Calc, and Google Sheets, and for Sheets you don’t import anything: the download includes a one-click “Make a copy” link that drops a fully set-up native copy into your Drive, every dropdown, color, and live count already working.
New to a tracked collection? Try the free single-tab photocard starter sheet — log a few cards by hand, then upgrade here for the full collection, wishlist, trade board, and dashboard.
What is a photocard tracker?
A photocard — a “pc” — is the small printed card of one member that comes with an album, a preorder, or an event, and collecting and trading them is one of the most active corners of K-pop fandom. A photocard tracker is a single catalog of every card you own: who’s on it, which album and version it came from, what era, its condition, and whether it’s a keeper, a duplicate to trade, or a grail you’re still hunting. This workbook does that — and counts the whole thing for you.
Catalog every card
The My Photocards tab is your whole collection, one row per card. Pick the group, member, album or version, and era it came from, then choose a type (album inclusion, preorder/POB, lucky draw, fansign, broadcast, collab), a condition (Mint down to Damaged), and a status (Have, For trade, Want — grail, Incoming, or Sold / traded) from dropdowns. The cards color-code themselves by status, and the Line value column totals quantity × your estimate for you.
Hunt grails and run trades
- Wishlist & Grails — list the cards you’re chasing with a priority and a budget, so you trade with a ceiling instead of in the heat of the moment. Mark a grail Found when it lands and move it over.
- Trade & Sell Board — your duplicates and the cards you’re letting go, with condition and what you’d want in return, tracked from Available to Pending to Done. It’s the board you paste when someone asks what you have.
See your collection at a glance
The Collection Dashboard is the fun part: a live read on your collection pulled straight from My Photocards. Cards by group, by type, and by status; your grails and duplicates; and an estimate of the whole collection’s value. Change a card and the dashboard updates on its own — it’s the screenshot you share when someone asks how big your collection is. A Groups & Sets tab rounds it out: your spelling master for group, member, and album names, with a version-completion map that shows which cards each era still needs.
Grading and trading guides, not just a template
Beyond the Start Here setup guide, two more come with the workbook. The Collecting & Trading Field Guide covers how to grade a photocard from its worst feature, how to trade safely (proof for grails, packaging, what to write down), and the full collector’s glossary — grail, POB, WTT, GO, and the rest. The Printable Binder & Trade Inserts give you a quick-reference card for the front of your binder plus blank log, wishlist, and trade sheets to take to a meetup.
Own it, don’t rent it
You own this file outright. No account, no subscription, no app that adds a paywall or shuts down and takes your collection with it. It sits exactly where it should — more structured than a notes app, without the lock-in of a collection app you don’t control. Buy once, back it up, and use it for as long as you collect.
A fan-made cataloging tool. Card values are your own estimates, for fair trades and a rough sense of your collection’s worth — not a price guide or investment advice. Not affiliated with or endorsed by any group, label, agency, or marketplace. The example collection uses fictional groups.
