How to Import All File Details From a Folder Into Cells in Excel

In this advanced excel tutorial, we will use an excel built-in feature. If we use this feature, we’ll be able to extract all file names from a folder. We’ll be able to extract all file extensions from that folder. We’ll be able to import Date Created, Date Modified, and also date accessed data from that folder. You can also extract some other essential details along with the file path. You can import all these file details right into your excel worksheet and within seconds.
So, without further delay, let’s follow the procedure to get a list of all files in a worksheet.
Step 1: Under the “Data” tab, click on “New query.”
Step 2: Click on “File” and Then Click on “From Folder”
Step 3: Select the Folder and Click Ok Twice.
Step 4: If you want all the columns “Content, Name, Extension, Date Accessed, Date Modified, Date Created, Attribute, and Folder Path,” click on Load.
Step 5: If you want to remove any column before importing in to excel worksheet, click on edit.
Step 6: Right-click on the column you want to remove and click Remove.
Step 7: When you are done, click save and load from the upper left corner.
Done, you’ve successfully imported All file Details (Content, Name, Extension, Date Accessed, Date Modified, Date Created, Attribute, and Folder Path) inside a table in your worksheet.
This is the easiest way to list all file names in excel using Query in excel.
#Import #FileName #Excel

Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[mohammadsadrzadeh]

How about folders and subfolders and files in a master folder?

[RossiRascal]

Im getting a runtime error 1004
Apllication-defined or object-defined error

[danastriciptaningrum]

Hello sir, there is no new query button on my excel, however when i try your old tutorial, there is no developer tab either. What can i do?

[smilequotient]

THERE IS NO OPTION AS NEW QUERY IN MY EXCEL. PLS HELP

[thomasvtpra]

Showing error occurred, with options "send a frown". What to do??