Spreadsheet for large collection « Tim's Phonographs and Old Records Forum

Tim's Phonographs and Old Records Forum » General

Spreadsheet for large collection

(8 posts) (3 voices)

Started 9 months ago by planesman
Latest reply from m120407

planesman
Member

My father recently passed away and left me with an absolutely massive collection of records. I would like to start the process of cataloging in a professional way in an Excel spreadsheet and was wondering if one of the experts on this site had one, or could tell me what fields I should have in the spreadsheet to do it right. I would like to take my time over many months, perhaps years and put every field of data a professional from the music industry would appreciate. I would also prefer not to use one of the programs I've seen on the web and just stick with an Excel spreadsheet format.

Any advise would be appreciated.

Thanks

Posted 9 months ago #
SunnyDaySmiles
Member

I made a spreadsheet for mine - but I am an amateur collector. Spreadsheet really are the way to go in order to access your record database quickly.

I just started with the following headings: Album Title,Side A, Side B, Artist, Manufacturer,Size, Notes (condition, label color, etc.),Date (if given).

Does that help?

Posted 8 months ago #
planesman
Member

Thanks Sunny, yes, that does help and I intend to begin developing the spreadsheet tomorrow. I believe I'll add the record company name and the series number of the Single or LP as well.

Best, Mike

Posted 8 months ago #
SunnyDaySmiles
Member

Hi Mike,

The inclusion of the series number would be a boon to collectors trying to pinpoint the age and value. Good thinking. Although, if you have a large collection, it might be a little time consuming (LOL). Perhaps you'll find that you have some hidden gems, eh?

Good luck,
Sunny

Posted 8 months ago #
planesman
Member

Hi Sunny, yeah, some gems would be nice, but I'm thinking more along the lines of a family collection to hand down to my kids one day. My father was quite a fanatical collector and maintained most of the records is near perfect condition. He really loved Sinatra and Barbara Streisand and labelled a plastic cover over the albums and singles with the specific number from each record company. He literally has every single recording Sinatra ever made, including foreign ones. They're neat to look at and I have the space to maintain them indefinitely.

Best Regards,
Mike

Posted 8 months ago #
planesman
Member

Hey Sunny, look what you helped me get started on. I'm about half way through the single records. And there are four times as many albums.

https://docs.google.com/spreadsheet/ccc?key=0AtRB_Fwvaw_LdDVGVjJBNEl4UzdlWnNwUkZDNXFaZGc#gid=0

Posted 6 months ago #
planesman
Member

All, since I've received about a dozen requests to download the spreadsheet above, I wanted to let everyone know I made the spreadsheet publicly available to everyone.

Enjoy!

Best Regards,

Mike

Posted 3 months ago #
m120407
Member

Hi Mike,
Thank you for sharing your spreadsheet. I need to start the process with my father's old 78 records. I'm not sure how many he has, but I like you I want to make sure that I get all of the important information captured. I'm not sure whether we will sell it or just donate it. I was a little dissapointed to read that Glenn Miller and Tommy Dorsey aren't considered a "hot" commodity, my father has mostly those kind of records. But I will start the process of cataloging.

mandy

Posted 2 months ago #

RSS feed for this topic

Reply

You must log in to post.