Create folders in File Explorer using Excel

If you've ever needed a large number of new folders in File Explorer, going through the tedious process of manually creating each one and naming them is bound to drive you crazy.

With this method, say goodbye to the manual way as you generate a set of folders in a flash. And believe it or not, the process starts in Excel!

Assuming you have a table of first names and last names, the steps are:

1️⃣ Define your folder name structure using a formula like ="𝙼𝙳 "&𝚄𝙿𝙿𝙴𝚁([@[𝙻𝚊𝚜𝚝 𝙽𝚊𝚖𝚎]])&"_"&[@[𝙵𝚒𝚛𝚜𝚝 𝙽𝚊𝚖𝚎]], remembering to start with 'MD', which stands for 'Make Directory'.

2️⃣ Select the values and copy them (Ctrl + C).

3️⃣ Paste the values (Ctrl + V) in a new Notepad window.

4️⃣ Go to File ＞ Save as, and rename the file, ending it with .bat (batch file).

5️⃣ Create a folder in your chosen location and select Save.

6️⃣ Double-click on the batch file to generate the folders.

Much better, eh?

#exceleration #excel #microsoftexcel #excelformulas #exceltips #globalexcelsummit

---

The Global Excel Summit is the world's largest gathering of Microsoft Excel users and experts.

Learn more at https://globalexcelsummit.com/.

Find us on:

👔 LinkedIn:   / global-excel-summit  
🐤 Twitter:   / excelsummit  
🟦 Facebook:   / globalexcelsummit  
📸 Instagram:   / globalexcelsummit  
🤳 TikTok:   / globalexcelsummit