List of filenames from folder into Excel

Подписаться 44 тыс.

Просмотров 26 тыс.

50% 1

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...

Наука

Опубликовано:

15 дек 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 22

@RasaCartaMagna 10 месяцев назад

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

@andriikulishov3371 2 года назад

concise and simply brilliant explanation! thanks!

@DjWebbsite 2 года назад

Wow, really nicely done! Thanks so much.

@gregbernard7861 Год назад

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

@mohammadj.shamim9342 2 года назад

Great work. Beautiful automation

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

@hemanthvishwas4058 2 года назад

Thank you so much Karina

@sukhmindersingh8158 2 года назад

Thank you very much..

@raymonddavid7661 Год назад

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

@doma3554 2 года назад

Super cool.

@truongnguyenchuyenngu Год назад

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

@moesadr3342 2 года назад

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

@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

@matthewanacleto7885 Год назад

can you get it to do subfolders?

@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.

@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