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
LVL 1
tommoranAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows 2000

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.