2011 Upper Deck Exquisite Collection Football Forum

Can anyone add these insert checklists for me? I am woefully inept when it comes this...I have L-TM Tommy McDonald numbered out of 45 from the Legacy insert and 125 Leonard Hankerson numbered out of 135 from the Rookie Auto Patch insert. Thanx!!

Wow, this set is missing 16 inserts/parallels checklists. And the base set is missing the last 96 cards.  You've stumbled upon a real project.

C2C...that being said, I want to add the checklists. I understand the concept (format, etc) but not actually how to make up the checklist. Do you go to other sites that list the cards and then manually type them all into a database/spreadsheet thingy? I don't mind doing that if thats the case, cuz I have no life and am able to sit at home typing away like mad...I just want to be sure to do it correctly. Any help/suggestions/ideas is greatly appreciated!

you can try cardboardconnection.com. you can either copy from the page there or some sets there have an excel sheet you can download- either case, you can copy off the site page or excel into a blank excel sheet and groom it there-- if you're really good w/ excel there are some other tricks you can do to make it even easier

Every now and then you get lucky and the manufacturer has an Excel version that you can download too. A lot of the time the team names don't allign with what this site uses. My least favorite is the PDF checklist for download but at least you can usually copy and paste that into Excel.

Sometimes I copy a checklist's text from a site and paste it into Notepad. With its find and replace feature you can add the commas and get it into a CardNum,Name,Team,Note format in rows and save it as a Text file. Then if you open Excel and go to File | Open | and change it all file formats in the dropdown and browse to your text file and open it. You click Next once or twice and choose Comma Delimited format. Insert two rows at the top and add your CardNum | Name | Team | Note headers and save it as an Excel file. Upload and you are done!

This might look intimidating but after you do a few it gets easy. Start with some some small sets and work your way up.

Just to simplify things a little more - if you're massaging data in Notepad to use in Excel:

Use TABs as your delimiter in Notepad - then COPY the text (Ctrl-A to select all, Ctrl-c or Ctrl-Insert to copy) and then paste into a blank Excel sheet. The TABs automatically put your text into the next cell. If you need to skip a cell (unknown team or something, but you know the SN), put 2 TABs in there. I've been doing that for years now. Then you don't have to worry about saving the file and opening it in Excel. A real copy/paste job.

even if you download a pdf, plenty of sites will convert it to excel for free, takes seconds

One thing to add: you CANNOT trust checklists you find on any other site than this one. INCUDING the checklists issued by the card companies. I am not sure on Topps or others, but Panini usually puts numbers on the checklist but the cards now have letters.

Cardboard Connection copies what the companies give them so are incorrect. Beckett usually makes up something close but not truly accurate.

It's gotten to the point where I won't post any checklists unless I actually see a card, either in hand or for sale online (Ebay, COMC, etc)

why would companies issue incorrect checklists?

Who knows? I assume the first thing they do is create their internal checklists and then design the cards. When they eventually do the numbers and backs they might change it up but marketing might have their original lists to market from.

I've used Panini's website before thinking that it would be great good only to see that they had changed to a lettering scheme on the back.