Buzz
Imagine you have an employee list in Excel and need to create individual folders for each person to store their personal information. Doing this manually can be time-consuming. Instead, learn how to generate multiple folders directly from an Excel list. In this article, Mytour will guide you through two simple methods to create folders based on an Excel list.
Creating Folders from an Excel List Using MD Command and Notepad
Transforming an Excel list into folders using the MD command combined with Notepad is a quick and straightforward trick. This method is perfect for handling long lists and eliminates the need to manually create each folder.
Step 1: Open Excel and load the file containing the list you need to create folders for. Here, Mytour will use an example of a company employee list.
Step 2: In the cell next to the first item in your list (in this example, B2), enter the command: =”MD “&A2 (where A2 is the first cell of the list).
You will notice that cell B2 displays the value: “MD [Content of A2]”.
Step 3: this formula for the remaining items in the list.
Move your cursor to the bottom-right corner of cell B2 until it turns into a black plus sign.
Hold down the left mouse button and drag it down to the subsequent cells in the list, and the formula will automatically be copied in bulk.
Step 4: Now, select all the MD cells in column B, press Ctrl + C to copy (or right-click and choose ).
Step 5: Next, open the Notepad application on your computer. Type Notepad into the Windows search bar.
Press Ctrl + V to paste your list into Notepad.
Step 6: Now, select File -> Save or press Ctrl + S to save the .bat file.
Choose the location where you want to create the new folders based on the list, then name the file and ensure you add .bat at the end.
Step 7: Run the .bat file you’ve just created.
The list you’ve created will automatically generate folders with corresponding names in the location where the .bat file is saved (in this example, the Desktop).
Note: In some cases, the folders may have incorrect names. To fix this, ensure the values follow the rule of using only unaccented letters, numbers, and hyphens.
This is a simple way to quickly generate multiple folders using a pre-made list in Excel. This method saves significant time and effort compared to manually creating folders. If you found this guide helpful, share this tip with your colleagues and friends!
