Create Multiple Folders At Once Using Batch File

Hello guys! In this video, I want to share about how to create multiple folder at once. First, you have to open the excel file and then you will see that. There are 100 rows of the data which are containing the country name in the world. and then we have to create the folder for each of the country. Normally, people will open the file explorer and then right click select new and then click on folder so we can done it by create 100 folder just a few minutes. So let us do it.

First and foremost, we have to open the 00:42 - excel file and then we have to move on the column A data to the column B. So we can press CTRL+G to pop out the window Go To and then select on special, click it and then select on constants and then click ok. So it will automatically select on the data of the column A and then we can press CTRL+X to cut the selection and then paste it to the column B by pressing CTRL+V and then we have to add the double quote to the country name by click on format and then format cell and then select on the custom and then Type: general, we have to remove it type on \“@\” and then click ok. So it will automatically add the double quote to this country name all of the country name and then you have to go to the column A first row of the column A and then type on md and then select on the row 2 of the column A and then go to the home menu here select on fill and then flash fill it will automatically fill the md to all the country in the excel file and then you have to press CTRL+G again to open the Go To window and then click on special choose again constants and then click ok. So it will automatically select on the data of this excel file and then we have to CTRL+C to copy the text and then go to the folder that you want to create the folder here right click select on new click on text document and then place it a rename “creating folder” enter, open it and then press CTRL+V to paste the text and then click file save and then click file save as you can change on this save as type to the all file and then delete on.txt and then change to.

bat and then click save and then 03:36 - close this notepad and then we just double click on this one creating folder.bat and then double click it. It will automatically create the folder of each of the country That’s all thank you! .