How to List All Files and Sub-Directories of a Folder in Excel 365?
Tags: kutoolsexceltutorial, listallfilesofafolde, kutools
Published: 2020-10-31 12:18:16

---
title: How to List All Files and Sub-Directories of a Folder in Excel 365?
published: true
date: 2020-10-31 12:10:03 UTC
tags: KutoolsExcelTutorial,ListAllFilesofaFolde,Kutools
canonical_url: https://geekexcel.com/how-to-list-all-files-and-sub-directories-of-a-folder-in-excel-365/
---

In this guide, we are going to see how to **List All Files and Sub-Directories of a Folder in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## List All File Names from Folders:

To list all file names from folders or directories in the worksheet, follow the below steps.

- Primarily, you need to [open the workbook](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) that you want to create a list of files from the specific folder in a new sheet.
- Go to the **Kutools Plus Tab, select** the **Import**  **& Export** option, **choose** the **Filename List** option from the menu.

[![Choose the Filename List option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-41.png)](https://geekexcel.com/?attachment_id=16601#main)<figcaption id="caption-attachment-16601">Choose the Filename List option</figcaption>

- Then, it will display the **Filename List Dialog Box**.
- **List files from this folder –** You need to **select the directory** in which you want to list the files using the file button.
- If you want to list the files in subfolders or list hidden files, you need to **check** the **Include files in subdirectories** or **Include hidden files and folders** option.
- **Files type –** You need to **specify the file type** that you want to list.
- **File size unit –** Select any one of the file size units using the drop-down list.
- You can also **check** the **Create hyperlinks** option. It will create hyperlinks for each listed file.

![Filename List Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Filename-List-Dialog-Box.png)<figcaption id="caption-attachment-16602">Filename List Dialog Box</figcaption>

- After completing the above steps, **click** the **OK** button to get the result.
- Now, all the files have been displayed with some attributes in a new worksheet as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-50.png)<figcaption id="caption-attachment-16603">Output</figcaption>

## Conclusion:

In the above guide, we assisted you to understand the instructions to **List All Files and Sub-Directories of a Folder in Excel Office 365** using **Kutools. ** Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [Copy Page Setup from One Worksheet to Others in Excel Office 365!!](https://geekexcel.com/copy-page-setup-from-one-worksheet-to-others-in-excel-office-365/)
- [How to Open Containing Folder or Directory of Current Workbook in Excel?](https://geekexcel.com/how-to-open-containing-folder-or-directory-of-current-workbook-in-excel/)