Tricks for exporting file names to an Excel spreadsheet as index.

Hi

If I understand you correctly you are trying to create a list of all your files in excel.

Have you tried copying the Explorer Address bar (your file(s) location) and pasting it into chrome like you would a link? In my experience this not only lists everything in the folder as a index list, but it also hyperlinks the files as well.

For example:

My folder address is    “C:\Users\KitiaroBloodbane\Desktop\Dropbox\LAVC” and I paste this directly into Chrome. And it gives a indexed list, which I can then copy and paste it into excel which retains the hyperlinks of each file.

Hope this helps

Thank you for the details. I have an internal tool that that I use for this. I plan to tidy it up and release it for anyone who needs this. If you would like to get it sooner, please reach me directly by adding “.com” to my forum username and entering the resulting address in your browser. I will also update this thread when I have it ready for everyone else.

Thanks, Andrew (DBoxTips)

I am an individual contributor to the Dropbox Community forums, not affiliated with Dropbox. All opinions expressed here are my own.

Thanks. Andrew. 
We have over 100 files in folders and subfolders for due diligence. There are a lot of people involved from different organizations (lawyers, bankers, accountants, etc.) so we need to keep an index of initial set of files available plus the tracking of added files or changes to any given folder or subfolder. Today that´s done manually and it´s painful. I tried Zappier automations and even a software called Karen´s files and didn´t work at all.  All suggestions and recommendations are welcomed.