Windows folder contents to excel

Excel is extremely useful in working with lists, and in the modern world, a common listing requirement is the list of files and folders within a folder. So whether you are just indexing a folder for backup purposes, or you need the names of files in the folder to find missing items, Excel can easily do it.

Below a method of how to export file names from a folder to excel. Although there are some VBA and other methods, the latest versions of Excel have made it exceptionally easy. To understand PowerQuery better, have a look at the online PowerQuery course but the simple steps are Using Excel :.

When you click OK, it will show you the list of files in the folder. Any thoughts? This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.

I have the same question Report abuse. Details required :. Cancel Submit. Jeeped MVP. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. Ronnie Vernon. In a previous post we showed how to export a list of filenames from a folder into Excel. Here we are going to use a small trick in PowerQuery to export folder and subfolder list to Excel. As shown in the post of how to list filenames in Excel , to get to import the file names into Excel you need to go to.

You will then be able to Browse to the folder. Depending on your version, you may only be able to click on a folder that has no other folders in it the more recent versions seems to have addressed this.