🧰 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