How to export a file list

[Guest]

Hi All!

I am trying to export a list of files that are in a folder. There are 500+
files and I need to list them in Excel. Any fast way of completing this?

 

[John John]

You can use a command redirection operator with the DIR command. Use
the > redirector.

Example: Create a .txt file and call it test.txt and place it in C:\.
Then open a command promp and navigate to the folder in question then
use the dir command: dir>c:\test.txt the output will go to the
test.txt file. You should be able to send it to an Excel file.

John

 

[John John]

PS. The target file will be erased and rewritten! DON'T send it to one
of your files already containing data. Use the >> redirector to have
the output appended to the end of the file, or use the Excel merge
feature on the new file. Best to do some tests before.

John