I would like to get an Excel spreadsheet that lists the artist name, title of album, and file size for all of my albums on the computer. Each artist has its own folder in My Documents with all the albums within the folder. The end reason is that I want to archive my mp3 files onto CD-ROMs in an organized fashion (for example, putting all my Southern Rock albums onto one CD-ROM). I want to be able to manipulate the list of albums so I can group them together efficiently.
.txt, .csv, or anything else that can be imported into Excel would also be dandy.
Thanks for any ideas.
Sysexporter.
It generally let’s you copy the data from any windows control and paste it into excel.
Not exactly what your asking for but, you might want to take a look at SizeMe.
CMC fnord!
If you had a directory lister you could list all the files, sizes and directories into a text file. I use LS (LS - File List Generator - The Portable Freeware Collection) but I am sure there are better ones)
Just download for free MP3Tag. Despite the name it handles more than mp3 types including mp4s and most lossless forms. (There is a professional version of this program you pay for but you don’t need that.)
Once you get it set up, just go to File -> Change directory to bring up the directory you want.
Then simply go to to the menu that runs across the top and find the icon that says “Export.” (it has the UP arrow) You can export them as CSV (Comma Seperated Values) or a variety of formats.
When you choose how you want to export, say you choose, CSV, you can hit the edit tag and pick and choose what you’re going to export. Or you can export everything to CSV and then later on delete what you don’t want. Of course CSV is easily imported into Excel.
It’s also possible (though harder) to get this information from a batch file or another list run from the command prompt.
Here’s a good website that will start you learning how to run batch files from the command prompt
Thanks, all. I’ll try these out and report back.