How to export a file list

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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
 
Back
Top