A spreadsheet is the cheapest, most flexible way to track a card collection — but only if it's built right. Most collectors start with a single sheet, twelve random columns, and no formulas, then quit when it turns into a chore. This is the structure that scales from 50 cards to 5,000: three tabs, a tight column set, and four formulas that do the math for you. Copy it into Google Sheets or Excel and you're logging in ten minutes.
Tab 1 — Inventory (what you own)
This is the heart of the file: one row per card. Resist the urge to add thirty columns. These are the ones that let you find a card, value it, and prove ownership:
| Column | Example | Why it's here |
|---|---|---|
| Player & Year | Ja'Marr Chase 2021 | Core identity of the card. |
| Set / Parallel | Prizm Silver | A base and a /25 parallel are worlds apart. |
| Card # | #220 | Removes all ambiguity when you look it up. |
| Grade / Condition | PSA 10 / Raw NM | Drives value more than almost anything. |
| Purchase Price | 40.00 | Your cost basis — no profit math without it. |
| Current Value | 210.00 | Refreshed from recent comps. |
| Location | Binder 3 / at PSA | The field everyone skips and everyone regrets. |
| Date Acquired | 2026-03-14 | Lets you chart growth and hold time. |
Keep Purchase Price and Current Value as plain numbers (no $ typed in the cell) so formulas can total them. Format the column as currency instead.
Tab 2 — Grading Submissions (cards in transit)
The moment cards ship to PSA, BGS, SGC or CGC they leave your shelf and enter a black hole for weeks. Keep them on a separate tab — they aren't really "inventory" until they come back, and the economics are a different question. Columns:
- Submission # & date sent — your reference for the whole batch.
- Service level (Value, Regular, Express) and per-card fee.
- Declared value per card.
- Date returned and grade received.
Not sure who to send to? See PSA vs BGS vs SGC vs CGC — which grading company to use, and how to track a PSA grading submission step by step.
Tab 3 — Sales / Flips (what actually made money)
One row per card sold. This is where the profit formula lives, and it's the tab that quietly teaches you which players and price tiers are worth your time.
The four formulas that do the work
Paste these into the header row of the relevant tab (syntax is identical in Google Sheets and Excel). Adjust the column letters to match your layout.
| What it gives you | Formula |
|---|---|
| Unrealized gain per card (Inventory tab) | =F2-E2 (Current Value − Purchase Price) |
| Total portfolio value | =SUM(F2:F999) |
| Total cost basis | =SUM(E2:E999) |
| Real net profit on a flip (Sales tab) | =SalePrice-(SalePrice*0.13)-Shipping-GradingFee-PurchasePrice |
That last formula is the one that matters. A card you "bought for $40 and sold for $90" feels like $50 profit — but after ~13% marketplace and payment fees, $5 shipping and an $18 grading cost, your real net is about $15.30. Track it honestly across every sale and a pattern emerges fast: what actually makes money versus what just feels productive.
Five mistakes that kill a card spreadsheet
- Typing
$into value cells — turns numbers into text and breaks everySUM. Format as currency instead. - One giant tab for everything — mixing owned cards, in-transit submissions and sold cards makes your totals meaningless.
- No "Location" column — "where is it?" becomes the question you can't answer once you pass a few hundred cards.
- Never dating anything — without acquired/sold dates you can't chart growth or hold time.
- Letting it go stale — log pickups and sales the same day; refresh values once a month. A spreadsheet you don't update is just a snapshot of the past.
When a printable beats a spreadsheet
Spreadsheets are unbeatable for sorting, filtering and formulas. But they have real weaknesses: you build and maintain every formula yourself, they're clumsy at the kitchen table or a card show, and a fat-fingered cell can silently corrupt a total. A printable PDF flips those trade-offs — nothing to build, works on paper or on a tablet in GoodNotes/Notability, and it doubles as a physical record that travels with the cards. Plenty of collectors run both: spreadsheet at the desk, printable for shows and shoeboxes.
Don't want to build it? The template's already done.
The Card Vault is an 8-page printable PDF built around this exact structure: a clean collection inventory, a dedicated PSA/BGS/SGC grading submission log, a buy/sell profit tracker that nets out fees for you, plus wishlist, set-completion and a monthly portfolio-value sheet. Print unlimited copies at home or fill it on a tablet. Instant download, one-time $6, no subscription.
Get the Card Vault — $6 →Collect Pokémon, One Piece or Magic instead? See The TCG Vault. Comics? The Comic Vault. Browse all three at The Vault.
FAQ
Is there a free sports card inventory spreadsheet template?
You can build one for free in minutes using the three-tab structure and four formulas above — that's the whole template. If you'd rather not maintain formulas yourself, a done-for-you printable like The Card Vault mirrors the same structure on paper or tablet.
Google Sheets or Excel for a card collection?
Either works — the formulas above are identical in both. Google Sheets edges it for most collectors because it auto-saves, syncs to your phone at a card show, and is free.
How many columns should a card spreadsheet have?
Eight is plenty on the inventory tab. More columns feel thorough but raise the effort per card, which is the number-one reason people abandon their tracker. Track what you'll actually use.
How do I calculate real profit after fees?
Subtract marketplace + payment fees (roughly 13% on most platforms), shipping and supplies, any grading cost, and your original purchase price from the sale price. Our card grading profit calculator does the grading side for you.