Transfer album song or movie lists from PC to excel or word

Naturelover

Moderator
Staff member
Joined
Jul 14, 2011
Messages
4,457
Points
113
Location
Nagpur
If you have a whole lot of music (or movies) in your PC and want to have the complete (or folder-wise) list in a file, this is a great way to do it. The final file will need some editing but this is very effective and gets any number of pages in a stroke. I found this on the net. Cannot remember the source.

1. Get to the Command Prompt window
2. Type: D: ENTER [where D is the drive you want to go to and ENTER is the enter key]
PS if you are not sure of the directory name, you can type dir /p ENTER after step 2.
3. Type CD\directory1\directory2\directory3 ENTER [where directory1, 2, 3 are the directories you want to tree. Add more directory names as appropriate]
4. Type Tree ENTER [This will display the tree on the screen just a test to see if you are in the correct directory, otherwise you can type: Dir and ENTER]
5. Type Tree /a /f > list ENTER [Tree*/a*/f*>*list ENTER note * is a space. You can also type: tree/? To see an explanation of the codes. The > redirects the output from the screen to a file called list in the same directory]
6. Close the command prompt [click on X or type: Exit ENTER]
7. You can now open the file in Notepad or in MSWord [It will be saved in the last directory that you tree-ed]
Copy and paste to an Excel file if that's your preference.
 
Check out our special offers on Stereo Package & Bundles for all budget types.
Back
Top