How to create folders in bulk from an Excel File

Today I'm gonna share a quick Windows tip which may save you a lot of time.

Our objective is to create an individual folder for each student listed. While manual creation is feasible for a short list, managing hundreds of entries may prove cumbersome.

Programs used:

• Microsoft Excel
• Notepad

Step 1: Add "MD" (Make Directory) to each name

As it is evident that manual input is impractical for this task., use the following formula to automate this process efficiently.

="MD "&A2

Then you can drag it down to apply it to all names.

Step 2: Paste column B into Notepad

Select Column B and hit Ctrl+C or Right click and click on Copy

Then Open Notepad via the search bar in your task bar (in newer versions of Windows)

Upon opening Notepad, simply hit Ctrl+V or Right click then "Paste" to paste the contents of Column B into Notepad.

Step 3: Save as a batch file

This step is short

Simply hit Ctrl+S or File- Save (or Save As)

In this case I will name the file "students" and the file extension you need to use is .bat

To avoid overcomplicating things, all you need to do is add a dot bat at the end of the name "students.bat"

Step 4: Run the Bat file

Click on the ".bat" file and wait for a second.

You now have a folder for each student.

Mission Accomplished. (This could work if you have hundreds or even thousands of entries)

Follow for more