BatchScript: FolderCreatorTool using csv

Amaljit Bharali — Sun, 04 May 2025 09:22:13 +0000

🧰 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

BatchScript: FolderCreatorTool using a *.txt file

Amaljit Bharali — Sun, 04 May 2025 06:44:16 +0000

🧰 KPT-0001 | Create Folders Automatically with a Simple Batch Script

🔢 Post ID: KPT-0001

Need to create a structured set of folders in Windows without any special software? Here's a lightweight .bat script that reads a text file and builds your folder tree instantly.

🎯 What This Script Does

Reads folder names from a folders.txt file
Creates folders and subfolders wherever you run the script
Requires no installation — works on all modern Windows PCs

🖱️ Just double-click the .bat file

🎉 Boom! Your folders appear like magic, already named just the way you want

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

📁 Example Input File (`folders.txt`)

I have planned my folder structure as below — a simple model of my native state India > Assam > Districts. Basically I want to create a folder "India" under which my State "Assam" and finally all my district-wise folders under the state "Assam":

India
└── Assam
    ├── Baksa
    ├── Barpeta
    ├── Biswanath
    ├── Bongaigaon
    ├── Cachar
    ├── Charaideo
    ├── Chirang
    ├── Darrang
    ├── Dhemaji
    ├── Dhubri
    ├── Dibrugarh
    ├── Goalpara
    ├── Golaghat
    ├── Hailakandi
    ├── Hojai
    ├── Jorhat
    ├── Kamrup
    ├── Kamrup Metropolitan
    ├── Karbi Anglong
    ├── Karimganj
    ├── Kokrajhar
    ├── Lakhimpur
    ├── Majuli
    ├── Morigaon
    ├── Nagaon
    ├── Nalbari
    ├── Sivasagar
    ├── Sonitpur
    ├── South Salmara-Mankachar
    ├── Tinsukia
    ├── Udalguri
    └── West Karbi Anglong

🗂️ The Final Output (Example File)

🙌 Wrapping Up

This simple batch script saves time, removes repetition, and gives you full control over folder structures — no software or manual creation of folders and then renaming each and every folder required.

💡 Whether you're organizing projects, journals, or research — this is just the beginning of more powerful Windows tricks I’ll be sharing.

💡 Want to do the same with Excel instead of a text file?

👉 Check out my next blog – KPT-0002 (Link to be added once published)

📥 Get the Files

📁 Download Folder Script (.ZIP)

📚 Explore more tools:

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

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

DEV Community: Amaljit Bharali

BatchScript: FolderCreatorTool using csv

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

🎯 What This Script Does

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

🛠️ Excel Hack to Fix This

🗂️ Example Folder Paths

🙌 Wrapping Up

📥 Get the Files

BatchScript: FolderCreatorTool using a *.txt file

🧰 KPT-0001 | Create Folders Automatically with a Simple Batch Script

🎯 What This Script Does

📁 Example Input File (folders.txt)

🗂️ The Final Output (Example File)

🙌 Wrapping Up

📥 Get the Files

📁 Example Input File (`folders.txt`)