How to export file list from Windows Explorer to Excel?

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

Guest

Hi

I need to make a list of all files which are in one of directories on my PC. The list should be exported to Excel. Any idea how to do it

Thanks in advance!
 
Jan said:
I need to make a list of all files which are in one of directories on
my PC. The list should be exported to Excel. Any idea how to do it?
Click to expand...

Open a command prompt..
Go to said directory..
type in

dir /?

Use the options you need followed by "> c:\temp\filename.txt"

ie:

dir /s /b > c:\temp\filename.txt

This will pipe the results of the dir command to a text file located in
C:\temp and named "filename.txt" - then you can import that into Excel.
 
Back
Top