Creating an index with dropbox links to all files in the directory.

Question

Hi Everyone,

I work as a paralegal and routinely have a need to create hyperlinked indices to shared directories on dropbox. I work on a PC, and I've been manually copying dropbox links to files and inserting them into excel to create my indexes, but there are sometimes thousands of files in the directory, which takes forever. Does anyone know a way to automate the task of copying the hyperlinks from a dropbox directory and pasting them into excel?

I downloaded Directory List & Print Pro to help with this task, and it's great at creating hyperlinked indices, but it does not work with dropbox through my File Explorer--my dropbox folders won't even show as an option in the program. I

n my current project I have about 5000 files I need indexed with dropbox links. Does anyone have a solution?

Felix B. · Answer

Hi Megan,

I have this same question. What is the method with a third party involved?

signalfms · Answer

Yes, the same principle applies. I’m sure there are equivalent programs, but if your discovery Is in one place, do this:

1. open terminal and type “ls “ then drag the top level folder into the terminal. Then just add > and provide a filename, like so: “ls /Foldername/Subfoldername > OutputFileNameYouChoose.txt”

2. Using whichever text editor you prefer, search and replace so the file list looks like =HYPERLINK (/Foldername/Subfoldername/[filename].[extension]”,”Displsyname”).

3. Open the list in Excel. The links will not work. Then define the hyperlink base by using Properties>Summary and selecting the source folder.

4. Click on your beautiful, functional relative hyperlinks

Christel MWDJ · Answer

Anyone managed to do this on a mac? We can't use solution above because Karen's Directory Printer is only for Windows.