Summary

Batch-creating new folders in File Explorer can be time-consuming and tedious.

However, using Excel’s FlashFill, you could generate hundreds of folders in just a few quick steps.

choose the cell you’ve just typed in, and press Ctrl+E.

A laptop with Excel and the file explorer open.

Lucas Gouveia / Hannah Stryker / How-To Geek

This will FlashFill the rest of Column B with the folder names in the MD format.

Then, click Save.

Locate and double-hit the “.bat” file you just saved to prompt it to run.

An Excel sheet containing a list of names in column A and the corresponding MD format in the first cell in column B.

Then, after a few seconds, you see the individual folders appear in the same location.

you could now close Excel and delete the “.bat” file.

Who knew that such a long-winded and laborious task could be made so simple and quick?

An Excel sheet containing a list of names in column A and the corresponding MD format in column B.

To make managing these folders a little easier, consider using theWindows 11 File Explorer tabs.

A list of names in Notepad, pasted from Excel, written using the MD format.

The Save As dialog box in Notepad, with the location, file name, and Save button highlighted.

Singers' individual folders in the Windows Explorer Desktop folder.