Export files and folder hierarchy of Windows 2008 volumes to Excel.

Posted on 2013-06-13
Medium Priority
Last Modified: 2013-07-03
I need to export the files and folders hierarchy of a big WIN2K8 volume to excel.  Is there a native tool to do that?  

Please advise.
Question by:nav2567
  • 2
LVL 44

Accepted Solution

Adam Brown earned 1500 total points
ID: 39246264
How do you want it exported? In tree form? If so, open CMD, go to the root of the drive you want to get data from and type
tree >> c:\file.txt

It'll have some funny characters if you do that, but you can usually do a find and replace all in Notepad to replace the screwy characters with dashes and pipes. That's the easiest way to do it, at least.
LVL 44

Assisted Solution

by:Adam Brown
Adam Brown earned 1500 total points
ID: 39246271
http://smallbusiness.chron.com/copy-list-files-windows-folder-excel-list-40032.html also has a guide for importing the directory list into Excel. Excel won't do a tree-form though. Would just display all the folders and subfolders.

Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

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.

Join & Write a Comment

The following article is comprised of the pearls we have garnered deploying virtualization solutions since Virtual Server 2005 and subsequent 2008 RTM+ Hyper-V in standalone and clustered environments.
Resolving an irritating Remote Desktop connection that stops your saved credentials from being used.
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…

607 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