Question Folder listing

[unbrakochaz]

Is there an easy way to get the list of images in a folder into a spreadsheet?

 

[jeremyj_83]

While I don't have the script written, it should be able to be done using powershell.

 

[unbrakochaz]

I'm afraid I'm not familar with powershell. Is it a CMD prompt tool?

 

[USAFRet]

Sure, mostly.

From a commandline, you can output the contents of a folder to a txt file.

Navigate to the folder in question.
The actual command would be:
dir *.png > printit.txt

Resulting in a text file that looks like this:

Then, open that in Excel. Space delimited.
Depending on how your files are named, It may require some cleanup, but it is all there.

 

[unbrakochaz]

nice one, thnak you and thinking about it if I create a .csv it will open straight into Excel with a double click

 

[USAFRet]

nice one, thnak you and thinking about it if I create a .csv it will open straight into Excel with a double click

Yes, but depending on how your files are named, the comma may impact what ends up in which column.

Try it both ways. Takes but a second or two.