Results 1 to 7 of 7
  1. #1

    SOLVED: Complete list of all cards ever made of each team?

    Hey everyone, I started making an excel spreadsheet using the info on Tradingcarddb, but that's very time consuming. Is there a source out there for an entire list of all Blues cards ever made? Preferably in Excel.

    Thanks for the help!
    Last edited by Maggot; 12-05-2017 at 04:30 PM.
    Wanted: Blues #'d, AU, GU. Especially Federko, CuJo, Hull, MacInnis, Demitra, Tarasenko
    Traders on Flickr - Hidden Content
    I auto-accept 20% off on Hidden Content

  2. Check out the deals at Allgood Collectibles eBay Store
  3. #2
    From what I can see, there are 24,255 cards in total listed on B, however I can only view 100 per page lol. Unless you can find someone who can view 1000 per page that's only 25 pages and can be done fairly quickly. I could help you but this would take some time exporting into Excel.
    Last edited by mastermind; 08-15-2017 at 01:06 AM.
    Hidden Content
    Hidden Content Complete all Paul Kariya non-GU base cards: 30 to go! Hidden Content Complete all Paul Kariya 1991-96 cards: 36 to go!
    Hidden Content Topps C55, UD Masterpieces, UD A Piece of History. Hidden Content 1996-97 Black Diamond

  4. #3
    Quote Originally Posted by mastermind View Post
    From what I can see, there are 24,255 cards in total listed on B, however I can only view 100 per page lol. Unless you can find someone who can view 1000 per page that's only 25 pages and can be done fairly quickly. I could help you but this would take some time exporting into Excel.
    You can do 1,000 per page actually, but you'd need to sign up & subscribe.
    Last edited by creasecollector; 08-15-2017 at 07:29 AM.
    Hidden Content
    Hidden Content
    PC's: Martin Brodeur, Ed Belfour, Jhonas Enroth, Marc-Andre Fleury, Carey Price

  5. #4
    Hmmm, not a fan of Beckett's price guides so I'd be hesitant to sign up for their service just to export the list. If it's the best option in the end I'll do it though.
    Thanks for the info!
    Wanted: Blues #'d, AU, GU. Especially Federko, CuJo, Hull, MacInnis, Demitra, Tarasenko
    Traders on Flickr - Hidden Content
    I auto-accept 20% off on Hidden Content

  6. #5
    I finally found the solution that did not involve Beckett.
    Go to your team's page on TradingCardDB. Here's the Blues: http://www.tradingcarddb.com/Team.cf...tName=&sBrand=
    Then click the little "Print" button. "Print" them as a PDF (save them on your computer). For the Blues, it was 9 different PDF files. Then use a free PDF to Excel converter - I found that this one was by far the best at formatting them correctly: https://pdftables.com/convert-pdf-to-excel
    After a very minor amount of cleanup I have an excel spreadsheet of all 23,000 Blues cards.
    Wanted: Blues #'d, AU, GU. Especially Federko, CuJo, Hull, MacInnis, Demitra, Tarasenko
    Traders on Flickr - Hidden Content
    I auto-accept 20% off on Hidden Content

  7. #6
    I realize it is a huge job, but if you want a COMPLETE list, you need to check multiple sources and compare the lists. A huge job for a team with at least 23K+ cards. When I started my California Seals collection I searched the DB, Beckett, SCF, and a couple other lists. Each list was different, sometimes by quite a bit. Each list also had mistakes (missing some cards, listing some cards as a Seals player when he wasn't, etc.). Some cards I only found by going through books of old cards at shows and finding a Seals card that wasn't listed anywhere. I ended up making my own list and came up with over 400 cards, when the longest list I found was less than 350. I had a really tough time with my list, and it was only 400 cards. With 23K, you are in for a tough time, depending on how complete you want it.

    What I did find was the newer lists are far more complete and accurate since they were created with computers. Most of my problems were with the earlier Seals lists from the 60s/70s. Those do not seem to have ever been checked for accuracy, and once a list was created, nobody ever wasted the effort to update or fix. I did see a couple times where one list was copied by someone making another list, and they coppied all the mistakes, as well.

    So Good Luck! You'll need it.
    SHARKS and CAPITALS Fan +++ Tomas Hertl cards: 512 & counting Hidden Content ...... Hidden Content
    Whales: 03-04 Topps Pristine Die-Cut Gold Refractor #67 Sergei Gonchar (#/33)

  8. #7
    Great advice. I noticed a few missing cards when taking a quick look, but getting the bulk of them listed out was the major hurdle. I'll worry about the onesie-twosie cards later on.
    Wanted: Blues #'d, AU, GU. Especially Federko, CuJo, Hull, MacInnis, Demitra, Tarasenko
    Traders on Flickr - Hidden Content
    I auto-accept 20% off on Hidden Content

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


About SCF

    Sports Card Forum provides sports and non-sports card collectors a safe place to discuss, buy, sell and trade.

    SCF maintains tools that will allow collectors to manage their collections online, information about what is happening with the hobby, as well as providing robust data to send out for Autographs through the mail.

Follow SCF on