Power Query to get a list of folders (not files) in a location?

		Microsoft Office Forums > Microsoft Excel > Excel
Power Query to get a list of folders (not files) in a location?

02-22-2023, 12:00 PM

p45cal

Windows 10 Power Query to get a list of folders (not files) in a location?

Office 2019

Expert

Join Date: Apr 2014

Posts: 956

In the attached cell A1 is a named range FPath. Adjust it to your path, refresh the table below. Empty folders included.
Instead of using a named range, the path could be hard-coded into the query.

Stolen from Power Query How to list folder names only NOT files | Page 2 | MrExcel Message Board

Attached Files

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel power query help	ganesang	Excel Programming	0	09-20-2021 01:50 AM
Browse, search and copy files from one location to another based on the list given in excel sheet us	nmkhan3010	Excel Programming	2	09-07-2020 10:27 AM
Do I need a power query for this one?	shabbaranks	Excel	5	04-10-2019 03:29 AM
Query and Power Query not working Excel 2016	bl10	Excel	0	07-22-2016 06:25 PM
list folders and files using .vbs file	josianne	Excel Programming	3	08-18-2014 03:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:08 PM.