Folder Index Generator

😫 The Pain Point

You have a hard drive from 2010 with 10,000 nested files. You need to know what’s in there without clicking through every folder. Or your Boss: “Give me a list of all contracts on the server.”

🚀 Agentic Solution

Drive Crawler: Recursively walks through every subfolder and logs file details into Excel.

Key Features:

• Hyperlinks: Clicking the filename in Excel opens the actual file.
• Tree View: Flattens a deep structure into a readable list.

⚔️ Phase 1: Commander (Quick Fix)

For a quick lookup list.

Prompt:

“List all files in the current directory and subdirectories. Save the Filename, Path, and Size to File_Index.csv.”

Result: A CSV inventory.

🏗️ Phase 2: Architect (Permanent Tool)

For IT Admins.

Engineering Prompt:

**Role:** Python Utils Developer
**Task:** Create a "directory To Excel Indexer".
**Requirements:**
1.  **GUI:**
    *   Select Target Folder.
    *   "Generate Index" button.
2.  **Logic:**
    *   Walk directory using `os.walk`.
    *   Collect: Name, Extension, Size (MB), Created Date, Path.
    *   **Feature:** Create Excel Hyperlinks (`=HYPERLINK(path, name)`).
    *   Save as `.xlsx` using Pandas.
3.  **Deliverables:** `folder_indexer.py`, `run.bat` (Windows), `run.sh` (Mac).

🧠 Prompt Decoding

• Hyperlink: Making the Excel “Clickable” transforms dead data into a live dashboard. Just merging the text path isn’t enough; using the Excel formula functionality creates a superior UX.

🛠️ Instructions

1. Copy Prompt -> Paste -> Run.
2. Select Drive/Folder -> Generate.