Dr Fred @ Mon Dec 21, 2009 6:53 pm wrote:
I just print the directory to a text file and then edit in excel.
use the dos command dir /b /s,filename.csv
from the directory that contains all your songs (including those in subdirectories).
this will print all the files to the "filename.csv" file.
I find this to be an easy way to correct all of the various spellings of songs. And eliminate duplicates. I find a lot of differing formats for song names, artist names etc.
I spend a lot of time with excel in my day job so it is partially just working with something I know how to use.
Still a big job.
I too use this way, but I have the program JR Directory Printer instead of getting filenames from a dos prompt and it is freeware and Open Office, instead of excel, to actually make the book pages.
http://www.spadixbd.com/freetools/ for Directory Printer (freeware)
http://www.openoffice.org/ for Open Office (freeware)