Solved

Export a directory listing

Posted on 2004-09-08
7
778 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
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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
P2V Windows NT/2000 SP4 3 1,824
VMware converter for windows 2000 server SP4 4 6,031
Restore SQL database from 8.0 to 11.00 ? 3 1,215
Retrieve process time in memory in VB 6 125
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…
An article on effective troubleshooting
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

808 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