How to Create an Excel File List from a Folder of Files

In this video, we'll show you how to quickly create an Excel file list from a folder of files. This is a great way to keep track of all your important documents, and it's easy to do!

Table of Contents:

00:00 - Introduction
00:09 - Objective
00:31 - How To
01:08 - Editing

[DanFlavel]

Thank you! Saved me countless hours lol

[roberth.]

Excellent. Concise and informative. Much appreciated.

[peterkapitola]

This is incredibly useful, thanks! For some reason, searching the archive on our network drive is incredibly slow, even though it's supposed to be indexed. Now we can create a separate index of the files and searching is much faster. And it was very easy to do. I've used Excel for years but I didn't know about this function. So thanks again.

[cashnasheri]

What a great and efficient video - bravo! I hope other people on YouTube take note of your video, as it's one of the best instructional videos I've seen in quite a while. Thank you!

[catsmith]

Hi Jeff, Love this, thanks so much! I've been PQ-ing files from folders for a few years and never once considered how easy it would be to create this list. So here's a thought -- I removed all columns except the file path and the file name, moved the path in front of the file name, merged the columns, and close-and-loaded the list to a table in my workbook. Then I used Excel's Hyperlink function to create a hotlink for each of the files (just create the first one and copy down). Thanks again for great tip!

[radiumdude]

Nice... except it doesn't work with Excel for Mac.

[denizselcuk]

hi, thanks for the helpful video! I appreciate. Is there a way that the files in the list would be hyperlinked to the source in the folder? Many thanks!