Buzz
In your daily work, there are times when you need to create hundreds of folders on your computer. However, creating each folder one by one can be time-consuming and laborious. Is there a way to create multiple folders in no time? Absolutely! In this article, I'll share with you how to create folders from an Excel list in a breeze.
How to Generate Folders from an Excel List
To create multiple folders instantly, follow these steps carefully.
Step 1: Access the list in your Excel file > Right next to the first cell, type md 'folder name'.
- For example, md 'John Doe'
Step 2: Press
Step 3: Access the location where you want to store those Folders, right-click on any empty space > Choose New > Select Text Document.
Step 4: Next, open the Text Document > Press Ctrl + V to paste all the previously copied Folder names.
Step 5: Select File > Select Save or use the shortcut CTRL + S to save your changes.
Step 6: Rename the Text Document file to a file with the .bat extension.
Step 7: Finally, run the .bat file to achieve the desired outcome.
So, that's how you can share how to create folders from an Excel list. Thank you for taking the time to read my article. Hope the article helps everyone. If you find it helpful, please share and comment below to discuss more together.
Are you looking for a Laptop with a 1 TB SSD? Visit The Gioi Di Dong website to find the Laptop that suits your budget best by clicking the orange button below.
1 TB SSD LAPTOPS AT Mytour
Check out more:
- How to preview files without opening them on Windows 11 conveniently
- Simple guide on how to edit images in Excel that you should know
- The most accurate and fastest way to calculate your academic points for 2023
