DJing Discussion

This area is for discussion about DJing in general. Please remember the community rules when posting and try to be polite and inclusive.

Extract file names from Windows Explorer to Excel

KMXE 11:16 AM - 28 February, 2007
is there a way to select a whole bunch of files in windows explorer (in this case MP3's) and export just the file names to an excel spreadsheet?
DJ_X_Trodinaire 8:08 PM - 28 February, 2007
i use tagscanner to print/export out my song list to html,xls,doc etc

this program you can sort the songs however you want it
nik39 8:47 PM - 28 February, 2007
Quote:
is there a way to select a whole bunch of files in windows explorer (in this case MP3's) and export just the file names to an excel spreadsheet?

In one folder or separate folders?
KMXE 10:33 PM - 28 February, 2007
Quote:
Quote:
is there a way to select a whole bunch of files in windows explorer (in this case MP3's) and export just the file names to an excel spreadsheet?

In one folder or separate folders?


just 1 folder at a time i guess....

x-trodinaire - thanks for the tip, i'll go check it out
nik39 10:37 PM - 28 February, 2007
start->execute-> enter "cmd", that will open the windows command box

Go to that folder, for example, its on drive d:, "d:\newMusic\", then ..

enter

Quote:
d:
cd d:\newMusic

then enter

Quote:
dir /b > files.txt

That will write all filenames into a textfile called files.txt, which you can easily import into Excel.
KMXE 10:39 PM - 28 February, 2007
cool - i'll definitely check that out nik...... might be much easier this way!
nik39 10:40 PM - 28 February, 2007
Maybe not easier... but it's free :)
sweetL 11:07 PM - 28 February, 2007
nik... u git, i was about to post that.
dj cubicle 11:14 PM - 28 February, 2007
hah, i was gonna post that this morning when i got into work but i thought he wanted to pick & choose files. *le sigh*
nik39 11:19 PM - 28 February, 2007
Pfff... I call ya shenigans ;)
dj cubicle 11:25 PM - 28 February, 2007
show me the broom buddy, show me the broom. ;-)

kmxe, you can also do

dir /b /s > files.txt

to get a list of all files in the folder you're in and also all sub-folders.
nik39 11:28 PM - 28 February, 2007
Quote:
dir /b /s > files.txt

KMXE, cubicle is /b /s 'ing in you ;)

BTW workaround to get distinct files... search in explorer, move them temporarily to a folder, extract the names, hit ctrl+z inside exporer to undo move'ing those files.
dj cubicle 11:58 PM - 28 February, 2007
whatchu mean bs'ing? ;-) works just fine for me... LOL
nik39 12:01 AM - 1 March, 2007
Quote:
dir /j /k > haha.txt


Enough nerdism for tonight. ;)
KMXE 12:03 AM - 1 March, 2007
ha - u guys are a cack.... thanks for the heads up nik....
dj cubicle 1:10 AM - 1 March, 2007
don't make me bust out the pocket protector scratch. :-)

*back to work on breakin-records*
JayB1200 2:53 AM - 1 March, 2007
Quote:
i use tagscanner to print/export out my song list to html,xls,doc etc

this program you can sort the songs however you want it


I just Tried This Method And It Works Great And Its Really Easy
MusicMeister 6:27 AM - 1 March, 2007
Use MediaMonkey...

or you can do as was shown above:

dir /b /s >files.txt

Then you can import the files.txt into excel.

But a FAR better method is to use MediaMonkey to read in the files in the directories, put them all in a playlist (just highlight them all, right click and create a new playlist) and then export to an excel spreadsheet. It's FAR faster than anything you can do from the command like without installing perl or writing a really involved script.
DJ Clark Breaking-Records.com 12:59 AM - 3 March, 2007
Quote:
don't make me bust out the pocket protector scratch. :-)

*back to work on breakin-records*


GET TO WORK!!
KMXE 9:57 AM - 6 March, 2007
Holy crap - i used to use The Godfather to mass edit tags - but Tagscanner sh*ts on this...... highly recommened!
allenbina 6:18 AM - 14 March, 2007
Quote:
start->execute-> enter "cmd", that will open the windows command box

Go to that folder, for example, its on drive d:, "d:\newMusic\", then ..

enter

Quote:
d:
cd d:\newMusic

then enter

Quote:
dir /b > files.txt

That will write all filenames into a textfile called files.txt, which you can easily import into Excel.


that took me back to windows 3.1 and nibbles.