Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12
  1. #1

    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 08:23 PM.
    Hidden Content
    Hidden Content

    Hidden Content

    Enter the 1st leg of the UD RAK 'Em Up! contest!
    Hidden Content

    Hidden Content

  2. #11
    Any one know how to get the player checklist on the "new" beckett or a different site?

  3. #12
    Thanks for the help everyone in this thread. Even though its from a little while back. Its nice to find a composed list.

Page 2 of 2 FirstFirst 12

Posting Permissions

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