## Omega Technical Solutions Blog
Omega Technical Solutions has been serving the Haymarket area since 2007, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.
[ Categories ](https://www.omegatechnicalsolutions.com/blog/categories "Categories")
[ Tags ](https://www.omegatechnicalsolutions.com/blog/tags "Tags")
[ Categories: All Categories ](https://www.omegatechnicalsolutions.com/javascript:void(0); "Categories")
Search...Suggested keywords
[ x ](https://www.omegatechnicalsolutions.com/javascript:void(0);)
# Tip of the Week: Batch Create Folders Using Microsoft Excel
[Omega Technical Solutions Blog](https://www.omegatechnicalsolutions.com/blog/categories/blog) [Tip of the Week](https://www.omegatechnicalsolutions.com/blog/categories/tip-of-the-week)
[Steven Holmes](https://www.omegatechnicalsolutions.com/blog/blogger/steven-holmes)
Wednesday, 13 September 2023
[ 0 Comments ](https://www.omegatechnicalsolutions.com/blog/tip-of-the-week-batch-create-folders-using-microsoft-excel#comments)
[  ](//www.omegatechnicalsolutions.com/images/easyblog_shared/September_2023/09-13-23/manyDigitalFiles_114126241_400.jpg "Tip of the Week: Batch Create Folders Using Microsoft Excel")
We know you don’t need to be reminded that the administrative part of your job is one of the more unpleasant bits, at least one of the more boring parts of your work. One task that is particularly dull is creating different folders for all your employees, projects, and organizational needs. Microsoft Excel, however, makes it much easier to handle this mundane task—and you’ll feel like a pro for using it in this way.
## You Can Mass Generate Folders and Subfolders in Excel
Yes, that’s right. You won’t have to manually create and name each individual folder you need. Excel can handle this task automatically with the right trick up your sleeve. You can create a Windows Batch file, which is a file that contains a script for executing predetermined commands in a specific order.
Here’s the process you need to follow:
- **In one column, list all of the names** for your various folders using whatever naming conventions you require of them–day, month, year, team member names, departments, and so on.
- To create a batch file, **add a second column that formats this data in a very specific way**. For example, let’s say you want to make a folder for each month of 2024.
- Use the first column for your list of months. You can use “2024 - January” as your naming convention so Excel doesn’t auto-format your data.
- Use the following formula in the second column for your batch command: ="MD "&""""&A1&""""
- If you **drag the bottom corner of your top cell down**, the rest of the list will populate, referencing the appropriate cell in the first column as indicated in your formula.
- Now that your list is formatted as **MD “2024 - January,”** you can copy and paste the data into **Notepad**.
- Once the batch commands are copied over, save your Notepad file as a .bat file format wherever you want your folders to populate. If you click this file, your folders should automatically generate in this location.
Follow our steps carefully and you too can create folders in this way. And, of course, if it’s just not working for you for some reason, we’re happy to walk you through the process! Just give us a call at (703) 743-3056.
[ ](https://www.omegatechnicalsolutions.com/javascript:void(0);) [ ](https://www.omegatechnicalsolutions.com/javascript:void(0);) [ ](https://www.omegatechnicalsolutions.com/javascript:void(0);)
Tags:
[Quick Tips](https://www.omegatechnicalsolutions.com/blog/tags/quick-tips) [Software](https://www.omegatechnicalsolutions.com/blog/tags/software) [Microsoft Office](https://www.omegatechnicalsolutions.com/blog/tags/microsoft-office) [Tip of the Week](https://www.omegatechnicalsolutions.com/blog/tags/tip-of-the-week)
[ Streamline Your Sales Process with Technology ](https://www.omegatechnicalsolutions.com/blog/streamline-your-sales-process-with-technology)
[ Data Backup is Extremely Important ](https://www.omegatechnicalsolutions.com/blog/data-backup-is-extremely-important)
About the author
[  ](https://www.omegatechnicalsolutions.com/blog/blogger/steven-holmes)
[Steven Holmes](https://www.omegatechnicalsolutions.com/blog/blogger/steven-holmes)
[ ](https://www.omegatechnicalsolutions.com/javascript:void(0); "Subscribe to updates from author") [ ](https://www.omegatechnicalsolutions.com/javascript:void(0);) [ ](https://www.omegatechnicalsolutions.com/blog/blogger/steven-holmes)
Mr. Holmes is responsible for the structure, strategy and execution of Omega Technical Solutions’ team. He also has an extensive background in designing, engineering, and securing Enterprise and Data Center networks.
Author's recent posts
[More posts from author](https://www.omegatechnicalsolutions.com/blog/blogger/steven-holmes)
[ Tuesday, 28 July 2026 Is Your Team Losing Hours to Slow Systems? ](https://www.omegatechnicalsolutions.com/newsletter-content/is-your-team-losing-hours-to-slow-systems)
[ Monday, 27 July 2026 How Much Should Your Business Actually Spend on Technology Every Month? ](https://www.omegatechnicalsolutions.com/blog/how-much-should-your-business-actually-spend-on-technology-every-month)
[ Friday, 24 July 2026 Building a Productive and Protected IT Environment ](https://www.omegatechnicalsolutions.com/newsletter-content/building-a-productive-and-protected-it-environment)
Comments
No comments made yet. Be the first to submit a comment
**** Already Registered? [Login Here](https://www.omegatechnicalsolutions.com/component/users/login?return=aHR0cHM6Ly93d3cub21lZ2F0ZWNobmljYWxzb2x1dGlvbnMuY29tL2Jsb2cvdGlwLW9mLXRoZS13ZWVrLWJhdGNoLWNyZWF0ZS1mb2xkZXJzLXVzaW5nLW1pY3Jvc29mdC1leGNlbA==&Itemid=101)
Tuesday, 28 July 2026
Subscribe to the blog (Please fill in your email address to subscribe to updates from this post.)
**Captcha Image**