Excel can turn a folder listing into a custom, clickable catalog: use Power Query to bring in file details, shape the list into a table, then add links that open the files. It is useful when you want your own categories and curated lists—not necessarily when you just need to search for a file quickly.
What Excel can—and cannot—do as a file catalog
Power Query’s Folder connector creates a listing of file information from a chosen folder and its subfolders. You can filter and organize those rows without importing or combining the contents of the files. The result is a navigable index, not a new filing system: the files remain where they are, and the catalog does not automatically classify them for you. Microsoft’s Folder connector documentation describes the listing and its scope.
As an Amazon Associate I earn from qualifying purchases.
That distinction matters if a folder contains documents, images, spreadsheets, and other formats. Cataloging their names and paths is different from using Power Query’s Combine operation to process file contents. Microsoft warns that Combine applies the same process to files in the folder and its subfolders, so compatible formats and structures matter. If you only want an inventory, do not choose Combine; if you do need to combine contents, filter by Extension or Folder Path to limit the files being processed. Microsoft’s folder import guide explains the filtering and combine workflow.
Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Scan for outdated or missing drivers - takes under a minute3Repair Windows errors before they cause bigger problemsCan Excel make a list of files in a folder?
Yes. In supported Windows editions of Excel, the Power Query folder import is a practical way to build the starting list. Start with a representative folder rather than your entire drive: the connector can include subfolders, so a broad root can produce a large, noisy catalog.
#1 Best Overall
- The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
- ABIS BOOK
- Check your Excel edition. Microsoft lists local-folder Power Query support in Excel 2016 or later standalone Windows editions and Microsoft 365. Mac support is documented separately, so do not assume the Windows ribbon or feature set will be identical. See Microsoft’s Excel version and Power Query support page.
- Choose a useful root folder. Pick a folder whose contents you actually want to browse, such as a project archive or a documents directory. Include subfolders only if they belong in the catalog.
- Import the folder listing. In Excel for Windows, use Data > Get Data > From File > From Folder, select the folder, then choose Transform Data to inspect the rows. Ribbon wording can vary by Excel version.
- Shape the list before loading. Keep navigation and maintenance fields such as Name, Extension, Date modified, and Folder Path when they are present. Filter out irrelevant extensions or folder paths. The exact columns returned can vary with the connector output.
- Load the result as a worksheet table. Use Excel filters to find entries by name, extension, or other available fields. Add a category or notes column only where it helps answer a real retrieval question; those labels are your own organization, not automatic Power Query classification.
How do I link to files from Excel?
Add a link column so a row can open its corresponding file. Microsoft documents the syntax as =HYPERLINK(link_location, [friendly_name]); the friendly name can be something concise such as “Open file.” Microsoft Support states: “When you click the cell that contains the HYPERLINK function, Excel opens the linked item.” See Work with links in Excel.
If your table has Folder Path and Name columns, you can construct the destination from those fields. For example, in a table with those exact column names, a formula may look like =HYPERLINK([@[Folder Path]]&[@Name],"Open file"). This assumes the folder path already ends with the required separator and that your Excel locale accepts commas and this structured-reference syntax. Check a resulting destination and test the link; formula separators and table syntax can differ by locale or table setup.
Will the links keep working if files move?
Only if the stored destinations still resolve. Excel uses the active workbook’s location as the default base for hyperlink paths that do not specify a full location. That makes the relationship between the workbook and cataloged files important: a workbook and file tree kept in stable relative locations may preserve assumptions that an absolute path tied to one drive or computer will not. Moving or renaming either can break links. Microsoft explains relative-link behavior in its Excel link documentation.
After moving or reorganizing folders, test several links, including files in different subfolders. Refresh the Power Query listing after files are added or moved, then verify that the displayed rows and links still point where you expect. A refresh updates the query’s listing; it should not be treated as a guarantee that every existing hyperlink remains valid.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Excel catalog or Windows Search?
Windows Search may be enough if you mainly need to locate files by their names, properties, or indexed contents. Microsoft documents that Windows Search indexes file properties and content. Excel is more suited to a hand-shaped catalog of known files, with custom categories, notes, filters, and a deliberate list of clickable destinations. These are different approaches rather than measured performance alternatives.
| Need | Excel catalog | Windows Search |
|---|---|---|
| Custom categories and notes | You can add and maintain your own worksheet columns. | Microsoft’s indexing overview describes indexing properties and content, not a custom Excel-style catalog. |
| Curated clickable file list | Rows can include hyperlinks to file locations. | Search is an index for finding items, rather than a worksheet curated by you. |
| Setup and upkeep | You choose a folder, shape the query, and refresh the listing when needed. | Windows Search uses an index; the cited overview describes its indexing process. |
| Moving between folders or machines | Links can depend on absolute paths or on the workbook’s location for relative paths; reorganizing requires checking them. | The cited documentation describes Windows indexing, not a portable workbook of links. |
| Searching file contents | The folder listing catalogs file information; it does not by itself search document contents. | Windows Search indexes file properties and content, according to Microsoft’s indexing overview. |
Use Excel when the problem is “I want a navigable, organized list of these files.” Use Windows Search when the problem is “I want to find a file by its name or indexed content” and you do not need workbook-specific categories or curation.
Quick Recap
Rank #4
What to check before relying on the catalog
- Scope: confirm the chosen root and subfolders do not include unrelated material.
- Fields and filters: make sure the table retains enough path and filename information to identify each file, and that excluded extensions or folders are intentional.
- Links: open a sample from each relevant folder level, and repeat the check after moving the workbook or file tree.
- Refresh: refresh the query when the underlying folder changes, then inspect the updated rows and test representative links.
- Purpose: do not use Combine merely to create a file inventory; combining contents is a separate operation with compatibility considerations.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
