🔥Create Folders AND Subfolders in File Explorer using Excel 🗂️

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

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

50% 1

In my last video, I showed you how to use #Excel and a simple batch file to create multiple folders in File Explorer. In this video, we are going to extend that knowledge and see how to create not only folders, but also subfolders in File Explorer.
This process involves copying and pasting our folder and subfolder names into the Notepad app and saving it as a .bat (batch) file. When we run this file, the folders and subfolders will automatically be created.
*********************************************
🔗LINKS to related videos
🗂️Create Multiple Folders in File Explorer using Microsoft Excel
• ➡️ Create Multiple Fol...
⭐️ NEW Excel Functions: TEXTBEFORE and TEXTAFTER 💪🏻
• ⭐️ NEW Excel Functions...
🪣GROUP Excel Data in to Custom Buckets with XLOOKUP ✨
• 🪣GROUP Excel Data in t...
************************************************
🤝Let's CONNECT on social:
➡️TikTok: / cellmates_
➡️Instagram: / cellmatestr. .
➡️LinkedIn: / deborahas. .
➡️Twitter: / cellmates_
➡️Facebook: / cellmates

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

2 окт 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@cellmatestraining Год назад

Watch Part 1 of this video here ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ByUwTkXSiHw.html

@VeronicaSanchez-qt1zf 2 месяца назад

Great video. to make it even quicker you can separate each part of the name into multiple columns, to allow you to drag and copy, i.e. the main folder name then concatenate all the fields in a different cell. The concatenated cell is the one you select and copy into notepad. Hate retyping when I can copy.

@MentorMinutes 4 месяца назад

THANK YOU SO MUCH FOR SUCH A USEFULL TIPS MY DAILY WORK

@seanwilliams2273 Год назад

I am going through your MS Project training and I love it. Its absolutely wonderful.

@damodarbangalore7003 Год назад

Thanks a lot Madam

@AndrewNgAdelaide 6 месяцев назад

can you suggest a slightly unique way to batch a series of different folders, all with the same subfolders e.g. 1. Incoming Letters 2. Outgoing Letters 3. Notices of Delays 4. Notices of Variation 5. Notices of Prolongation etc, Better still if they are in two or more columns, to allow for different levels, with the same subfolder structure in the second level and onwards.

@elit6366 Год назад

Thank you for the new tip, but I’m trying to go further, cause you need to have your bat inside the folder where you want to create those folders. So I’m wondering, is there a way to create a variable that asks user the path to create the folthers? I hope you can find the answer 😉😘😘 Have a nice day

@BigDaz2012 4 месяца назад

@cellmatestraining if i had a list of customers, and a list of say 5 subfolders i needed for each customer, is there a simple way to do this?

@cellmatestraining 4 месяца назад

Did you watch the video? That’s literally what I show. :)

@IntoKiransLife Месяц назад

can we do this viceversa?

@condogwow 5 месяцев назад

I'm confused why you would stop where you did...in most cases, a parent folder would have multiple subfolders, but you didn't explain how to add multiple subfolders or iterate the creation of subfolders across several parent folders. Could you touch on that please?

@sm-journey8281 17 дней назад

Tnx a ton! 🤩

@_-_-_-423 11 месяцев назад

If we want (Folder

@suttonlewis8105 7 месяцев назад

I tried this method with 4 levels of subfolders, it worked flawlessly. Turns out, I didn’t even have to list the parent folders individually as shown in the tutorial.. just make sure the lowest level subfolders have a complete file path and any parent folders included in the path will automatically be created.

@azlankhan7158 6 месяцев назад

Hi, thank you for this video, could you please let us know how to create Folder > Subfolder >> Sub Sub folder? Thanks

@mankottutharayil Год назад

Thank u madam Regards Sabu Saudi arabia

@hpaoolemiss1533 4 месяца назад

Let's say I have Last name, first name in a cell and I want to create folders for each person. How would I get around the space problem/creating a different folder for last name and first names? I tried to use a formula to add quotes to each but then it just thinks its part of the formula

@cellmatestraining 4 месяца назад

Wrap the names in quote marks so, MD “Bloggs Joe” or separate with an underscore. The last video I posted on my channel shows this method.

@cellmatestraining 4 месяца назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-AIBw3g_JHnI.htmlsi=IFV41NqsKX83KDOE

@charlesxix Год назад

Spot on, Thanks.😘😘

@evilhubert 3 месяца назад

🤯

@sunnygala7972 Год назад

Thank you so much

@AuditPasha Год назад

I was just watching you, then I realized I am here to see the shortcut, started watching the video again, and thank you so much....

@milominder 9 месяцев назад

Very cool. It popped a few odd characters into folder names, but those were easily dealt with.

@brtlylnrd2497 11 месяцев назад

Thank you! I've been making 100s of folders manually and this really helps a lot.

@jigilojoes 7 месяцев назад

you could also use a _ instead of a space.

@IndianSarees-h5s 11 месяцев назад

Thank you, Good Explain mam

@kcfmark 3 месяца назад

Tq!!!!!

@iz8758 Год назад

Brilliant! Cheers...

@cellmatestraining Год назад

You’re welcome!

@AllanChristensen1979 Год назад

Hello Deb :o) Thank you very much for this video, it's so great and saved me for a lot of work, just one question. Now you have a viewer from Denmark, and as you properly know, we have a few more letters in our Alphabet “Æ,Ø,Å” do you know if that is possible to put into the code, so it gets correct, course at the moment these letters appears as “├ÿR”

@francoislabarre7762 Год назад

Did you get an answer? I would like to use french letters like "é", "è", etc.. but it seems to be problematic for now. Thank you!

@adicsal6821 11 месяцев назад

Save txt in ANSI code (not UTF-8) --> md.bat chcp 1252 MD Æ,Ø,Å _(CHCP - Change Code Page - Windows CMD)_ _437 United States default code page in the US_ _850 Multilingual (Latin I) default code page in most of Europe_ _1250 Central European and Eastern European languages_ _1252 West European Latin_ (Denmark?)

@FergusFerguson-mp8uo Год назад

This is great, thank you. Q- Once the script in batch file has been run and the folders and subfolders have been created. Is it safe to delete the batch file?

@sanketdavande546 9 месяцев назад

Yes you can delete

@petrx100 7 месяцев назад

Life saver ❤

@sanketdavande546 9 месяцев назад

Can we create multiple subfolders?

@suttonlewis8105 7 месяцев назад

Yes. It worked for me when I tried with 4 levels of subfolders. Turns out, I didn’t have to list the parent folders individually either.. just make sure the lowest level subfolders have a complete file path and any parent folders included in the path will automatically be created.

@yahyaali3639 7 месяцев назад

You are an amazing person; can you show us how to create a main folder with many supfolders and files in different formats; we want to see all these files just by touching the main folder! Can you do this? Thank you in advance

@cellmatestraining 7 месяцев назад

This method only creates the folders and subfolders for you. It doesn’t reorganise all of your files into those folders.

@cellmatestraining 7 месяцев назад

Are you looking for method other than simply opening files from folders in file explorer?

@yahyaali3639 7 месяцев назад

Well; I just wanted to see the files without having to open all the subfolders!! Thank you and greetings; I wish you a wonderful day. @@cellmatestraining