Summary
Batch-creating new folders in File Explorer can be time-consuming and tedious. However, using Excel’s FlashFill, you may generate hundreds of folders in just a few quick steps.
Open a new Excel workbook and either type or copy and paste the list that you want to convert into folder names in column A under an appropriate column header (in our case, we’re using singers' names).
In column B, typeFolder nameas the column header, and type the first folder name using the following format:
whereTom_Jonesis the folder name, andMDprompts the creation of a directory. If you have more than one word in the names, make sure you include the underscore (_)—otherwise, separate folders will be created for both Tom and Jones.
Select the cell you’ve just typed in, and press Ctrl+E. This will FlashFill the rest of Column B with the folder names in the MD format.
Select all the data in column B (excluding the column header), and press Ctrl+C to add it to your clipboard. Then, open Notepad (typeNotepadinto the search box on the taskbar), and press Ctrl+V to paste the list.
As Notepad automatically saves your work, you might find that there is already text present from when you last used the program. If this is the case, click File > New Window, and this will create a blank Notepad canvas for you to work on.
Press Ctrl+Shift+S to bring up the Save As dialog box, and select where you want the folders to be generated. In the File Name field, give your file an appropriate name and add.batto the end (for example,Singers.bat). Then, click Save.
Locate and double-click the “.bat” file you just saved to prompt it to run. Then, after a few seconds, you see the individual folders appear in the same location.
you may now close Excel and delete the “.bat” file.
That’s it! Who knew that such a long-winded and laborious task could be made so simple and quick? To make managing these folders a little easier, consider using theWindows 11 File Explorer tabs.
