The No-Code Way to List All Files Using Power Query Excel Tip

0 views Jun 29, 2025

In this Excel Tutorial, I show you how to generate a list of files in a folder without the need for VBA code or an Excel Macro. I use Power Query to connect to a folder and create a list of files from the folder location. If you keep this workbook saved and refresh the connection to Power Query, your list of names will continue to update as files are added or removed. Set this up once and you're good to go. Excel Tips Playlist https://www.youtube.com/playlist?list=PLEu0c1pZOWXEg8N8SuHfQo0zyDhUSqp3Q Subscribe and watch more videos that help you use Microsoft Excel. / @howtoexcelatexcel Be Social & Let's Connect ++Website http://www.howtoexcelatexcel.com ++Twitter / howtoexcelatex.


View Video Transcript