[transmitthis]

Just as an update, here is an easy way to do this, instead of messing about with other programs or cmd.

Create a new folder called test in C:\
open your list in excel - see image
Alt+F11 to open up the VBA editor.
Select insert Module - In the box add this code

Sub Test()
For N = 1 To Cells(Rows.Count, 1).End(xlUp).Row
    Open "C:\temp\" & Cells(N, 1) & ".txt" For Output As #1
    Close #1
Next N
End Sub

switch back to sheet, Alt+F11 (or close editor)
Click on view then macros, and run it

Go to that test folder you created, and you will see its full of txt files (all named from each cell ready for you to add to calibre



Don't ask me about the code, as I just edited some I found, (as you do) and don't fully understand it.

one tip, just use alphanumeric . and - are ok, but dont have a ":" in the text




Oh - while I'm here:
This is probably relevent to anyone coming here from a search
Create File list from folder structure ie Text list of Folders

1. run cmd
2. cd to the folder you want the list of (Type CD then space then the folder, for example "CD C:\Storage\BFG\Allthefiles\
3. paste this no quotes "dir /b /s > c:\filelist.txt" then enter
4. list is in c:\filelist.txt

remove the /s if you don't want subdirectories