List Files in ANY Folder (Without VBA!) | Filter & Organize Your Files in Excel

Рет қаралды 11,976

Ай бұрын

Tired of manually listing files? This video shows you how to list ALL files from any folder in Excel, WITHOUT VBA! Plus, filter and categorize your files for easy organization. Free Download Included! #excelfiles #filelistingexcel #organizefiles #exceltips #excelproductivityhacks
💕Follow Us On💕
🌎 WhatsApp Channel 👉 whatsapp.com/channel/0029VaZe...
🌎 Facebook 👉 / xcelsive
🌎 KZfaq 👉 / @xcelsiveenglish
🌎 Rumble 👉 rumble.com/user/Excelsive
🔗Links🔗
Practice File 👉 tinyurl.com/55znynzh
Effortless Excel Navigation: Create an Interactive Index for Multiple Sheets | 3 Methods 👉 • Effortless Excel Navig...
How To Use The Sequence Formula In Excel : 3 Practical Examples 👉 • How To Use The Sequenc...
🔥Keywords🔥
excel list files, list files in folder excel, excel file list without vba, organize files in excel, filter files excel, excel tips and tricks, free excel template, files in folder, list files in a folder, loop through files in a folder, vba filesystemobject loop through files in folder, delete files in a folder, loop through all files in a folder, vba loop through files in folder dir, generate list of files from any folder in excel, how to rename all files in folder, excel vba loop through all files in a folder, excel macro loop through all files in a folder, excel vba loop through all files in a folder and open
🔥Tags🔥
excel, file list, folder, organize, filter, data, tips, tricks, template, download
🙋‍♂️Credits
Disclaimer: The logos, names, addresses, phone numbers, and any other personal or proprietary information depicted or mentioned in this content are used for illustrative purposes only. Any resemblance to actual persons, living or dead, businesses, organizations, or events is purely coincidental. The inclusion of such information does not imply endorsement or affiliation with any entity. All trademarks, logos, and brands appearing in this content are the property of their respective owners. We do not claim ownership of any third-party content referenced herein. If you believe that any information included in this content infringes upon your rights or is inaccurate, please contact us immediately for prompt correction or removal.

Пікірлер: 14

@alexdickey9542 28 күн бұрын

Excellent video, but raises some questions about your formula. FILES() is not an Excel function, so where does it come from? Also dies that mean NameManager can run code from other languages? .

@brad3854 Ай бұрын

Excellent, thank you. There is one formula issue. You probably missed this because it is not really obvious. When you turn the list into a table, your first data row on Sheet1 is now row #2. Using "ROW()" in cell B2 references the current row and therefore returns number 2 to index into the file list. If you place the entire formula from B2 into E1 on Sheet1, you will see the missing filename. A simple fix is to replace "ROW()" with "ROW(A1)" in cell B2 AFTER the table is created. That way the correct index number will be used.

@Luciano_mp Ай бұрын

Very useful. Thank you!

@XcelsiveEnglish Ай бұрын

Glad to hear that!

@vinothkumarmanoharan2317 Ай бұрын

Awesome bro keep rocking

@XcelsiveEnglish Ай бұрын

Thank you so much 😀

@Ochiha_ita Ай бұрын

Fantastic! I think it would even become better if you make them become links to the actual files

@XcelsiveEnglish Ай бұрын

simple way would be to add folder location with the file name and extension and use hyperlink with it. Wait for my next video and you can hyperlink those easily since it shows files in sub folders as well and has the folder location too. Folder location coupled with file name with extension when used with HYPERLINK formula does the trick.

@gianlucaiozza3439 Ай бұрын

Very interesting. What about managing also subfolder ?

@XcelsiveEnglish Ай бұрын

I thought so too. And that's why its coming in the next video this friday!!

@SteinarBleken Ай бұрын

Can we do similar and get list og folders?

@XcelsiveEnglish Ай бұрын

We can. Wait for the next video, it covers file list in ALL the subfolders & folder list too!

@DieTabbi 29 күн бұрын

Would be nice when you explained why first are only 300 entries could used, second I wont drag down the cells to I dont know 600. List all files mean for me: klick and list it.

@XcelsiveEnglish Ай бұрын

🔗Links🔗 Practice File 👉 tinyurl.com/55znynzh Effortless Excel Navigation: Create an Interactive Index for Multiple Sheets | 3 Methods 👉 kzfaq.info/get/bejne/Z5x8rNJ50LGwgaM.html How To Use The Sequence Formula In Excel : 3 Practical Examples 👉 kzfaq.info/get/bejne/d8eTadarl8iadKs.html