Directory Listing Creator

  • Thread starter Thread starter Wilfred J. Southam
  • Start date Start date
W

Wilfred J. Southam

Hi All,

I am looking for a program which will allow me to output filenames and other details from a certain directory to an MS Excel file to analyse. Any ideas?
 
Wilfred said:
Hi All,

I am looking for a program which will allow me to output filenames and other details from a certain directory to an MS Excel file to analyse. Any ideas?
Click to expand...

Quick and dirty way:

Open up a Windows Command Prompt.
Use the Windows dir shell command:
dir /b/s >output.txt

This will create a file called output.txt, containing directory entries.
This can be loaded into Excel.
You can specify more options. Type:
dir /?
to view the options.
 
Wilfred J. Southam said:
Hi All,

I am looking for a program which will allow me to output filenames and
Click to expand...
other details from a certain directory to an MS Excel file to analyse. Any
ideas?
FileMagic (I know it's a silly name) produces a tab-delimited text file
that you can load into Excel or any other spreadsheet. The columns are
Full path name, Attributes, Size in bytes, Timestamp and Filename.
The directory contents are listed recursively (you get the subdirectories
plus files and their subdirectories plus files ad infinitum), and you can
provide a file mask if you want to limit output to a single file type.
It will list all the hidden files too. And is pretty fast.
http://www.homestead.com/adriancarter/index.html
HTH,
Adrian Carter
 
Back
Top