You might see that the Dropbox Community team have been busy working on some major updates to the Community itself! So, here is some info on what’s changed, what’s staying the same and what you can expect from the Dropbox Community overall.
Forum Discussion
Tricks for exporting file names to an Excel spreadsheet as index.
I have tried Zappier and other automations for exporting folders, subfolders, and even the files names to an excel spreadsheet to create an index or guide, even with the link for an easier access. Ca...
Hello mendezcarlos,
Can you share what you mean by “create an index or guide”? What kind of information would that guide contain? What would it look like? Trying to understand your need before I jump to suggesting solutions.
Thanks,
Andrew (DBoxTips)
Can you share what you mean by “create an index or guide”? What kind of information would that guide contain? What would it look like? Trying to understand your need before I jump to suggesting solutions.
Thanks,
Andrew (DBoxTips)
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.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.
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
About Dropbox tips & tricks
Learn how to get the most out of Dropbox with other users like you.
