List of filenames from folder into Excel

Рет қаралды 26,563

3 жыл бұрын

Copy Folder Path into excel. Add "\*" onto end of folder path. Make a named range using the formula =FILES() and then use the named range to get a list of file names.
---------------------------------------------------------------------------------
#exceltips #exceltutorials
SUBSCRIBE: goo.gl/c46YPs
Microsoft Office 365, 2016, Office Insider, Version 2012
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
- Copy list of filenames from folder into Excel (Windows) • Copy list of filenames...
- List of filenames from folder and subfolders into Excel • List of filenames from...
- List of filenames from folder into Excel (Windows) • List of filenames from...

Пікірлер: 22

@RasaCartaMagna 11 ай бұрын

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

@andriikulishov3371 2 жыл бұрын

concise and simply brilliant explanation! thanks!

@raymonddavid7661 2 жыл бұрын

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

@DjWebbsite 2 жыл бұрын

Wow, really nicely done! Thanks so much.

@SwahiliSpicE 4 ай бұрын

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?

@mohammadj.shamim9342 2 жыл бұрын

Great work. Beautiful automation

@gregbernard7861 Жыл бұрын

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

@moesadr3342 3 жыл бұрын

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?)

@truongnguyenchuyenngu Жыл бұрын

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

@hemanthvishwas4058 2 жыл бұрын

Thank you so much Karina

@lucienne4263 2 жыл бұрын

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

@sukhmindersingh8158 2 жыл бұрын

Thank you very much..

@larshansen9969 2 жыл бұрын

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.

@matthewanacleto7885 Жыл бұрын

can you get it to do subfolders?

@doma3554 2 жыл бұрын

Super cool.

@kartiksoni4702 Жыл бұрын

What if i need copy sub folders file name

@steinidaraasen 2 жыл бұрын

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

@ndhuy92 4 ай бұрын

I have the same issue. pls help

@KhaledAmeen 2 жыл бұрын

It only returns the first file name why?

@karinaadcock 2 жыл бұрын

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 2 жыл бұрын

@@karinaadcock Could you send me an example

@maheshsajjan8841 2 жыл бұрын

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