Did you ever need to export the entire directory tree from a particular folder? Did you need to get a text or Excel document that lists all the files and folders inside a specific folder from your computer into a hierarchical structure? We had this need when we were trying to create a document that was supposed to be a summary of all the Word documents and Excel spreadsheets we had stored inside a folder. It was at that time that we asked ourselves a couple of questions. Can you automatically export a folder’s structure to Excel? Is there a DOS tree command that outputs to a file? Can you print a directory tree into an Excel sheet or as a text file? If you want to find out how to export a folder tree, read on:
NOTE: We have two methods that you can use to export a folder’s tree. The first one is based on using the Command Prompt and generates the directory tree as a text file. The second relies on an executable file that we created with PowerShell and outputs the folder tree as an Excel file and as a CSV file.
1. Export a folder’s structure to a text file, using the “Tree” command in Command Prompt
The first thing is to open File Explorer and navigate to the folder for which you want to export the directory tree. In our case, that would be “D:Games.”
Type cmd in File Explorer’s address bar and press Enter to open the Command Prompt directly at the folder you are interested in.
A Command Prompt instance is opened, pointing to your folder. In our case, the Command Prompt was opened using the “D:Games” folder. To export the folder’s structure, run this command: tree /a /f > output.doc.
TIP: If you don’t want the directory tree to include files (in other words, make the tree include only folders), skip the /f parameter from the command (tree /a > output.doc).
Output.doc is the document file in which the entire directory tree is going to be saved. You can use any name for it, and you can specify any file type, as long as it has a text file type. We prefer using Microsoft Word .doc files, but you could use any other text file. For instance, you can choose to output the directory tree to a simple .txt file that’s editable with Notepad. Depending on how many folders and files are stored inside your folder, running this command can take a moment or two.
Now you can close the Command Prompt, as you don’t need it anymore. Go back to File Explorer and navigate to the folder for which you wanted to export the directory tree. Inside, you should find the new text file with the name you specified in the tree command. In our case, this file is called output.doc.
Open the output file and the entire directory tree is listed inside. It looks good, doesn’t it?
NOTE: If you want to export the directory tree of a folder that contains system files or folders, you must launch Command Prompt with administrative rights and then navigate to your folder from the Command Prompt itself.
2. Export a folder’s structure to an Excel or CSV file, using our FolderTree tool (based on PowerShell)
Another easy way to export the structure of a folder in Windows 10 is to use a tool that we created for you, called FolderTree. Download it using this link or the one at the end of this section. Save it somewhere on your Windows 10 PC. Then, move or copy it to the folder for which you want to get the tree structure. In that folder, double-click or double-tap on the FolderTree executable.
When you launch FolderTree for the first time, the SmartScreen filter warns you that it is an unrecognized app. That’s because there are not that many people downloading and using it. Take our word that it’s safe and does not harm your PC. It is nothing more than a PowerShell script inside an executable file and a simple user interface. To be able to use this tool, click or tap on “More info” and then choose to “Run anyway.”
When FolderTree opens, you should see a small window like the one below. To get the directory tree of the current folder, push the “Get folder tree to Excel” button.
The tool then outputs two files: FolderTree.xlsx and FolderTree.csv. Both contain the tree list of folders and files inside your current directory.
Furthermore, both files should have two columns: Directory and Name. Directory tells you the folder, and Name tells you the files in that folder.
Now you can go ahead and edit the Excel or CSV file with your folder tree as you want. If you encounter any issues with our tool, let us know in the comments section below.
Why did you want to know how to export the directory tree of a folder?
Exporting the entire directory tree structure to a text file is quickly done in Windows. All you need is the Command Prompt and the right command. Exporting a directory tree to Excel is also easy if you use our FolderTree tool. Before closing this article, tell us why you wanted to create a file folder tree? Was it because you wanted to make a list of your music files? Was it for a work-related task? Comment below and let’s discuss.