Uploaded December 2025 | Updated September 2026, 2 weeks ago

---

Welcome to dptutorials, where Excel automation is made simple and practical.

In this video, you’ll learn how to create folders and sub-folders automatically from Excel without using VBA. This method uses a simple directory.bat file and a CSV exported from Excel, making it perfect for environments where macros are disabled.

By storing folder paths and sub-folder names in Excel and running a BAT file, Windows automatically creates the complete folder structure in seconds. This approach is ideal for project folders, client documentation, HR employee records, finance files, audit folders, and operations teams.

You’ll see how to structure the Excel data, save it as CSV, write the BAT script, and run it safely on any Windows system. This lightweight automation saves hours of manual folder creation and ensures consistency across teams.

Subscribe to dptutorials for more Excel automation tutorials, productivity hacks, and real-world Excel solutions.

Create Folders from Excel Without VBA directory bat Method

#ExcelShorts #ExcelAutomation #BatchFile