Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 785
  • Last Modified:

Export a directory listing

Is there a way to export an ntfs directory listing to Excel?  I am in the process of moving files around to and from directories and I really wanted to be able to export a file/directory listing to excel so that I can script the move on paper before actually performing it.

Thanks in advance,
Tom
0
tommoran
Asked:
tommoran
1 Solution
 
sunray_2003Commented:
Hi tommoran,


You can try this
http://www.galcott.com/dp.htm

Once in CSV you can import into excel or other applications

SR..
0
 
tanelornCommented:
a simple way to get the listing of a directory is to do

c:\> dir > list.txt

this will put the listing in a text file

there are some other programs that will help you out

I use Treesize.  http://www.jam-software.com/freeware/index.shtml

it has an export function right to excel..

Tanelorn
0
 
jdeclueCommented:
I often do a:

dir /l /b /s > tree.txt

same way tanelorn does it.. so I am just adding a little bit;) This way you get a nice clean text file with the full path and file name of all files in the tree.

You can even import it as text and set the delimiter to "\" and sort it all kinds of ways in Excel... you can also do a search and replace on "C:\" to something like "xcopy /e /s /t /v c:\", to turn it into a batch file that copys all of the files and folders to wherever you run it. Oh, so many things you can do!
J

Output example:

c:\documents and settings\profilename\application data\macromedia\flash player\macromedia.com\support\flashplayer\sys\#2ndlight.com\settings.sol
c:\documents and settings\profilename\application data\macromedia\flash player\macromedia.com\support\flashplayer\sys\#sitel.com\settings.sol
c:\documents and settings\profilename\application data\microsoft\access
c:\documents and settings\profilename\application data\microsoft\activesync
c:\documents and settings\profilename\application data\microsoft\excel
c:\documents and settings\profilename\application data\microsoft\file transfer manager
c:\documents and settings\profilename\local settings\application data\microsoft\internet explorer\msimgsiz.dat
c:\documents and settings\profilename\local settings\application data\microsoft\media player\currentdatabase_59r.wmdb
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
nomi17Commented:
Here's a way to do it by installing an option to print from the context menu:

http://www.geocities.com/SoHo/Gallery/6412/PrintDirectory.htm
0
 
tommoranAuthor Commented:
All excellent answers I just tried tanlorn's first and it gave me exactly what I was looking for.  Thanks all!
0
 
jdeclueCommented:
Cool, glad to see Tanelorn putting out a nice, old, tried and true simple solution. ;) Alot of people forget the easy stuff!

J
0
 
tanelornCommented:
thanks!!

:)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now