Inventory of vinyl - what software do you use?


I am finally going to inventory my records this winter, or so I hope. I am wondering what software applications other Audiogoners use for this task. A specialized vinyl inventory program? MS Access or other database program? Also, what categories do you find most useful to keep a record of, besides Artist and Album name, condition of vinyl, record label, etc.?

I am not looking forward to this task but it is necessary, I think. I have been putting it on the back burner for way too long, out of pure laziness. I would like user-friendly software, with the ability to sort by field.

Please tell me what you use!

Holly
oakiris

Showing 2 responses by tswhitsel

I too have been cataloging my vinyl, but it never even occured to me look for specific software. Thats what spreadsheets are for and I use Excel. The nice thing about Excel is you can lay it out any way you like, with as much or as little space as your specific catagory requires, and you can play around with fonts, font size and color, bold, underlined, etc. Another nice thing about Excel is you can use as many 'sheets' as you like to organize different catagories of music. Excel 2003, which I use, defaults to three sheets, but you can set it up to as many as you like. If you've not used Excel it is easy enough to figure out the basic functions even though it has levels of complexity most of us will never need or even know about. For example I have used it for making frequency graphs for plotting the in room frequency response of my Talon Khorus loudspeakers. While cataloging your LP's can turn into a huge task (I have well over 1000 LP's) it is actually kind of fun once you get started. It's also a great opportunity to go through albums you may have forgotten about. If you have Microsoft Excel on your computer I can send you a copy of my inventory which you can use as a template if that would help get you started. Just send me a private email.
"Using a spreadsheet you construct from scratch is a horrible idea. Why would you want to type all of that in when it has already been done?"

Has it been done? I bet not. If so I sure would like to know where I can find it. I believe the topic was vinyl inventory, not CD. The programs mentioned here seem to be useful for a CD database, but limited or nonexistant for LP's. And of the databases that do exist for vinyl do they differentiate all of the different labels and pressings of a specific title? Even if it did, by the time you search through several data bases to find your specific pressing and then fill in the fields you probably would have spent much more time than it would have taken to type in the information yourself. No matter what you do inventories require work and spreedsheets are a useful tool.

I guess it depends on what you are trying to accomplish with your inventory. The reason I like a spreedsheet is because it gives me the ability to arrange my collection alphabetically and it's all on a single page I can easily scroll through and print out if need be. Having a separate screen shot for each title is just not useful to me and requires too much work to look through.