BatchScript: FolderCreatorTool using csv

🧰 KPT-0002 | Create Folders from an Excel .csv File Using a Simple Batch Script

🔢 Post ID: KPT-0002

If you loved the trick in KPT-0001, here’s an even smoother one — using a .csv file instead of a .txt.

We’ll still use the same .bat file approach, but this time we’re giving users the power of Excel + CSV to manage folder paths quickly.

---

🎯 What This Script Does

• Uses a .csv file containing folder paths (e.g., India\Assam\Kamrup)
• Runs a lightweight .bat script to create those folders instantly
• Works on any Windows PC — no installations, no admin rights, no extras

🖱️ Just double-click the .bat file

🎉 Boom! Your folders appear like magic

🗃️ It's automation, the old-school way — fast, clean, and offline

---

📁 Real Use Case: What If Your Data Isn’t Ready?

In government offices (like mine!), most Excel files look like this:

State	District
Assam	Kamrup
Assam	Jorhat
Assam	Sivasagar
Assam	Dibrugarh
Assam	Nagaon

But our batch script can’t work with two columns — it needs a single folder path like:

India\Assam\Kamrup
India\Assam\Jorhat
India\Assam\Sivasagar

---

🛠️ Excel Hack to Fix This

Here’s a quick Excel formula that combines columns into paths:

If your data is in columns A and B:

=TEXTJOIN("\", TRUE, "India", A2, B2)

Or, for older Excel:

="India\" & A2 & "\" & B2

💡 Paste this in Column C and drag down — copy the result into a .csv, and you’re done.

---

🗂️ Example Folder Paths

India\Assam\Kamrup
India\Assam\Jorhat
India\Assam\Sivasagar
India\Assam\Dibrugarh
India\Assam\Nagaon

📄 Download example_government_folder_data.csv

---

🙌 Wrapping Up

This CSV method is great for:

• Government departments
• Office record keeping
• Anyone organizing district/state-wise data

It brings your Excel database to life in your Windows folders.

---

📥 Get the Files

📁 Download Script & Sample CSV (.ZIP)

---

📚 Explore more tools:

━━━━━━━━━━ 𖤓 THE KRITTIKA PROJECT 𖤓 ━━━━━━━━━━

✍️ Written by Amaljit Bharali | ☄️ Krittika Guides Me | The Rover Builds | 2025