In this article, we will see how to get a list of files in a folder in Excel. To keep track of the file size, file type, and the last modified date, we will use Excel to see the files and folders details in Windows by importing the details of all the files and folders in Microsoft Excel.
We have many files and folders in our Windows PC and we can often delete or add more files and folders. There may be some folders and files that are very important to us and anyone can edit them without our notice. But, we can not see each folder and file to know that each person was edited. If this was a modification to a file or folder, then we can sort them using ‘Last Modified’ and we can find out which revisions were recently done.
But, what would happen if some files and folders were removed from that directory? and we will not really be in a position to track deleted files. However, you can use excel to see directory files and folder details that will be useful to know the list of at least files and folders.
How to Import and get a list of filenames into an Excel sheet
If you use Microsoft Excel to import all the details of files and folders in Excel, it will help you keep track of the last modified date and time, file types, files list, size of files and many others regularly Will do To do this, follow these simple steps.
Go to the directory or folder on the Windows File Explorer that you want to keep track of. Here, I want to keep track of files and folders of document files. Copy the path to that directory.
Now, open any web browser you like and paste the path copied into the browser’s address bar (the path of the folder that you just copied in the previous step). I used Google Chrome here Just prefill the URL by file: /// and content will be shown on web page.
To save this web page as an offline copy, press CTRL + S or right-click on the web page and select “Save Page as”. Select the destination, give it a name and save the webpage.
Now, go to the place through Windows Explorer where you saved the offline webpage and copied the path. Open Excel Sheet and tap on the Data tab and click from the web.
But first, copy file path to do that hold the shift key and right-click on the file. here you will get an option “Copy as Path” click on it.
This window opens and pastes the save file path here, After paste that link don’t forget to remove ” then click on “ok” button. It will load all the contents of the webpage.
Once done with these steps, you see that all the files and folders details are imported in your Excel Sheet.
I Hope you like this post please share this post on facebook and do comment if you have any problem.