Create Multiple Folders From Excel Data In 3 Steps

Multiple Folders From Excel Data

Creating 50 Folders and naming them with student names is a hard task, but I must do it to save assignments for each student in a separate folder.

Here is how I am going to do it in 3 steps:

Step One ► Excel

In an Excel spreadsheet, I have a long list of student names in columns A and B.

I start by creating a calculated column in column C in which I combine the First and Last names (that will be the name of the Folder, preceded by “MD “ which stands for “Make Directory”.

Note the space after the D in “MD “

My formula will be:

=”MD “&A2&”_”&B2

Copy the formula down to the entire list of students (whatever the number of students)

Copy all the results of the formula in column C

Step Two ► Notepad

Open Notepad

Paste in Notepad what you copied from Excel.

Save the Notepad file in a separate empty folder (could be on your Desktop) that you created for this project. I have a folder named My Students on the Desktop.

When saving the Notepad file, the name should end with ► .bat

I will name my file ► Assignments.bat

Close the Notepad file

Step Three ► Open File Explorer

Navigate to the folder you previously created on the Desktop (mine was named My Students) and open it

You will find the Notepad file (created in Step Two) Assignments.bat as a Folder.

Watch the magic Now:

Double-click on that folder, and instantly a folder is created for each student and named with First and Last names.

Isn’t that spectacular?

Watch it on TikTok (59 Sec)

@officeinstructor.com

Create Multiple Folders From Excel Data in 1 Step

♬ original sound - Nabil Mourad
Share This Post
Have your say!
3 0

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.

Thanks for Downloading Your Gift

We have sent your quick reference guide for creating Dashboard.

Please check your inbox to receive Your Gift.

Happy Learning !!

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.