Solved

Export a directory listing

Posted on 2004-09-08
7
781 Views
Last Modified: 2010-04-12
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
Comment
Question by:tommoran
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 49

Expert Comment

by:sunray_2003
ID: 12005815
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
 
LVL 6

Accepted Solution

by:
tanelorn earned 250 total points
ID: 12005836
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
 
LVL 9

Expert Comment

by:jdeclue
ID: 12006028
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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 6

Expert Comment

by:nomi17
ID: 12010213
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
 
LVL 1

Author Comment

by:tommoran
ID: 12010236
All excellent answers I just tried tanlorn's first and it gave me exactly what I was looking for.  Thanks all!
0
 
LVL 9

Expert Comment

by:jdeclue
ID: 12010285
Cool, glad to see Tanelorn putting out a nice, old, tried and true simple solution. ;) Alot of people forget the easy stuff!

J
0
 
LVL 6

Expert Comment

by:tanelorn
ID: 12010520
thanks!!

:)
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Just changed my 2000 Server DCs IP now what 3 411
Windows 7 7 281
Kill system process in windows 2000 10 216
Windows SBS 2003 filling up disk with NTbackup files 6 183
NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question