nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Child Item

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

mendezcarlos

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. Can anyone share a way to do such export or copy paste hack?

Find more posts tagged with

Third Party Integrations

Organize

Dropbox Business

Closed - Inactive

Comments

DBoxTips

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)

mendezcarlos

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.

DBoxTips

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.

Kitiaro Bloodbane

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