Excel Spreadsheet for collection

[JoshuaBaseball]

I was curious if anyone has tried and/or had any success at creating a spreadsheet via Microsoft Excel for their collection. If so, I'd love to hear about it and maybe bounce some ideas back and forth. Thanks

 

[goobmcnasty]

I started one for my Griffey collection. It makes it easy to sort by how it does/would appear in Beckett. Still a work in progress...

The fields are:
Year/Main Set/Subset/Parallel/Insert/Insert-Parallel/Card #/Serial#/Print Run/Pack Odds/Amount Paid/Current Value/Other Players On Card

**Not every card has an option for every field. I can email you a small portion if you'd like for you to play/sort with.

 

[Brewer Andy]

All the time, super easy. I also use Google Docs so I can access my sheets anywhere/anytime

 

[tonsofcommons]

Here is my excel spreadsheet that I loaded in to Google Docs.

https://docs.google.com/spreadsheets/d/1FMoDPkkLdXaaOwjrNZ7irPZPrmGGnGVGh3I1LSAD5sc/edit?usp=sharing

Very nice for set collecting. Each set has it's own tab.

 

[Nate Colbert 17]

Even I can do it!

I have a main page with value formulas from other sheets and individual sheets for each set/player/theme.

 

[jszczech]

I have used one for a few years. I just have tabs on the bottom for different years and then a bunch at the end for oddballs. Takes a while to get it going but it's worth it.

 

[JoshuaBaseball]

Wow! Thanks guys, I'm very impressed with the community here.

 

[Hawk8]

I also use google docs. I just found out about creating different tabs so mine is over 5000 lines long right now. I would be lost without it

 

[linuxabuser]

I use a pretty basic Excel sheet for my set collecting. I do master sets, so the base set gets a sheet, each insert set gets a sheet, and so on. For something like 2011 Topps Heritage, where the Chrome/Ref/Black ref/Green ref/Black border all share the same players, I'll stick all of that on one sheet, and each parallel gets a column.

Every card I have gets an X, and every missing card gets a red background. I have a macro to count the number of red cell backgrounds to give me my percentage.

If you're interested, I'll send one over.

 

[Calripkenjrcollector]

Yup, I use excel also. I like it best because I can hyperlink a scan of the card into it. Press the little X and viola! A scan of your card appears like magic.....

 

[Techniq]

I use it.. Well, the OpenOffice version for my auto collection. Nice, organized, and easy to update and keep track of.

For this use I have columns for player name, set, card number, team, type of autograph, ink color, serial number if applicable, inscription, and one seldomly used for notes - tends to just be for multi-signed.

 

[CatdaddysCards]

Yessir. I use excel for everything card related. Have google drive, drop box and one drive apps on the laptop and iPhone, so I have multiple copies saved and accessible, regardless of where I'm at.

 

[rsmath]

i use excel or OO Calc for autos and relics in my PC. Sure makes it nice to find out if I already have an auto or relic of a given player, considering I have 7 binders full of just autos/relics in my collection.

Name, team, year, manufacturer and brand, columns tp note jersey, relic, or both, column for serial numbering if any, column for notes where I say if it's sticker or on-card, ink color, color of jersey swatch, description of patch, etc.

 

[BiggioBrooks755]

I use Google Docs Works awesome

 

[JoshuaBaseball]

Thanks again guys I really appreciate it! To all who stated they would send me a link please pm it to me. Thanks again

 

[Lancemountain]

I use excel sheets for all my sets/player collection/type sets- card, date acquired, price paid, serial number

 

[DaleMurphyCollector]

Access database, but can dump into Excel spreadsheet if need be.