Disclaimer: Links on this page pointing
to Amazon, eBay and other sites may include affiliate code. If you click them and
make a purchase, we may earn a small commission.
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
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.
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.
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.....
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.
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.
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.