How To List Files From A Folder In Excel Automatically (No VBA Needed!)

Опубликовано: 13 Май 2026
на канале: Anser's Excel Academy
2,931
26

List Files from a Folder in Excel Automatically 📂

In this video, I’ll show you how to list all the files from a folder into Excel with just a few clicks! No need to type or copy anything. We’ll use Power Query to get file names and even make them clickable.

This trick is great for organizing your work folders or project files. Whenever you add or delete a file, Excel updates the list by itself! Easy, useful, and no coding needed.

🔔 𝐃𝐨𝐧'𝐭 𝐟𝐨𝐫𝐠𝐞𝐭 𝐭𝐨 𝐬𝐮𝐛𝐬𝐜𝐫𝐢𝐛𝐞 𝐭𝐨 𝐦𝐲 𝐜𝐡𝐚𝐧𝐧𝐞𝐥 𝐟𝐨𝐫 𝐦𝐨𝐫𝐞 𝐮𝐩𝐝𝐚𝐭𝐞𝐬.
   / @excelwithanser  

🔗 Stay Connected With Me: Website: https://excelwithanser.com/

🎬Suggested videos for you:

▶️    • How To Automatically Move Data In Excel Ba...  
▶️    • How To Import Data from Multiple Excel Fil...  
▶️    • Advanced Filters in Excel | How to Filter ...  
▶️    • How to Combine Excel Files from a Folder D...  
▶️    • Prevent Duplicate Entries in Excel with 1 ...  




















How To List Files From A Folder In Excel Automatically, No VBA Needed, Power Query Folder File List, List Files In Excel Without VBA, Create Clickable File Names In Excel, Excel Folder File Extract, Auto Update File Names In Excel, Excel File Tracker, Excel Get File List, Power Query File Names, Excel Without Coding, Dynamic File List Excel, Excel File Management, Get File Metadata In Excel, Create File List Table Excel

#exceltutorial #powerquery #filelistinexcel #autofiletracker #exceltips #hyperlinkinexcel #getandtransform #excelforbeginners #exceldynamiclist #listfilesfromfolder #nofilecopying #excelautomation #exceltutorial #powerquery #filelistinexcel