Streamline Your Workflow: Create Multiple Folders Fast Using Excel Techniques.

Highlights

• Use Excel’s FlashFill to create hundreds of MD folder names quickly and easily.
• Copy the folder list from Excel to Notepad and save it as a “.bat” file.
• Manage the folders by using Windows 11 File Explorer tabs.

Batch-creating new folders in File Explorer can be time-consuming and tedious. However, using Excel’s FlashFill, you can 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, type Folder name as the column header, and type the first folder name using the following format:

MD Tom_Jones

where Tom_Jones is the folder name, and MD prompts 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 (type Notepad into 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 .bat to 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 can 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 the Windows 11 File Explorer tabs .

Also read: