What software do you use to keep up with your inventory/collection?

blaze42 · May 13, 2006 6:00AM

I have cards, programs, wire photos, books and newspapers. Now (gulp) I want to catalogue my collection to include storing pics of each item. What is every-one using? TIA...

puggy · May 13, 2006 6:27AM

That is what I want to know also.I need to get my all organized.I just want to be able type the card in and it says I have it or not.Instead of looking threw about 100,000 cards or so.

alnavman · May 13, 2006 6:58AM

Great question....I'd be interested also.....Obviously some of my collection is kept track via the Set Registry but what to do with everything else....

blaze42 · May 13, 2006 7:09AM

FWIW, I'm thinking about using this one.
I'm not very computer literate so I don't know if it's good.

http://www.tucows.com/preview/333804

etown99girl · May 13, 2006 7:10AM

EXCEL works great!

softparade · May 13, 2006 7:12AM

Excel does work great. If you know how to use it properly!

Kurtman9 · May 13, 2006 7:15AM

I use Excel spreadsheets... I name each sheet with a tab at the bottom with the name of the set. Then, I put columns on each sheet like: Player Name Card # Cent R/L Cent T/B Purch Date Orig $ Curr Value Net G/L % G/L. Of course, the player cards go on the rows. Also, it's good for tracking cards you bought and then sold... Year Player Name Card # Cond P Date Orig $ Sale Price % G/L Net G/L.

The great thing about Excel is you can use the formulas to do all the math for you and then you can have a grand totals sheet that adds up the totals for each set and it gives you a total $ value of your collection. Again, I never have to do any math as that is all done by the formulas for the cells that I created initially. I have 18 tabs with thousands of entrys and the whole file is only 534 kb. Excel is a great program IMO.

blaze42 · May 13, 2006 7:15AM

I don't know anything about excel, but I will go ahead and ask.... can you search your excel spreadsheet?

Kurtman9 · May 13, 2006 7:16AM

yes... "Edit", then "Find"

blaze42 · May 13, 2006 7:19AM

thanks..btw would you mind checking out my link .. http://www.tucows.com/preview/333804 .....and at your leisure, tell me what you think...

etown99girl · May 13, 2006 7:23AM

http://www.tucows.com/preview/333804

????????????

DeutscherGeist · May 13, 2006 7:26AM

I am in the process of doing the same, so I have decided to use excel.

Its on my computer right now, so I don't need to spend any money. There are software out there specifically for baseball card collection, but they all have some sort of draw back. At least with Excel, you can create the spread sheets to serve your purpose.

Save your money and just use the Excel program on your computer. My 2 cents.

ToppsCo1lector · May 13, 2006 9:29AM

Yeah this is something I need to start doing. Really my only organization at this point is....
Graded in one area
Toploaders in another
Team bags/soft cases in another
loose/cardboard boxed

Eh, I have Excel so I think I just figured out what to do for the next lil while.

bobbybakeriv · May 13, 2006 10:39AM

I use MS Excel too, which is pretty handy once you get organized.

bobsbbcards · May 13, 2006 10:44AM

I also use Excel to track my collection and wantlist. I don't do it, but you can insert hyperlinks into Excel that point at card pictures (either on your desktop or on the Web).

blacksoxfan · May 13, 2006 4:55PM

CardPricer.com will be going live shortly (not sure of date yet)...which will allow you to manage your collection properly... there will be some importing tools available as well (at some point) so for all of you who have organized your collections in excel, you can get it into the program.

Patience is a virtue ... we're working on it though.

bri2327 · May 13, 2006 9:52PM

For those who have been using Excel for their collections, assuming you have a basic knowledge of excel how long would it take to set up info for a collection ? Just as an example, say I had approx. 2,000 graded cards, 100 raw sets, another 1000 raw singles, and some misc boxes and other items. Any insight would be greatly appreciated.

HoofHearted · May 14, 2006 2:06AM

<< <i>I also use Excel to track my collection and wantlist. I don't do it, but you can insert hyperlinks into Excel that point at card pictures (either on your desktop or on the Web). >>

Bob! It's amazing you shared this. Just earlier this year I started cataloging my Puckett and '62 Topps collections in Excel. This thread got me thinking about inserting pictures, which you can do, but (just moments ago!) I played with inserting the hyperlink thing -- and it works PERFECTLY!! I'll have to try the URL link. That way I can keep the pictures on Photobucket instead of my harddrive...

This is a great way to share knowledge. Thanks!

hh

fsjeter · May 14, 2006 4:10AM

I've been slowly working on an Access Database program to organize my collection. It is more difficult and involved than I originally thought but the finished product should be nice. I hope!

Scott

fsjeter · May 14, 2006 4:12AM

<< <i>I have cards, programs, wire photos, books and newspapers. Now (gulp) I want to catalogue my collection to include storing pics of each item. What is every-one using? TIA... >>

I haven't seen any software yet that includes programs, wire photos, books and newspapers. I've only seen programs for cards.

Scott

blaze42 · May 14, 2006 5:47AM

Admitting I don't know excel, I'm thinking that if you can make a spreadsheet for cards...the same would be true for any grouping. Columns (descriptors??) would be different, but basically what I want is....... item....condition....price paid....BV...........image

What software do you use to keep up with your inventory/collection?

Comments