How to Get the List of File Names in a Folder in Excel (without VBA)

Awesome trick. Thanks a ton. It worked like a charm

Sir, you giving complicated way to copy instead just use data transfer from folder itself and more easy way.

Sumitji, how can we prepare a seperate list of all songs in excel from a pen drive or CD. Kindly explain.

Excellent Video to enhance our understanding. However why should we need to get the seperate list of file names , when they are already in a folder?

well explained

great video, thanks. it is possible to get names of folders (not files)?

wow so genius

Thanks

It's Showing BLOCKED error how to resolve it?

VERY NICE...WILL THIS AUTO-UPDATE ON ADDITIONS OF FILES IN THE FOLDER..???

Not works for Sub folders

Not working😢

sir ye to alphabatical sequence se import kr rha hai agr datemodified sequance se imort krne ho to kese krende?

Used this to extract 132 files names. This video saved me an hour.

Thank you so much for the interesting tutorial. Earlier I was manually copy pasting the file names from the folder to excel sheet. This video is super useful. Just one question. Is it possible to create a link on all the file names in the list so that by just clicking on the file name in the list one can open the file in the folder? Please let me know. Thank you. Best regards.

Wonderful video I loved it

Needed a tip on calculate (similar name) number of pdf files in a folder in excel

For example :
I have a data of pdf files with names like
01, 01 xyz, 01abc, 02, 02abc ,02 qwer, 02llig etc

So here, I want to note down the number of files having 01 and 02 and so on in excel.
Copy path trick will just give names in plain text but won't give number of files with similar name automatically.

Can anyone help me with it?

Hey man, great video it will help me a lot in my work,
Quick note, you can get the folder path by right click on it and choose properties, and it will show you the folder path
Thanks you for your video 🙏🏻

genius

Select all of the files in folder, hold shift+ alt and right click, select copy path. paste path into excel. no formulas takes seconds :)

Thanks for Simple Video

Clear and precise. Thanks.

Hi dear, this is kulwant;
after you have copied the entire data to excel
just click on column A1 and copy the starting string till last backslash "\"
press command H
paste the string in "find what"
leave the "Replace with"
now Hit:
find next
Replace
if happy then
find next
Replace all
'WOW' no delimitations and hight gimmicks
.................... Kulwant uncle

any problem write back

thank youuuuuuuuuuuuuuuuu very much

this is a top video, can you do it with google sheets?

you are a Genius.. many thanks for this precious video

does it works on pdf files too ?

does this not work for multiple folders

Big thanks, just one for question if we have subfolder? please advise

Another way, select all files in folder (Cntr+A) and hold shift+alt+right click and copy as path and select excel sheet and then paste. Thats all, all files name will bring to sheet

So helpful thanks! How can this be done to list folders instead of files?

It's really Trump Excel

how would one make this work with files stored on sharepoint onedrive (not local)

Useful video, i need to done this one in macro can it is possbile. Example: every day in drives file will keep on chages on day to day basics, so i want to do a macro can you help me out with that one

Great Video. Any chance you can show how we can create the link to actual file names which are generated? That would be a great help. Thanks

Such great advise and to the point! Thank you so much for sharing your expertise. This will help me so much of my time from now. Greatly appreciated :)

Hello again. I found this video so Helpful! I'd like to add another (old) method of getting a list of Folders AND files in a given directory. For those who'd like to venture into the Windows "Command Prompt". This method will create a TEXT file in the directory of your choosing - from where, you can Open the Text File in Excel, and (have your full listing, to be able to manipulate sid listing as you wish in Excel.): 1. Use Widows File Explorer to navigate to the directory containing the folder (and/or group of folders and files) you want to appear in your listing. 2. In the Address Bar in File Explorer -type "cmd" and press Enter. (this opens the Command Prompt (old DOS) window at the "prompt" in the folder you selected. 3. Type: dir /A:D /B /S> FoldersAndFilesList.txt and press Enter. (This command/action, generates a complete listing 'folder structure' into the txt file - as named above (you can choose to name the file as you wish, of course.) 4. Type "Exit" in the Command Prompt Widow - to close the (DOS)/Windows Command Prompt pop-up. 5. Use File Explorer and look in your selected Folder for the file you just created [FoldersAndFilesList.txt]. You can open this with Word, any Text File Editor, or directly with Excel. <This is the complete listing of your Folders and Files structure in the Directory. [ CAREFUL: This can take a while if you have a very large directory with many sub-folders and files contained therein.] * Note: I did not go into any explanations of what the Command/Switches mean... i.e., the "dir", the /A /B /S etc.. it would take a longer conversation to those no familiar with the (old) DOS commands and it use. // IF you are curious about DOS & the Command Prompt "commands" and their use: You can type "HELP" at the Command prompt window and review for your self. * WARNING: Don't mess with commands if you're not sure of what you're doing here. Enter at your own risk. or Consult with a person who knows these commands and "Old-School" DOS.

Brilliant! This is the most - straight-forward method of listing files in a folder and the biggest time-saver. If you ever get a chance to update (add to this method), I would love to see this expanded to help create a "link" to the file itself in the workbook. So, the resulting workbook can be used as a 'true IDEX of the folder contents, and when a user opens the workbook, s/he can readily "open" a give file by just clicking on the 'link' within the Excel file.) /I've done 'this" many times over my year, - using different methods/tools; but Using the formulas/method in this Video, really saves a lot of work. Best Regards. and a big THANK YOU for posting this.

Hello sir. Your tutorial is amazing. Sir I have a doubt in excel. Please tell me how to remove duplicates words in same cell in same line.

example in cell A1 has some words
" MAA400 MAA400 NEFT TRANSFER".

here the words MAA400 are repeated twice . So I want remove duplicates words in same line in same cell.

This is very useful, many thanks to you. I could not get any files when I use it with OneDrive!

Awesome... is it possible to get the file creation date

Really helpful

If I have different folders and files. How to list in one excel file? Pls advise. Thank you

Please also guide to get file name list with specific file format

why is my finding N/A

Thank you so mutch, Sir.