List of filenames from folder into Excel

[@RasaCartaMagna]

This is legitimately the best Excel tutorial I have ever seen. Thank you.

[@andriikulishov3371]

concise and simply brilliant explanation! thanks!

[@gregbernard7861]

This is great. I was using VBA. Super cool.

[@mohammadj.shamim9342]

Great work. Beautiful automation

[@SwahiliSpicE]

Hi, this is an amazing tutorial and potentially a life saver for a project I have at work at the moment. Just one problem, I have a folder with about zip folders and I need the file names of the files inside the zip folders. How can I do this?

[@DjWebbsite]

Wow, really nicely done! Thanks so much.

[@hemanthvishwas4058]

Thank you so much Karina

[@truongnguyenchuyenngu]

Thanks for your helpful tutorial, but is there any way to obtain file names from subfolder as well?

[@raymonddavid7661]

Awesome lesson, and very useful for my project. Is there a way to also include sub folders and their respective files?

[@steinidaraasen]

Do you have a mac version for this. done it step by step but get #name? error

[@ndhuy92]

I have the same issue. pls help

[@deprive-999x]

can you get it to do subfolders?

[@sukhmindersingh22]

Thank you very much..

[@moesadr3342]

Is there any way that the folder name/path can be changed whenever needed? Like a drop down box or data entry cell to introduce other folder's name/path ( of course one folder at a time?)

[@larshansen9969]

Very nice trick. It works as intended until I save (macro enabled) and reopen the book. After pasting a new path all I get is a #NAME? in the filename list. What am I missing ? Excel 365 version 2102.

[@lucienne4263]

very usefull, but I'm working with a dutch version of excel and can't find this formula. I do have office. I've checked the convert list on www but I can't find this Files formula. Anyone knows the dutch name? thanks

[@kartiksoni4702]

What if i need copy sub folders file name

[@KhaledAmeen]

It only returns the first file name why?

[@karinaadcock]

Some versions of Excel have dynamic arrays which allow formula results to spill across multiple cells. If you do not have this you will have to use the index formula to get all of the files.

[@KhaledAmeen]

@@karinaadcock Could you send me an example

[@maheshsajjan8841]

@@karinaadcock same problem with me also .. cud u please help

[@doma3554]

Super cool.