Computer Help

P

PuroBrat

I am not here :^)
Joined
Apr 2, 2002
Messages
4,227
I have Windoze XP, my wife has a folder packed full of songs, she wants a spreadsheet in Excel 2000.

Does anybody know of a software or a Win Command that will list file detaials of a folder and put them into a spreadsheet?
 
You're a lot of help bro ???

:p thanks for giving it some thought anyway :thumbs:
 
Check THIS out. It's a step in the right direction. Remove all options except the file name. It will drop a list into Notepad. You should be able to copy/import them into Excel from there.

Let me know if this helps,
Dave ;)
 
One more thing that may help... I notice it puts a couple of spaces before the file name. If you have Word, I can help. Copy the list into word, then hold down the ALT key while highlighting the empty space before the filenames. By holding down ALT, you can cover a box without all the extra info on the line (it will make sense when you do it). Then delete what you highlighted. You should be able to copy just the filenames (without leading spaces) into Excel now.

Good Luck!
Dave
 
exactly what file details do you want PB. I could whip up a windows script pretty quick to give you file details with commas between them (which imports into Excel)
 
it is for my wife actually. She wants File name, file size, all MP3 info (artest, song length etc.)

I asked her what details she wanted, she simply said "All of them" ???
 
I'm not sure if this helps or not, but.......... If she is organizing things perhaps an MP3 player that organzes things will work instead of excel. I have Music Match Juke Box and really like it a lot. I paid for it a while back so I'm using version 8.2. Mp3's store a lot of there information in the tags but it takes a good player to display it all, organize and even edit it all. Sounds like everything your wife wants is right in the tags that Music Match uses providing the person that ripped the mp3's got the tags correct. It's even nice in that you can do global edits and such. you can burn your music cd's with it and if you have a full version you can make jewel case labels and such for your cd burns. They are even storing album art with the mp3's more and more now. I like it a lot, and it's all I use for MP3's anymore.

Perhaps that may help. I'm not married, but I hear they can be a little picky at times so perhaps not. :p
 
gibu said:
Perhaps that may help. I'm not married, but I hear they can be a little picky at times so perhaps not. :p
Click to expand...
you hear correctly my friend. And with mine...Picky is an understatement. Thanks for the Tips, I will pass them along. I offered to do it for her...

"What the hell, you think because I don't have a D**k I can't figure things out..." I decided at that point to shut up, go to my room and read a book :p
 
gibu's also on the right track here - I've seen a few players (can't remember which yet) that will allow you to export your library as comma separated values - which then imports into excel. Start with a good mp3 site that reviews players and you'll be well on your way.
 
Yeah, a MP3 player is probably the easiest way. Sorry I thought you were just looking for file info that I can very easily get. Getting the MP3 tags would take a bit more research.

-Mike
 
Winamp lets you build an HTML listing from your playlist. I suspect you might be able to just cut and paste from there into an Excel spreadsheet..
 
You must log in or register to reply here.
Top