Exce
✅ Create Multiple Folders Using Excel + Notepad (No VBA)
📌 Step 1: Type Folder Names in Excel
In Column A, type your folder names:
Folder1
Folder2
Invoices
Reports
2025 Files
---
📌 Step 2: Create "mkdir" commands in Excel
In Column B, type this formula (assuming names are in A1 downwards):
="mkdir """ & A1 & """"
➡️ This creates a command line to make folders, like:
mkdir "Folder1"
mkdir "Folder2"
mkdir "Invoices"
---
📌 Step 3: Copy the commands to Notepad
1. Copy the Column B values (not the formula, but the output).
2. Open Notepad.
3. Paste the copied text into Notepad.
---
📌 Step 4: Save as a Batch File
1. In Notepad, click File Save As.
2. In File name, type:
create-folders.bat
3. In Save as type, choose:
All Files (*.*)
4. Save it to your desktop or desired folder.
---
📌 Step 5: Run the Batch File
1. Double-click on create-folders.bat.
2. It will instantly create all folders in the folder where the .bat file is located.