Don't Spend Hours Batch-Creating New Folders—Use Excel to Do It in Minutes

This tutorial shows you how to quickly create many folders using Excel's Flash Fill and a batch file. Say goodbye to tedious manual folder creation!

Here's how:

1. Prepare your list: In a new Excel spreadsheet, list the names you want to use for your folders in column A (e.g., singer names).

2. Format for batch creation: In column B, add the header "Folder Name". In the first cell under this header, type the command to create a folder, using the format: MD Tom_Jones (replace "Tom_Jones" with your first folder name, using underscores for multi-word names).

   

3. Flash Fill: Select the cell with the MD command. Press Ctrl E to use Excel's Flash Fill feature and automatically generate the MD command for all names in column A.

   

4. Copy to Notepad: Select all the MD commands in column B (excluding the header), copy them (Ctrl C), and paste them into a new Notepad window (Ctrl V).

   

5. Save as a batch file: Save the Notepad file as a .bat file (e.g., folders.bat). Choose the location where you want the folders to be created.

   

6. Run the batch file: Double-click the .bat file. The folders will be created in the specified location.

   

7. Cleanup: Close Excel and delete the .bat file.

Now you have hundreds of folders created quickly and easily! For easier folder management, use Windows 11's File Explorer tabs.

The above is the detailed content of Don't Spend Hours Batch-Creating New Folders—Use Excel to Do It in Minutes. For more information, please follow other related articles on the PHP Chinese website!