Buzz
How to Create Folders Using an Excel Sheet
To instantly create multiple folders, follow these steps carefully.
Step 1: Open your Excel file with the list > Next to the first cell, type md 'folder name'.
- For example, md 'John Doe'
Step 2: Press Ctrl + E to generate the names of the subsequent Folders below > Then highlight the Folder names column, press Ctrl + C to copy
Step 3: Navigate to where you want to store those Folders, right-click on any empty space > Select New > Choose Text Document.
Step 4: 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, execute the .bat file to achieve the desired outcome.
So, that's how you can create Folders based on an Excel list. Thank you for taking the time to read my article. Hope it helps everyone. If you find it useful, feel free to share and comment below for further discussion.
Looking for a Laptop with a 1 TB SSD? Visit The Gioi Di Dong website to find a Laptop that suits your budget by clicking the orange button below.
LAPTOP WITH 1 TB SSD AT Mytour
Learn 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
