#3 — Create a List of Folder(s) Contents with Hyperlinks

Don Tomoff
Dec 4, 2016 · 3 min read
ASAP Utilities generated list — 81000 Lines of files linked in Excel

The most popular use of ASAP Utilities for most users I work with is generating a linked list of folder properties and files. For some reason, getting a list of folder contents is something that is frequently needed, but there is no easy way to get at it (as far as I know, before ASAP Utilities…).

This list can be generated for as little as one folder or a full network drive (I have done it for a few hundred thousand lines).

In this post, I walk-through generating a file listing on a backup storage drive that I use. In future posts, I will address WHAT we can do with this data once we have it — getting the data is just step 1!


Steps to get your list

  • Open Excel and select ASAP Utilities — “ASAP Utilities → Information → 14. Create a list of filenames and properties in a folder…”
ASAP Utilities → Information → 14. Create a list of filenames and properties in a folder…
  • Select directory you want a contents list of (in this case, I am pointing to my Backup external hard drive)
Select folder source and start ASAP list generation
ASAP is working — just wait. It will take awhile depending on size!
  • Here is the default list that ASAP Utilities creates
Default list generated by ASAP Utilities

Once you have this list, there are two additional things I do immediately, which make it much easier to use:

  • Format the data list as an Excel data Table (this helps immensely for later use / analysis of this list.
Format Excel list as a Data Table
  • Next, create hyperlinks for the column that contains the “Folder and Name” — this can then be used to directly OPEN the referred to folder (to create the hyperlinks, HIGHLIGHT the entire column and use ASAP Utilities to create the hyperlinks).
ASAP file list — Table format — with Hyperlinks to files

That’s the basics of generating a list. It’s super helpful, but really is only getting started. In future posts, I will discuss developing analysis and capabilities to make this data dump truly useful!

About Don

Don is passionate about helping professionals and organizations keep up and adapt to the changing business world that we operate in.

“What Do You Do?”

I frequently get this question. My response (it’s not what you think!)? Check it out here!

Connect with Don!

LinkedIn, Flipboard, Twitter, Snapchat

Or, just Google me…I’m everywhere

Let’s Excel

Up your Excel game — Tips, tricks and efforts that have exponentially increased my productivity!

Don Tomoff

Written by

Invenio Advisors. It’s time for DIFFERENT— On a mission to challenge the status quo to a more productive and effective end… #digital #Excel #data #analytics

Let’s Excel

Up your Excel game — Tips, tricks and efforts that have exponentially increased my productivity!

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade