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

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

Paul Lv12

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.

​​​

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

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.

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

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.

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

Epubor Audible Converter for Win: Download and convert Audible AAXC/AA/AAX to MP3 with 100% original quality preserved.

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.

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

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.

Singers' individual folders in the Windows Explorer Desktop folder.

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 .

  • Title: Streamline Your Workflow: Create Multiple Folders Fast Using Excel Techniques.
  • Author: Paul
  • Created at : 2024-08-28 05:24:10
  • Updated at : 2024-08-29 05:24:10
  • Link: https://win-able.techidaily.com/streamline-your-workflow-create-multiple-folders-fast-using-excel-techniques/
  • License: This work is licensed under CC BY-NC-SA 4.0.
On this page
Streamline Your Workflow: Create Multiple Folders Fast Using Excel Techniques.