Exporting checklists from Beckett website

[Matty4292]

Hey Guys,

I was just wondering if there is any way to either print a checklist from beckett or save it as a word document or something like that?

The website can be frustratingly slow and it'd be nice to have a Donruss and a Bowen checklist handy.

Any help would GREAT

Cheeeeeers.

 

[WoobieZarz]

Copy/Paste to excel is your best friend Matty.

I actually done it less than 2 days ago.

Depending on the cards, they have some extra shit (symbols, links, etc) that you probably don't want, but majority is helpful.

I'll get a link to how mine look in a few mins.

EDIT:

DESCRIPTION NUMBER PLAYERS PRINT RUN BV HIGH STATUS
2003-04 Finest 177 Devin Harris - $20.00 Want
2003-04 Finest Refractors 177 Devin Harris 250 $40.00 Want
2003-04 Finest Refractors Gold 177 Devin Harris 25 $60.00 Want

 

[WoobieZarz]

Sorry, for some reason the tabs don't show up.

We really need that Google Docs plugin!!!

 

[WoobieZarz]

This is how it looks on Beckett's website:​

​

This is how it looks after I've finished:​

 

[Matty4292]

Hmm... I'll have to track down a copy of Excel and see how I go

 

[WoobieZarz]

You MIGHT be able to do use Open Office's free version (Calc) - google it.

Just not sure about splitting cells, SHOULD still be able to....

 

[ooneil]

Just jump.onto www.tradingcarddb.com.

Heaps better than becketts

 

[gemini0928]

PM Sent...

 

[Billyhoyle]

Just jump.onto www.tradingcarddb.com.

Heaps better than becketts

better site for sure, not sure how accurate though. Lists 1512 camby cards. My spreadsheet from Beckett 1623. Also the printable version doesn't list the full version of the card, so parallels are listed the same as the base.

 

[ooneil]

better site for sure, not sure how accurate though. Lists 1512 camby cards. My spreadsheet from Beckett 1623. Also the printable version doesn't list the full version of the card, so parallels are listed the same as the base.

One in every crowd.

 

[postgsl]

Copy/Paste to excel is your best friend Matty.

Scotty, are you just doing a simple copy/paste?

Did you know that if you Copy/Paste Special/Paste as Text it removes all of the annoying symbols?

I did find that it puts an extra row in between each listing though

 

[Cobretti]

beckett use to be a bit cleaner to copy from.

what i dois paste it into a txt file to get ride of the symbols and then i open im excel the tx (because I use the space between words to create columns). then i delete the unwanted ones.

I also use

http://millercards.net/

some times as it is less crap in terms of formatting but good for sets.

 

[WoobieZarz]

Scotty, are you just doing a simple copy/paste?

Did you know that if you Copy/Paste Special/Paste as Text it removes all of the annoying symbols?

I did find that it puts an extra row in between each listing though

Yep, that does work, but instead of the symbols, you get them in a new line, so you still need to remove them manually.

Imagine the amount of "RC", "AU", "MEM" lines for Harris' checklist!!!

I guess the end result will be the same, and nothing's ever going to be a straight-forward process for what we need.

EDIT:
This is the txt paste (match destination);
2003-04 Finest #177 Devin Harris XRC - $20.00 Find in the Beckett Marketplace
2003-04 Finest Refractors #177 Devin Harris 250 $40.00 Find in the Beckett Marketplace
SER
2003-04 Finest Refractors Gold #177 Devin Harris 25 $60.00 Find in the Beckett Marketplace
SER
2003-04 Finest X-Fractors #177 Devin Harris 1 n/a Find in the Beckett Marketplace
SER
2003-04 Upper Deck Legends #140 Devin Harris XRC - $12.00 Find in the Beckett Marketplace

 

[WoobieZarz]

^So every few lines, there's the "SER" and of course, there's the RC, AU & MEM for each card type that there is.

 

[postgsl]

^So every few lines, there's the "SER" and of course, there's the RC, AU & MEM for each card type that there is.

This is only a one line example but I have everything appear in the one line so need need for extra editiing but it ends up looking like this. I think the SER stands for Serial Numbered


2009-10 Panini Threads Triple Threat Autographs #4 Kobe BryantAUSER

 

[WoobieZarz]

Yeah, SER = Serial Numbered, AU = Auto, MEM = Memorabilia, RC = Rookie Card, etc.

Depending on how you like your spreadsheets, yeah you only need to remove those extra lines with the SER/AU/MEM/RC, etc

Can be done by holding Ctrl and clicking to the left of each row (selects entire row, and by holding Ctrl it selects multiples).

 

[Cobretti]

ther eis an easy way to get rid of all that

RC, AU etcc. when it goes to another line.

Turn on Auto filter for the rows of data

then Filter for each keyward equal to RC etc..

Then you can just delete the rows in excel by highlighting the whole rows and rightclick on the line numbers and click delete rows.

Then turn filter off and no more shit.

 

[WoobieZarz]

Fark, if only I knew that the other day! Took me about an hour or so to sort the Harris checklist out. Barkley was easier.

 

[Matty4292]

Ok, So I have a checklist in a spreadsheet, Whats the best way to get that onto here as a Wantlist?

 

[WoobieZarz]

Hmmm. Perhaps stick it online in a google docs and share that, then we link to it?

Or you could copy/paste it to a new thread in want lists.