How to Inventory a Pokémon Collection for Selling
A repeatable method for cataloging a Pokémon collection before you sell: triage first, sort physically, then price in batches with a reusable spreadsheet.
Inventory the collection in this order: triage, sort, then type. Pull out the small minority of cards carrying most of the money, sort those into piles by set, and only then open a spreadsheet. Cataloging in the order the cards happen to come out of the box is the single most common way people spend a weekend and end up with a document they cannot use.
This is a procedure, not a theory, and it assumes no hobby knowledge.
What is the fastest way to inventory a Pokémon collection?
Four passes, in this order, and never overlapping them:
- Triage. Separate the cards that might be worth real money from the cards that are not. No pricing yet, no typing.
- Sort. Put the triaged cards into piles by set, then into card-number order inside each pile.
- Price in batches. Work one set pile at a time, with one price guide open, and move down the numbers.
- Record. Type as you price, into a fixed set of columns.
The reason the passes must not overlap is that each one puts your brain in a different mode. Deciding whether a card matters, deciding what it is, and deciding what it is worth are three different jobs. Interleaving them roughly triples the time. If you take one thing from this article, take that.
Which cards actually deserve a spreadsheet row?
The small minority that could plausibly be worth more than loose change each. In most collections that is holos, rares, anything from the late 1990s and early 2000s, and the big modern chase cards. Everything else is bulk, and bulk gets counted, not cataloged.
Run the triage pass with two containers and one rule: does this card make me stop? A card goes in the “look closer” pile if any of these are true.
- It is shiny across the artwork, or the artwork breaks out of its frame.
- The bottom corner shows a star, or any symbol that is not a circle or a diamond.
- It looks old — thick black borders, a 1999 to 2003 copyright line, a small set total like /102 or /111.
- It says “1st Edition” beside the artwork, or carries a stamp of any kind.
- It is a card you have heard of, or that someone in the family always said was worth something.
Anything else — the ordinary Pokémon, the Trainers, the Energy — goes in the bulk container. Do not price these individually. Our guide to bulk Pokémon cards covers what they realistically fetch.
Be quick and be generous. Triage is cheap and reversible; a card wrongly promoted costs you thirty seconds later, while a card wrongly dumped into bulk costs you whatever it was worth. When in doubt, promote it.
How should you sort the cards physically before pricing?
By set first, then by the printed card number inside each set. Sorting by Pokémon name, by color, or by how much you like them will slow the pricing pass down badly.
The set is identified by the small symbol in the bottom corner, next to the number. The number is printed as one figure over another — 9/111, 025/198 — where the first is the card’s position in the set and the second is the number of standard cards the set contains. If the first number is higher than the second, as in 224/198, you are holding a secret rare, which is a deliberate extra printed beyond the set’s advertised total. Those are worth pulling to the front of the pile.
Once sorted, the pile is in the same order as every price guide you are about to open. That is the entire point. You stop searching and start scrolling, and the pricing pass goes from minutes per card to seconds per card.
Sleeve the sorted cards as you go if they are not already protected. Inventorying means handling, and handling is how cards quietly pick up damage.
What columns should the spreadsheet have?
Eleven columns, and no more. Copy this header row straight into row one:
Set | Card number | Card name | Variant | Condition | Qty | Price | Price checked on | Source | Location | Notes
| Column | What goes in it | Example |
|---|---|---|
| Set | The expansion name, spelled the same way every time | Neo Genesis |
| Card number | Exactly as printed, both halves | 9/111 |
| Card name | The name on the card | Lugia |
| Variant | Holo, reverse holo, 1st Edition, shadowless, promo, or normal | Holo |
| Condition | One word from a fixed list you never deviate from | Lightly played |
| Qty | How many identical copies | 1 |
| Price | The figure you found, for that condition and variant | (number only, no symbol) |
| Price checked on | The date you looked it up | 2026-09-11 |
| Source | Where the figure came from | eBay sold |
| Location | Which box, binder or page it is physically in | Box 2, row 3 |
| Notes | Damage, oddities, anything a buyer would ask about | Soft top-left corner |
Two columns earn their place in ways that are not obvious. Location is what turns the sheet from a list into a tool — when a buyer asks about one line, you can put your hand on the card in ten seconds instead of emptying the box. And Variant is what stops you comparing a card against a price for a different printing of itself.
Keep the condition vocabulary small and rigid: Near Mint, Lightly Played, Moderately Played, Heavily Played, Damaged. Five words, used consistently, are worth far more than careful prose in a notes field. Our Pokémon card condition guide sets out what each one actually means, and it is worth reading once before the first row rather than guessing and re-doing it.
Why is card number plus set better than the card name?
Because names repeat across sets at wildly different values, and the name alone does not identify a card. Bulbapedia’s Charizard index opens by noting that Charizard “has been featured on 50 different cards since it debuted in the Base Set of the Pokémon Trading Card Game”. A row that says only “Charizard” tells a buyer almost nothing.
It goes further than reprints. The same set and the same number can still be several different cards:
- Reverse holo versus normal. Reverse holos share the collector number of the plain version of the same card, so the number alone will not separate them. Since Legendary Collection one reverse holo has been included in every booster pack, rising to two with Scarlet & Violet, which is why they are so common and why they price differently from the standard printing.
- Print runs of the same set. PSA maintains three separate price guides for the 1999 Base Set — 1st Edition, Shadowless and Unlimited. Same card names, same numbers, three different markets.
So the identity of a card is set, plus number, plus variant. All three, every row.
Why does the “price checked on” date matter so much?
Because an undated price is not information, it is a rumor. It is the field almost everyone leaves out of the first version of their spreadsheet, and the one they wish they had when they come back to it.
A dated price tells you three things an undated one cannot. It tells you whether the figure is still current or needs refreshing. It tells you, when you re-check months later, which direction that card has moved and how fast. And it tells a buyer that your numbers came from somewhere real on a particular day, rather than from an optimistic memory. Undated sheets get quietly discounted by everyone who reads them, including their owner.
Type the date at the same moment you type the price. Never afterwards, never in a batch, never “I will fill those in later.”
How do you price a collection in batches instead of card by card?
One set at a time, one source at a time, moving in card-number order down your sorted pile. The gain is not in typing faster; it is in never having to re-orient. You load one set’s price data once and then work through it.
Price against completed sales rather than asking prices. What somebody hoped for tells you nothing; you want sold listings filtered to sold and completed, matched on set, number, variant and condition together. For deeper history, eBay’s help pages say its Product research tool covers “the last 3 years of eBay sales data” and can be searched across any period inside that window, which helps when a card sells too rarely to show recent results.
Record what you find rather than what you would like. If a card has no recent sales, write “no recent comps” in the price field rather than inventing a figure — that itself tells you something.
When should you stop cataloging?
When the next row would cost more of your time than the card is worth. That threshold arrives much earlier than most people expect, and pushing past it is how a sensible afternoon becomes an abandoned project.
Work it out honestly. If a row takes ninety seconds between identifying, pricing and typing, you are spending roughly forty rows an hour. A thousand commons individually cataloged is therefore something like twenty-five hours of work on cards that, taken together, are usually worth a fraction of that as bulk. The arithmetic does not care how thorough you feel.
So catalog the cards that clear the bar and count the rest. A bulk line in the same spreadsheet reading “Base era commons and uncommons, 1,140 cards, Box 4” is a complete and correct row. It is not laziness; it is the same decision any buyer makes, made in your favor rather than after the fact.
Stop, too, when you notice yourself researching rather than recording. If a card needs twenty minutes of investigation, flag it in the notes column and come back to the flagged handful at the end.
What do you do with the finished sheet?
Keep it. That is the return on the whole exercise — a triaged, sorted, dated inventory is a document you can reuse every time you want to know where you stand, and refreshing the prices later takes a fraction of the time the first pass did.
When you do decide to sell, the sheet does most of the work. It tells you which cards should be considered for grading and which clearly should not, a question should you grade Pokémon cards takes apart properly. It gives any buyer the set, number, variant and condition they need to quote without a long back-and-forth. And it means that when cards travel — in a penny sleeve and a top loader, with shipping and insurance arranged by you as the sender — you know exactly what left the house.
We work online and by post, we make written offers from recent sold comps, and we review every collection on arrival before paying rather than the same day. If your sheet is ready, or if you would rather skip the spreadsheet entirely, you can send us photos and we will take it from there.
Common questions
- Do I need to list every single Pokémon card in a spreadsheet?
- No, and you should not try. A spreadsheet row costs you a minute or two of attention, so it only pays for itself on cards worth more than that minute. Give individual rows to the cards that survive a triage pass — holos, rares, full-art and modern chase cards, anything vintage — and record everything else as counted bulk lots by set or era.
- What columns should a Pokémon card inventory spreadsheet have?
- Set, card number, card name, variant, condition, quantity, price, the date you checked that price, the source of the price, storage location, and a notes field. Set and card number identify the card unambiguously. The date is the field most people leave out and later regret, because a price with no date attached cannot be trusted or refreshed.
- Why does my spreadsheet need the card number and not just the name?
- Card names repeat constantly across sets, and the reprints are not worth the same money. Bulbapedia’s Charizard index alone records 50 different cards carrying that name since the Base Set. The printed number and set together point at exactly one card, so anyone pricing from your sheet — including you, in six months — knows precisely which card they are looking at.
- How long does it take to inventory a Pokémon card collection?
- A shoebox that has been triaged and sorted is often a single evening. A several-thousand-card collection spread across binders and boxes is more realistically a few sessions. Nearly all of the time cost sits in the sorting and the pricing, not the typing, which is why sorting physically before you open the spreadsheet saves so much of it.