How To List All File Names from A Folder into Excel Using Formula

[@Budha_Excel]

It is very good trick. It is very helpful for me. Many time I need list of file in one sheet. Thanks you very much!

[@Excel10tutorial]

You're most welcome. Glad it helped!

[@AndrewNgAdelaide]

Superb, wonderful to have that. Just wonder whether the CellA! formula can pick up all the files under subfolder and subsubfolders under the folder. Do we need to change the formula?

[@JhihSyun]

It works. And it was what I’ve been looking for. Thanks.

[@Excel10tutorial]

You're most welcome. Please subscribe and be with us.

[@flybywiresimulation]

Thanks a lot, very useful video. I have an issue, when I do it for the first time all work fine, but when i click on the path to change it the formula doesn't work anymore. Could you help me please? I can't understund where is the issue. In your video I can see that you can change easly the path in the cell A1, when I try formula dont work anymore.

[@mtths369]

Hey cool video, thanks this works. Is it possible to also list date and playtime (for music or video files)?

[@Excel10tutorial]

Check if this solves your problem: kzbin.info/www/bejne/mKGopXenl9Z3isU

[@kristidyson443]

Thanks for the video. I thought I was pretty good at excel but I can't figure this out. When you get to minute 2:43, I'm not sure what you mean by adding in the formula. what formula?

[@Excel10tutorial]

=IFERROR(INDEX(List, ROW(A1))," ") This is the formula. Please Check Video Description.

[@arupkonian1064]

If i want to list the folder name only, which command should i put insted of "FILES" Command?

[@santibinelli]

Thanks brotherrrr!!🔥🔥🔥🔥

[@Excel10tutorial]

Any time

[@notanotherone100]

Thank you, this helped me greatly

[@Excel10tutorial]

Glad it helped! Please subscribe and be with us

[@fountainhead73]

Wow! it works really well, Thank you for this useful tip!

[@Excel10tutorial]

You're Most welcome. Please Subscribe and Be with Us.

[@VBAbyMBA]

Neither FSO nor Dir ensures that files are retrieved in the correct sequence. What is the proper way to list files in the correct order, such as: 1.jpg 2.jpg ... 9.jpg 10.jpg 11.jpg? what if, I want to stick to the Dir so that it can be used in MacOS as well?

[@zahidkhalid7928]

very helpful, thankyou

[@Excel10tutorial]

Glad to hear that! Please subscribe and share.

[@kotinaidunarisetti6354]

Thank you😊

[@Excel10tutorial]

You're welcome 😊

[@duniyakordahab]

Thanks

[@Excel10tutorial]

Welcome

[@nitinsingh.2107]

Super Great! Can we also list their file sizes/memory taken?

[@Excel10tutorial]

You can get last modified date, created date etc but not the memory. Here is it: kzbin.info/www/bejne/mKGopXenl9Z3isU

[@AgustinMarcos-j4s]

Thank you !

[@Excel10tutorial]

You're welcome!

[@IvanCortinas_ES]

Supervideo. Thenk you!!!

[@Excel10tutorial]

I'm glad you like it.

[@AsifAli-s7c1y]

Can I apply on share point files and folders?

[@Excel10tutorial]

Try and let us know.😉

[@explorewithmangeshgaykar5288]

@@Excel10tutorial not working on onedrive adresss. and I want only folder name is it possible?

[@Storiesblue]

How about import all filepath from a folder?

[@ronaldibarra572]

Does this work on Mac? Does not seem to be working when I add the formulas you listed - it stays empty.

[@Excel10tutorial]

I didn't check it on mac

[@vishwaschary3635]

its not working for .mp4 formats could you please help in this regard

[@Excel10tutorial]

Try These: kzbin.info/www/bejne/hX-woqOcatmjapY kzbin.info/www/bejne/mKGopXenl9Z3isU kzbin.info/www/bejne/e2aam2eLjal8fNE kzbin.info/www/bejne/gGrToHWkZ8t9f7s

[@AFBlastYT]

how to sort by date

[@mahmoudgouda3103]

ممتاز

[@OrangeMeteor1]

Doesnt work for me