Home› Trading Cards & Memorabilia Forum

Help to catalog cards!

yanyak5yanyak5 Posts: 1,383 ✭✭✭
in Trading Cards & Memorabilia Forum
I am up to about 500 griffey base/insert cards and its getting tough to keep track of them. I dont remember what I have when I am talking trades online...any idea of a great way to organize the cards? Im thinking about a spread sheet? I also go to shows and buy cards...whats a good way to track what I have when I am on the move? how do you guys organize them and keep track of everything??

Thad
Looking for an 8x10 auto photo of junior celebrating his 100 HR. lmk!

Comments

  • bkingbking Posts: 3,095 ✭✭
    I have used a very complex spreadsheet for years, but something new is on the way shortly that will make this go away for me.
    ----------------------
    Working on the following: 1970 Baseball PSA, 1970-1976 Raw, World Series Subsets PSA, 1969 Expansion Teams PSA, Fleer World Series Sets, Texas Rangers Topps Run 1972-1989
    ----------------------

    Successful deals to date: thedudeabides,gameusedhoop,golfcollector,tigerdean,treetop,bkritz, CapeMOGuy,WeekendHacker,jeff8877,backbidder,Salinas,milbroco,bbuckner22,VitoCo1972,ddfamf,gemint,K,fatty macs,waltersobchak,dboneesq
  • 72skywalker72skywalker Posts: 1,554 ✭✭✭
    i keep things very simple. I collect yankee topps base cards from 1952 to 2010. I have a small pocketsized notebook that i keep on me with all of my want lists organized by year. that way whereveri am I can pull it out to see if i need the card. I also keep all of my doubles on hand on the side in case i want to make a trade.
    Collecting Yankees and vintage Star Wars
  • vladguerrerovladguerrero Posts: 4,077 ✭✭✭
    the Beckett website allows you to keep a live inventory, and will keep them well organized... if you don't lose your mind getting through all the bugs they have.
  • jeffcbayjeffcbay Posts: 8,951 ✭✭✭✭
    I use an excel spreadsheet for my Ripken cards, with Beckett Book Values.
  • DeutscherGeistDeutscherGeist Posts: 2,990 ✭✭✭✭
    I use an excel spreadsheet too. I log in all my graded cards so I know what I have. The neat thing about is you can conduct searches on it. For example, if you have 1000 cards logged in already and you are looking for your Wade Boggs cards, you can simply go to the player category and put it in alphabetical order and then you have all of Bogg's cards together in one area to look at. You can even do the same if you want to know how many "10" grades you have from PSA or BGS or so on.

    Off the top of my head, I use the following categories:

    year, manufacturer, card#, player, Grading company, Grade, purchase price, purchase origin, special notes


    You can add or modify the categories according to your taste or needs. There are special software out there for card collecting, but I found them to be limiting in some ways. With excel, I can customize how I see fit and I think I usually favor more information than less.

    Its happened to me that there is a special story about how I purchased a particular card and that is why I prefer to have the "special notes" category so I can record that information too.
    "So many of our DREAMS at first seem impossible, then they seem improbable, and then, when we SUMMON THE WILL they soon become INEVITABLE "- Christopher Reeve

    BST: Tennessebanker, Downtown1974, LarkinCollector, nendee
  • redsfanmanredsfanman Posts: 89
    I'm curious to know what others do. I use to use the Beckett site but quit b/c of all the bugs with the new design. I now just use a spreadsheet and the PSA Registry site (My Inventory) for my graded PSA cards. Curious to hear more...
    Visit www.Davis44.com - An Eric Davis Collection.
  • jimradjimrad Posts: 2,777 ✭✭✭
    Microsoft Excel is my friendimage
    Positive transactions with: Bkritz,Bosox1976,Brick,captainthreeputt,cpettimd,craigger,cwazzy,DES1984,Dboneesq,daddymc,Downtown1974,EAsports,EagleEyeKid,fattymacs,gameusedhoop,godblessUSA,goose3,KatsCards,mike22y2k,
    MULLINS5,1966CUDA,nam812,nightcrawler,OAKESY25,PowderedH2O,relaxed,RonBurgundy,samsgirl214,shagrotn77,swartz1,slantycouch,Statman,Wabittwax
  • vladguerrerovladguerrero Posts: 4,077 ✭✭✭


    << <i>I'm curious to know what others do. I use to use the Beckett site but quit b/c of all the bugs with the new design. I now just use a spreadsheet and the PSA Registry site (My Inventory) for my graded PSA cards. Curious to hear more... >>



    Beckett brought back the old style registry (same as PSA's) and it works great (for BGS cards)...
  • bkingbking Posts: 3,095 ✭✭
    I currently use a spreadsheet (or four), but am currently working on a Website to handle all of it more gracefully - reports, Ebay watches, etc.
    ----------------------
    Working on the following: 1970 Baseball PSA, 1970-1976 Raw, World Series Subsets PSA, 1969 Expansion Teams PSA, Fleer World Series Sets, Texas Rangers Topps Run 1972-1989
    ----------------------

    Successful deals to date: thedudeabides,gameusedhoop,golfcollector,tigerdean,treetop,bkritz, CapeMOGuy,WeekendHacker,jeff8877,backbidder,Salinas,milbroco,bbuckner22,VitoCo1972,ddfamf,gemint,K,fatty macs,waltersobchak,dboneesq
  • yanyak5yanyak5 Posts: 1,383 ✭✭✭
    Okay, so i just realized i have excel. Wow, had no idea i had it. Anywho. I have been playing around with it a bit, but was wondering if someone had a good sample pic i could use as a reference. I'm thinking i should have the following: Year, Company, Sub set, # and Notes. Also, is it possible to organize the cards by year and then change it to company, or # without having to re enter all the info?( all the years are mixed together. Will it arrange the cards automatically as i input them??) Also how easy is it to copy and paste the work into txt documents so i can poston my site what i have and what i need? any other tips or help would be greatly appreciated.


    Hope it made sense...thanks...
    Looking for an 8x10 auto photo of junior celebrating his 100 HR. lmk!
  • jeffcbayjeffcbay Posts: 8,951 ✭✭✭✭
    I copy/paste Beckett's online checklist of Ripken's library (with prices) into an excel file (using Paste Special/Unicode Text) and then I added a quantity column. After that I added a Total Value column, and put a total sum at the bottom. That way it changes as I add/subtract cards. This works really well if you stay on top of it, but I haven't maintained mine for a year or so. I have to do another inventory. I have over 4000 raws now, which feels like a lot to me, but there are tons of people on here that would put mine to shame.
  • fattymacsfattymacs Posts: 2,581 ✭✭✭
    I usually just scribble #'s on old envelopes, hope this helps!
  • byronscott4everbyronscott4ever Posts: 932 ✭✭✭
    If you are more technically savvy and have it, Microsoft Access is really good too. You can build a database and query or sort what you want from the list. With Excel, just be careful to sort so that you don't lose your header (top row) into the document or sort some rows/columns and not all of them at the same time as that will hose up your info.
  • bkingbking Posts: 3,095 ✭✭


    << <i>If you are more technically savvy and have it, Microsoft Access is really good too. You can build a database and query or sort what you want from the list. With Excel, just be careful to sort so that you don't lose your header (top row) into the document or sort some rows/columns and not all of them at the same time as that will hose up your info. >>



    Excel rule #1: ALWAYS save your sheet before sorting or doing a Find&Replace.
    ----------------------
    Working on the following: 1970 Baseball PSA, 1970-1976 Raw, World Series Subsets PSA, 1969 Expansion Teams PSA, Fleer World Series Sets, Texas Rangers Topps Run 1972-1989
    ----------------------

    Successful deals to date: thedudeabides,gameusedhoop,golfcollector,tigerdean,treetop,bkritz, CapeMOGuy,WeekendHacker,jeff8877,backbidder,Salinas,milbroco,bbuckner22,VitoCo1972,ddfamf,gemint,K,fatty macs,waltersobchak,dboneesq
  • byronscott4everbyronscott4ever Posts: 932 ✭✭✭
    If you use Excel, you may want to create a back-up of your list if you are prone to errors. Of course, go under "Edit" and select "Undo" at the top is good to know too.
  • 2cardguys2cardguys Posts: 428


    << <i>Okay, so i just realized i have excel. Wow, had no idea i had it. Anywho. I have been playing around with it a bit, but was wondering if someone had a good sample pic i could use as a reference. I'm thinking i should have the following: Year, Company, Sub set, # and Notes. Also, is it possible to organize the cards by year and then change it to company, or # without having to re enter all the info?( all the years are mixed together. Will it arrange the cards automatically as i input them??) Also how easy is it to copy and paste the work into txt documents so i can poston my site what i have and what i need? any other tips or help would be greatly appreciated.


    Hope it made sense...thanks... >>



    If you place each item that you could want to sort by into its own column; then you can sort any way you want to. As an example...

    Year; Card#; Company; Player Name; Variety; Your Cost; Date Acquired; Value; Grading Co; Grade; Cert# ; Population Grading Cost; Notes

    These are some of the colums that I have in mine. Then if you select all; you can click on data and sort anyway you desire, i.e. all Year Baseball in card number order...

    It won't arrange the cards automatically but its very easy to sort it any way that you want. Hope this helps.. if you PM me a email address I email you a sample sheet
    Positive and successful transactions with:
    LeagueLeader; IJustLoveCards; Recbball; msassin; leathtech; lsutigers1973; Bosox1976; Dboneesq; Aric; Bkritz
Sign In or Register to comment.