Free TCG Collection Tracker Spreadsheet: Track Every Card You Own

Get a free TCG collection tracker spreadsheet that works for Magic, Pokemon, One Piece, Lorcana and every other card game. Log your collection, track values, and manage your wishlist.

This post contains affiliate links. If you buy through them, we may earn a small commission at no extra cost to you.

If you play or collect trading card games, you need a collection tracker. It doesn't matter whether you play one game or five, whether your collection has 200 cards or 20,000 — a tracker is the single tool that gives you visibility over what you actually own.

This page explains what our free TCG Collection Tracker does, how to get it, and how to make the most of it across any card game.

Quick Answer:

Our free TCG Collection Tracker is a Google Sheets spreadsheet that works for any card game — MTG, Pokemon, One Piece, Lorcana, Yu-Gi-Oh, Star Wars Unlimited, and more. It includes inventory tracking with auto profit/loss calculation, a wishlist tab, and 200 card entries. Get it instantly via our tracker page — sign up, get the link, make a copy to your Google Drive, and start logging.

What the Free Tracker Includes

The C3 free TCG Collection Tracker is built for collectors who also sell — meaning it's designed around the practical needs of someone who opens product, acquires cards through various channels, and occasionally moves cards on.

Inventory sheet: The core of the tracker. Log each card with: name, set, condition, quantity, purchase price, and current value. The profit/loss column calculates automatically — enter what you paid and what it's worth now, and the tracker shows you your gain or loss per card and across your total collection.

Wishlist tab: Log cards you're looking for with a priority ranking. When browsing eBay or attending a game store event, you can check your wishlist immediately rather than trying to remember what you need. Mark cards as acquired and they move from wishlist to inventory.

Works for any card game: The tracker structure is game-agnostic. A card is a card — name, set, condition, value. Whether it's a Pokemon Special Illustration Rare, an MTG Commander staple, a Lorcana Enchanted, or a One Piece Secret Rare, the same fields apply. Add a game column if you track multiple TCGs in one sheet.

Google Sheets delivery: No download required. The tracker opens directly in your browser as a Google Sheet. Make a copy to your own Google Drive with one click (File → Make a Copy) and it's yours to edit, customise, and use indefinitely. Works on any device with a Google account.

200 card entries in the free version: Sufficient for focused collection tracking, high-value card management, or single-game tracking at a moderate scale.

Who the Free Tracker Is For

Casual collectors who want to know what they own and what it's approximately worth without setting up a complex database. The tracker is designed to be immediately useful without a learning curve.

Active players building and upgrading decks who need to know exactly what cards they have available, what they're short on, and what they've paid for their collection over time.

Occasional sellers who want to know which cards in their collection have the most value and would benefit from listing. The profit/loss calculation makes this immediately visible.

Multi-game collectors who play across Pokemon, MTG, Lorcana, and One Piece and want a single place that tracks all of it. One spreadsheet, one place to check.

How to Get the Most Out of It

Enter Cards When You Acquire Them

The tracker is most useful when it's current. The discipline that makes a collection tracker valuable is simple: when you get new cards (booster box opening, trades, purchases), enter them before they go into storage. Two minutes at the time of acquisition is much easier than reconstructing what you pulled from a box three weeks later.

Keep Purchase Prices Accurate

The profit/loss calculation only works if your purchase prices are accurate. If you bought a box for AU$150 and pulled a card worth AU$80, log the card's purchase price as your cost allocation from that box — some people use a proportional allocation; others simply log what they'd pay for the card as a single today. Either approach is consistent as long as you apply it uniformly.

Update Values Monthly for High-Value Cards

Card values shift. A monthly value update for your highest-value cards (AU$20+) takes 15–20 minutes and keeps your total collection value accurate. For bulk cards, quarterly is sufficient. Update immediately when you hear about a specific card spiking or crashing.

Use the Wishlist Actively

The wishlist is most useful when you consult it before buying. Before opening eBay or attending a game store, check your wishlist. Buying a card that's on your wishlist at the right price is more satisfying and more financially sound than impulse purchasing cards you happen to come across.

Mark wishlist priorities honestly — a card you "might use someday" has a different priority than a card you need for a deck you're actively building. This distinction prevents the wishlist from becoming a hoarding list.

For Larger Collections: The Premium Version

The free tracker handles 200 card entries — the right scope for focused collection tracking or high-value card management across a few games.

For players with large collections spanning multiple years and games, our premium TCG Collection Tracker is available on our Etsy store (blasdigital.etsy.com) at AU$9.95. The premium version includes:

Both versions are one-time purchases — no subscription, no ongoing fees.

Other Digital Tools Worth Knowing

The C3 tracker is a spreadsheet — it's flexible, customisable, and works for any game. For players who prefer dedicated apps with automatic card recognition and price syncing, several options exist:

Moxfield — MTG-focused, excellent deck building and collection tracking with automatic price updates from card databases.

Deckbox — multi-game collection tracker with trading features.

Pokemon TCG Live — handles Pokemon deck and collection management digitally.

Dreamborn/Pixelborn — Lorcana collection and deck tracking.

Apps have the advantage of automation (card scanning, automatic price updates). The tracker has the advantage of customisability, offline access, data portability, and no dependency on a third-party service remaining operational.

Many serious collectors use both — an app for the game they play most competitively, and a spreadsheet for the broader cross-game picture.

Get the free TCG Collection Tracker now. Works for any card game. Instant Google Sheets access. No download required.

Get the Free Tracker →

Frequently Asked Questions

Does the free tracker work for all TCGs? Yes. The tracker is game-agnostic — it works for MTG, Pokemon, One Piece, Lorcana, Yu-Gi-Oh, Star Wars Unlimited, Dragon Ball Super, and any other card game. Add a game column if you track multiple games in one sheet.

Do I need to download anything? No. The tracker is a Google Sheet that opens directly in your browser. You need a Google account to make a copy to your Drive — free accounts work fine.

Can I customise the tracker? Yes — once you've made a copy to your own Google Drive, it's fully yours to edit. Add columns, change the layout, add conditional formatting, or modify any field to suit your specific needs.

What's the difference between the free and premium versions? The free version has 200 card entries and core tracking functionality. The premium version (AU$9.95 on Etsy) has unlimited entries, advanced profit/loss breakdowns, and multi-game portfolio summaries. Both are one-time purchases with no subscription.

Is my collection data private? The tracker is a personal Google Sheet in your own Google Drive. It's not connected to any external service or shared with anyone unless you choose to share it. Your collection data stays in your Google account.

Can I use the tracker on my phone? Yes. Google Sheets works on iOS and Android through the Google Sheets app. All functionality is accessible on mobile, though the experience of entering and reviewing data is more comfortable on a desktop or tablet.

← Back to Blog Browse TCG Shop →