Disclaimer: Links on this page pointing to Amazon, eBay and other sites may include affiliate code. If you click them and make a purchase, we may earn a small commission.

Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1
    Hockey Advisor






    Join Date
    Dec 2008
    Posts
    19,852
    SCF Rewards
    70,525
    Country
    Edmonton Oilers Toronto Blue Jays Hamilton Tiger Cats
    See 30Ranfordfan's Items on eBay COMC Cards For Sale Upper Deck ePack

    Player Checklist's from Beckett's site - How to do it

    There's been plenty of posts asking about it, so I thought I'd go through with a step-by-step way of creating an Excel spreadsheet from Beckett's website.

    The complaints are always that the links / icons paste into Excel and it's messy..... and that all the information is in one column. Using the features in Excel & Notepad, we can fix this.

    This will NOT give you a perfect checklist. There is too much of a variance in too many of the rows to make it perfect. This will get you something very close to perfect.... and a little bit of manual touching up will make it look great.

    The list below makes it seems long, but in all honesty - it takes me about five minutes to do this with a player who has 800 cards. It's EASY, you just need to know how to use excel.

    (Notepad gets used at the beginning, because it's SO basic, that it doesn't understand the links, and just removes them).

    Here's what you do:
    - Beckett's Main Page. Type name in search box, press enter
    - Click the List View tab
    - Change to 128 items per page
    - Copy and paste the search results into NOTEPAD
    - Repeat for each page of results
    - If you copied any of the page headers (something like "SELECT : All None Add To Organize ") remove them now
    - Begin Search & Replace to remove or edit unwanted data:
    - Search for "Card 1" replace with "1"
    - Search for "Card 2" replace with "2"
    - Search for "Buy Pricing!" replace with nothing
    - Search for "Item has no pricing." replace with nothing
    - Search for player's name (i.e. "Bill Ranford") replace with nothing
    - Now all the Junk has been removed


    - Copy and paste the whole thing into an Excel sheet (one column)
    - Go to Data tab
    - Highlight your column, press "Text to Columns" button
    - Wizard Opens up
    - Step 1 - Choose Fixed width, press next
    - Step 2 - Excel will likely recognize that the year data is the first column (YYYY-YY) It might now. You may have to adjust. Once the line is adjusted to being just right of the years, press next
    - Step 3 - Ensure 'General' is selected. Click finish.
    - At this point, you may have to make a few manual corrections. Some sets are listed as 2009, instead of 2009-10 (as an example).
    - They will have cut the first few letters from the set name, and kept it with the year. Move them back. Make year look the same as the others, if you like
    - Highlight the 2nd column (not the Years) and do a search for "S#". Replace with "S~"
    - Highlight the 2nd column (not the Years) Click Text to columns
    - Wizards Opens up
    - Step 1 - Choose Delimited, press next
    - Step 2 - Select 'Other' and put a # into the text box. Unselect any other options that may have been selected. Press finish
    - This should have split any base cards nicely. Year / Set / Number are the three columns


    - Click the Home tab
    - Highlight the column with the Numbers (plus the extra info it's got)
    - Click on the left Justify button (Much easier to follow along if you do)
    - Go back to the Data tab
    - Highlight the 3rd column again (with numbers, etc). Click Text to Columns
    - Wizards Opens up
    - Step 1 - Choose Delimited, press next
    - Step 2 - Select 'Other' and put a ~ into the text box. Unselect any other options that may have been selected. Press finish
    - This has created a 4th column, with serial #ed print runs in it (this is why we replaced S# with S~. It created a unique character to split the text with, and wasn't messed up when we split on card numbers)

    You can repeat that step as many times as you like, trying to filter out Memorabilia, Autograph, or any other designation in the 3rd column text.


    If anyone has any questions, please ask. It really is pretty easy - so if I haven't been clear with anything, I'll try and explain better.
    Last edited by 30ranfordfan; 04-27-2010 at 07:23 PM.

  2. #2




    Join Date
    Nov 2008
    Posts
    5,112
    SCF Rewards
    5,467
    Blog Entries
    1
    Country
    Chicago Blackhawks

    Good Idea, but I give it 4 days before someone makes a post asking where to get a players checklist. lol
    Last edited by zunato; 04-28-2010 at 01:22 AM.

  3. #3




    Join Date
    Mar 2009
    Posts
    3,663
    SCF Rewards
    228,236
    Country
    Saskatchewan Roughriders Saskatchewan Roughriders Saskatchewan Roughriders
    See goose97's Items on eBay

    Very nice this is here Sean. I hope everyone sources this out.
    Searching for: Jagr, Palffy, Stumpel, and Boyd
    ***Doing some massive updating. Please be patient!***
    My new trade page is almost complete. My player want lists, and PC is still under construction. It's progress is here:
    Hidden Content
    For Easy Trading use the SCF Inventory Manager! It is Fully Up to Date!!!
    Search my inventory on SCF here:
    Hidden Content
    Also Looking for any CFL Saskatchewan Roughriders Cards!!

  4. #4




    Join Date
    Nov 2008
    Posts
    517
    SCF Rewards
    1,341
    Country
    See tmas03's Items on eBay

    Great info and nice to know that there are more features that i didnt realize that will better help. I mostly copied everything into notepad and ran it through an app that would clean it up for me before I moved it to excel.

    But apparantly according to Beckett you cannot do this because it violates their Terms of Service Agreement.

    Im not here defending Beckett, personally i think they are now since they have changed everything about them. But thought i would let people know.
    Last edited by RGM81; 12-15-2010 at 11:16 AM.

  5. #5





    Join Date
    Aug 2008
    Posts
    13,238
    SCF Rewards
    405
    Country

    excellent step-by-step

  6. #6




    Join Date
    Dec 2009
    Posts
    2,141
    SCF Rewards
    1,617
    Country

    I should add - for paying subscribers of Beckett's online price guide. There are secured .PDF checklist files available to save you the hassle of having to transfer everything to Excel. All you have to do is type in the player's name in the search query, click on the player's name after the search, and there will be a link to the right of the player's photo. It will list all Beckett listed cards for that specific player, set, subset, etc. along with the current book values at the time of you downloading the file.

  7. #7




    Join Date
    Apr 2010
    Posts
    342
    SCF Rewards
    302
    Country

    I should add - for paying subscribers of Beckett's online price guide. There are secured .PDF checklist files available to save you the hassle of having to transfer everything to Excel. All you have to do is type in the player's name in the search query, click on the player's name after the search, and there will be a link to the right of the player's photo. It will list all Beckett listed cards for that specific player, set, subset, etc. along with the current book values at the time of you downloading the file.

    Very nice! I did not know that! I have been struggling with getting all the prices to copy an paste into excel correctly, now i have a nice pdf with all the info.

  8. #8




    Join Date
    Mar 2009
    Posts
    57
    SCF Rewards
    550
    Country
    See grieveri's Items on eBay

    Sorry Mr. Ozzie - I cant seem to accomplish this feat!!
    There is no photo or download button. I am however a Beckett Online user looking for Claude Giroux.
    Could you please elaborate?
    Rick

  9. #9




    Join Date
    Dec 2009
    Posts
    2,141
    SCF Rewards
    1,617
    Country

    Sorry Mr. Ozzie - I cant seem to accomplish this feat!!
    There is no photo or download button. I am however a Beckett Online user looking for Claude Giroux.
    Could you please elaborate?
    Rick

    I'll post up some pictures tomorrow night. Forgot all about this thread.

  10. #10




    Join Date
    Dec 2009
    Posts
    2,141
    SCF Rewards
    1,617
    Country

    Okay, I've attached a few images below for a step-by-step illustration. I used Phil Kessel as an example. Let me know if it's not showing up.

Page 1 of 2 12 LastLast

Posting Permissions

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


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