Hey all, I wanted to share this spreadsheet that I’ve been working on for a few months. As the title says, it should be every unique Pokémon card in the English TCG. I have it set to allow anybody to view it, but feel free to make your own copies in Sheets if you’d like.
I made this because I was impressed by everyone’s collections of single Pokémon. As I was building this, I used my research to collect every English Porygon/Porygon2/Porygon-Z – I posted my collection to Reddit yesterday.
This should be every card that has been released by WotC, and TPCi/Nintendo. This even includes Ishihara GX, but doesn’t include cards that didn’t actually get released to anybody (like Doug Ferguson GX, which was a going-away gift, and not released to any audience except for Doug Ferguson), or cards that may or may not be real (Prerelease Raichu). I have Special Delivery Charizard included with the understanding that it will be released sometime during the SWSH era, but I’ll remove it if it doesn’t ever end up being released.
I didn’t include any errors – I didn’t really know where to draw the line, as far as what to include and what not to include. There are a wide variety of error cards, I figure that any enthusiast of a particular Pokémon would be able to find them easily through some searching.
Column A is an arbitrary ID number.
Column B is the set that the card is from.
Column C is the number within the set.
Column D is the ID(s) of the Pokémon named on the card. Column E is the card name.
Column F is the Type of the card.
Column G is the rarity of the card in the set, including a description of the holofoil and if the card was exclusive to any particular product or event. Column H lists any other Pokémon that appear in the artwork for the card that I could identify. I did use joshspkmncollection’s thread as a starting point when I was working on this column, but I generally applied a much more liberal standard when deciding if a Pokémon was represented in the artwork of a different card (e.g., if a helix fossil appeared on a Mysterious Fossil card, I would still include that card as containing Omanyte. If I was collecting every Omanyte, I’d really like to have those cards too).
I’d really like to hear feedback if this sheet helps anybody, or if there’s any changes that anybody would like made. I would especially be interested in fixing any errors that you can find. I’ve done as much research as I could, but I’m not an expert like many of you. I’d absolutely be willing to give editing permissions to trusted members of this board, if y’all want to adopt it and maintain it in a way that serves you better. I already have my own backup of it.