Free Pokemon TCG Tracker Spreadsheet Template

Do you know how many Pokémon cards you own? Do you know what your collection is worth, or which cards you still need to finish a set? A Pokemon TCG tracker spreadsheet built in Google Sheets can answer all three in a few seconds.

Pokémon card collections grow fast. A few booster packs turn into a binder, the binder turns into a box, and soon you are buying duplicates because you cannot remember what you already have. This free template gives you one organized place to log every card, track what you paid and what it is worth now, and keep a wishlist for the cards you are hunting.

It works for English and Japanese cards, so you can keep your whole collection in one sheet. Below is everything the template includes and how to use it.

Overview of the Template

This Pokemon TCG tracker spreadsheet has four tabs: a Collection log, a Summary page, a Wishlist, and a Settings tab that controls your dropdown lists. You type each card once, and the totals update on their own.

The template is a good fit if you want to:

• Keep a complete list of every card you own, with set, card number, rarity, and condition
• Know the total market value of your collection and your gain or loss against what you paid
• Track English and Japanese cards side by side
• Plan your next purchases with a wishlist that has priorities and target prices

Everything is editable. You can add your own rarities, conditions, or languages on the Settings tab, and the dropdowns on the other tabs update to match.

Key Features and Sections

Collection (Main Log)

This is the heart of the Pokemon TCG tracker spreadsheet. Each row is one card. You enter the set, set code, card number, card name, language, rarity, condition, quantity, what you paid for each card, and its current market value for each card. Total Cost, Total Value, and Gain / Loss calculate automatically, and gains show in green while losses show in red.

The Collection tab is ready for up to 500 card entries, and it includes example rows so you can see how the data should look before you replace it with your own.

Summary

The Summary tab turns your log into numbers you can use. It shows your total cards (counting quantities), number of card entries, total cost, total market value, gain or loss in dollars and as a percentage, your average value per card, and your single most valuable card. It also breaks your collection down by rarity and by language, so you can see how many Japanese cards you have and what they are worth.

Wishlist

The Wishlist tab holds the cards you want. For each one you can record the set, card number, rarity, language, priority, target price, and where you plan to buy it. When you find a card, mark Got It as Yes and the row grays out. The Summary tab also shows how many wishlist cards you still need and the budget you would need to finish the list.

Settings (Dropdown Lists)

The Settings tab holds the lists behind your dropdowns: rarity, condition, language, and wishlist priority. The rarity list includes both English rarities and Japanese rarity codes such as SAR, AR, SR, and UR. Type a new option into the next empty row of any list and it appears in the dropdowns right away.

How to Use the Template

Step 1: Make Your Copy

Download the template using the form below, then open the link and choose Make a copy so the sheet saves to your own Google Drive.

Step 2: Clear the Example Rows

Go to the Collection tab and delete the four example rows. Do not delete the formula columns (Total Cost, Total Value, and Gain / Loss). Those fill in by themselves.

Step 3: Add Your Cards

Type each card on its own row. Choose the language, rarity, and condition from the dropdowns. Enter the quantity, the price you paid for each card, and the current market value for each card.

Step 4: Check Your Totals

Open the Summary tab to see your collection value, your gain or loss, and your breakdown by rarity and language.

Step 5: Update Prices Now and Then

Card prices move. When you want a fresh total, update the market value for the cards that matter most. Sites such as TCGplayer and eBay sold listings are common places to check what a card is selling for.

Tracking Japanese Pokémon Cards

Japanese cards often use different set codes, card numbers, and rarity names than the English versions, so the template gives them their own space. Set the Language column to Japanese, enter the set code printed on the card (for example sv2a), and pick the Japanese rarity from the dropdown, such as SAR (JP).

Because every card has a language, the Summary tab can show how many Japanese cards you own and what they are worth next to your English cards. This free version works in US dollars, so convert any yen prices to dollars before you enter them.

Why Choose This Template

Built for Pokémon Collectors

The columns match what collectors actually track: set, set code, card number, rarity, language, and condition. You do not have to adapt a generic inventory sheet.

Automatic Calculations

Totals, gain or loss, and the summary tables update the moment you change a quantity or price, so you never have to add anything up by hand.

Easy to Customize

Add your own rarities, conditions, or languages on the Settings tab. Add columns for grading company or storage location if you want more detail.

Free and Works in Google Sheets

There is nothing to install. The template runs in Google Sheets, works on desktop and mobile, and your data stays in your own Drive.

Tips for Best Results

• Enter prices per card, not per stack. The template multiplies by quantity for you.
• Use one row per card, condition, and language combination. A Near Mint copy and a Lightly Played copy of the same card should be separate rows.
• Use the Notes column for grading details, binder page, or where you bought the card.
• Refresh the market values for your most valuable cards first, since they move your total the most.
• Make a backup copy of your sheet before making big changes.

Who Should Use This Template?

New Collectors

If you are just starting out, a simple log keeps you from buying duplicates and shows you how your collection grows.

Binder Builders and Set Collectors

Track every card you have for a set, then use the Wishlist to keep a list of the ones you still need.

Japanese Card Collectors

Keep Japanese and English cards in one sheet, with the right set codes and rarity names for each.

Parents Tracking a Kid’s Collection

A shared Google Sheet makes it easy to see what your child owns and what is on their wishlist before birthdays and holidays.

Frequently Asked Questions

Does the template update card prices automatically?

No. You enter the market value for each card yourself. This keeps the sheet simple and gives you full control over the numbers.

How many cards can I track?

The Collection tab is set up for 500 card entries and the Wishlist for 100. You can copy the formulas down to add more.

Can I track Japanese and English cards together?

Yes. Every card has a Language column, and the Summary tab shows a breakdown by language.

Is it really free?

Yes. The template is free for personal use. Enter your email in the form below and you will get a link to make your own copy.

Pokémon and Pokémon character names are trademarks of Nintendo. This template is an unofficial tool and is not affiliated with, endorsed by, or sponsored by Nintendo, Creatures Inc., GAME FREAK inc., or The Pokémon Company.

If you also collect comics, the free comic book collection tracker spreadsheet uses the same layout for books, graded slabs, and wishlists.

Collect vinyl figures too? The free Funko Pop collection tracker spreadsheet logs each Pop with its edition, box condition, and current value.

Do you collect building sets too? The free LEGO collection tracker spreadsheet logs each set with its piece count, build status, and current value.