Getting a List of Folder Contents

by Allen Wyatt
(last updated March 2, 2019)

8

In putting together a client's file, Boneita needs to create a document that contains a list of everything in a particular folder—all documents and subfolders. She wonders if there is an easy way to get such a list in Word.

Actually, there are a few ways you can accomplish this task, but none of them are native to Word. Here's an easy way that I use all the time:

  1. Make sure your Word document is open.
  2. Click on the Desktop, outside of Word. (This makes sure that your Word document is not active.)
  3. Press Win+E. Windows immediately opens a File Explorer window.
  4. Using File Explorer, navigate to the folder whose contents you want to list.
  5. Press Ctrl+A. Everything in the folder should now be selected.
  6. While holding down the Shift key, right-click on one of the selected files. Windows displays a Context menu. (See Figure 1.)
  7. Figure 1. Context menu displayed when Shift+right-clicking on a group of files.

  8. Choose the Copy as Path option.
  9. Click in the Word document. (This activates the Word document.)
  10. Make sure the insertion point is where you want the list of file contents added.
  11. Press Ctrl+V to paste the contents of the Clipboard.

What you end up with is the list of files—including full path names—in your document. You can then edit the list in any way desired. For instance, you might want to select what was pasted and use Find and Replace to modify the path to each file, as desired.

If you are looking for a more traditional way of getting the list using the command prompt or a macro, you should consider the WordTip located at this URL:

https://tips.net/T1466

There are also third-party solutions available, such as Karen's Directory Printer, which was suggested by more than one subscriber:

https://www.karenware.com/powertools/karens-directory-printer

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (3435) applies to Microsoft Word 2007, 2010, 2013, 2016, 2019, and Word in Office 365.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Formatting Labels

Need your labels to look a certain way? You can save time by formatting them before Word actually creates the sheet of ...

Discover More

Auto Creation of an Acronym List

If you use a lot of acronyms in your documents, you may want a quick way to compile those acronyms and their definitions ...

Discover More

Turning Off Screen Updating

When working with macros, you can often speed up processing by turning off the updating of the screen. Best news is that ...

Discover More

Learning Made Easy! Quickly teach yourself how to format, publish, and share your content using Word 2013. With Step by Step, you set the pace, building and practicing the skills you need, just when you need them! Check out Microsoft Word 2013 Step by Step today!

More WordTips (ribbon)

Converting Many DOC Files to DOCX

Need to convert a bunch of old DOC files to the newer DOCX format? Word doesn't provide the capability to convert a bunch ...

Discover More

Grabbing the MRU List

The MRU (most recently used) list informs you which documents were the last to be opened and edited in Word. You can ...

Discover More

Cannot Open Multiple Word Documents

What are you to do if you try to open a document and Word automatically closes your previous document? Word is not ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 0 + 6?

2019-03-10 16:25:34

Bin Man

Hi Allen
I use Directory Report to get a List of Folder Contents
It can export a directory list directly to MS-Excel
Very customizable


2019-03-05 02:46:00

MW

Ken & Paul:

That's a lot of files . . . if I had the need to post a list even much smaller than that and potentially sort on it, I would be inclined to create the list in Excel.

To do that, I would engage a very powerful freebie called ASAP Utilities that has a built in utility to create such a file list (including subfolders) in an Excel file.

(Happily I don't have a need to reference that quantity of files in a Word document).


2019-03-04 17:15:53

Ken Endacott

I was going to give a warning not to try the macro on very large folders such as C:\Windows or C: but Paul has beaten me to it.

For file properties that can be listed, see:
https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/file-object

DateLastModified is probably more useful than DateCreated in the macro, or maybe you need both.


2019-03-04 09:33:03

Paul Hanson

FYI, if you have 58473 files spread across 14354 sub-directories, Ken's macro will give you a Word document with all the files & sub-folders, but it won't create the table, due to Word's limit. Totally neat trick though!


2019-03-03 13:07:02

Dori

Oh My Goodness! This is a FABULOUS Tip!!! Thank you so very much. You just saved me bushels of time!


2019-03-03 08:41:07

Ken Endacott

The solution shown will give a list of files in a folder but not its sub folders.

The following macro will produce a list of all files in a folder and its sub-folders. The detail given for each file is the path, the name, the size and the creation date. Other file information could be shown by changing the statement flNames(UBound(flNames)) = …

The results are put into a table in a new document. Word’s Sort can then be used to sort into any order.

' ***** This declaration must be at the top of the module *****
Dim flNames() As String
' ************************************************************
Sub FilesInFolderAndSubFolders()
Dim FileSystem As Object
Dim mydir As String
Dim j As Long
mydir = InputBox("Folder path. For example C:\MyFolder")
ReDim flNames(0)
Set FileSystem = CreateObject("Scripting.FileSystemObject")
DoFolder FileSystem.GetFolder(mydir)
Documents.Add
Selection.TypeText "Path" & vbTab & "File name" & vbTab & _
"Size" & vbTab & "Creation Date" & vbCrLf
For j = 1 To UBound(flNames)
Selection.TypeText flNames(j)
Next j
ActiveDocument.Range.Select
Selection.ConvertToTable Separator:=wdSeparateByTabs, AutoFitBehavior:=wdAutoFitFixed
Selection.Tables(1).Style = "Table Grid"
End Sub

Sub DoFolder(Folder)
Dim SubFolder
Dim aFile
Dim nextDoc As Document
For Each SubFolder In Folder.SubFolders
DoFolder SubFolder
Next SubFolder
For Each aFile In Folder.Files
ReDim Preserve flNames(UBound(flNames) + 1)
flNames(UBound(flNames)) = Folder & vbTab & _
aFile.Name & vbTab & aFile.Size & vbTab & aFile.DateCreated & vbCrLf
Next aFile
End Sub


2019-03-02 16:43:00

MW

I too frequently need to list the file contents of a folder in my reports.

I discovered it is fastest to open the target folder in Explorer, organize/display the files you want (e.g. either or without attributes), simply take a screen shot of the file list and paste the graphic into your document.

If the directory path is important to you, just expand the screen shot coverage to include the path shown in the navigation bar too.


2019-03-02 15:15:38

David in Mississippi

"Copy as Path" does not show up on my Windows 10 (latest version) context menu. Any help there?


This Site

Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.