How to copy thousand of song file names and paste into word/excel format. . .?

Question

How to copy thousand of song file names and paste into word/excel format. . .?

Answer 1

Doing it from a command line would be so much easier as Urxmlf said. Try:



dir /b *.cdg *.mp3 *m4a > C:\Temp\output.txt



Note: The "/b" flag does a "bare" listing so you only get the file names. You can then easily read the text file into Word or Excel.



If you need something more advanced (i.e. pulling metadata from the file), writing a program would probably work best. Another option if you already have in a music application would be to look at the play list. Some applications allow exporting the play list, others you may need to look at the "saved file".

Answer 2

ask a programmer to do it for you. it is pretty easy for him.

maybe just 10 minute,



for instance in C#:

use:

System.IO.DirecctoryInfo

&

System.Data.OleDB

Answer 3

In the words of the song, One by One..

Answer 4

Honestly you are being a bit picky if not in dos. 1 Simple command can do exactly what you need!



Example: The following directory has 5000 songs



C:\Users\MyProfile\Music>



You want to make it into a spreadsheet so you would type this at the prompt:



C:\Users\MyProfile\Music>dir > songs.csv



That would create a CSV file (excel can open this type perfectly fine).



At least give it a try. The only other way would be to find a music cataloging program that allowed you to "Export music lists into spreadsheets" but I have no idea what to choose for your unknown operating system.



Good luck though - not what you wanted but totally doable if you get the basics of DOS. If not, very sorry - I tried.