Our Community is in read-only mode until April 8th, learn more here. You can still search existing threads or get help via Dropbox Support, the Dropbox Help Center, or Learn.
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...
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.
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
