skysuite

Folder Index

A one-click directory cataloger that walks a folder tree on disk and writes a hyperlinked, hierarchical index of every folder and file to a new "Folder Index" sheet - with creation date, last-modified date, and size.

When to use it

  • Building an at-a-glance index sheet of a project folder before sending a client a deliverable bundle
  • Cataloging the contents of a shared drive into Excel for ad-hoc analysis or printing
  • Auditing what files actually live in a deep folder structure
  • Producing a clickable, persistent "table of contents" for a folder that you can hyperlink to in other workbooks

How it works

  1. 1
    Click Folder Index in the More Tools dropdown.
  2. 2
    Pick a folder in the standard folder browser.
  3. 3
    SkySuite creates a fresh Folder Index sheet in the active workbook.
  4. 4
    It recursively walks the folder, indenting each subdirectory one column deeper, and writes a hyperlinked entry for every file and subfolder it finds.
  5. 5
    The Date Created, Date Modified, and Size columns are auto-fit, and the sheet is left selected.

Tips & shortcuts

  • Folder Index is fully recursive - every nested subfolder is visited, with depth represented by column offset (level 1 in column D, level 2 in column E, etc.).
  • Each entry is a real Excel hyperlink, so Ctrl+Click opens the file or folder in Windows.
  • Permission or IO errors (file in use, path too long, access denied) are caught per-file and the entry falls back to a plain text name instead of failing the whole run.
  • Folder size is computed as the sum of all descendant file sizes, in MB rounded to two decimals.