One month down in 2025: How are your resolutions coming along? Check out how to get back on track here.
Forum Discussion
Mourad A.
10 years agoNew member | Level 1
Dropbox File shared links bulk export
I have a folder which contains over 400 images, is there any tool to copy all these images' Dropbox links in Excel one time instead of one by one?
I suggest you enable your PUBLIC folder, then load the files into a subfolder say \dropbox\public\images\example.jpg
Once done you can get your NEVER CHANGING public folder link for \dropbox\public ( looks something like https://dl.dropboxusercontent.com/u/12345678 )
And simply append the subfolder and filenames to it https://dl.dropboxusercontent.com/u/12345678/images/example.jpg
.
Only thing to be careful of is if the subfolder or the filenames require web path conversions (spaces and od characters in the names etc)
- Alex T.20New member | Level 1
Thanks a lot, it's worth a shot, and fingers crossed this feature will not be taken out completely.
- David J.7New member | Level 1
Alex T,
Don't know if it still works, but try this link:-https://www.dropbox.com/enable_public_folder
When I visit it I do at least get a "You already have a Public folder." message, and it takes me to the public folder in my account, which would suggest it still works.
- RichSuper User II
That's the link he'll need, but it only works for Pro and Business accounts. Basic accounts cannot enable the Public folder if they don't already have one.
- Alex T.20New member | Level 1
Thanks guys, yes it works fine, just need to upgrade to pro to enable it. I assume the folder will continue to work if i downgrade but I'm gonna wait a month till I finish this job just to be sure.
- David J.7New member | Level 1
Aaah. Sorry for adding confusion.
- Chiro E.New member | Level 1
I've been looking for this with folders (not individual images, although it works with that), and THERE IS AN EASIER WAY!!
Zapier is an if this than that type automation program.
Make a zap and connect your dropbox account and excel
Step 1: Dropbox trigger: Either trigger for when a directory is created or a file is created.
---> there are multiple ways to handle the rest, I have a specific need to distribute to others so I did it like this:
Step 2: Find Row: In the linked excel document, we wanted all folders to be named/distributed by e-mail address so all our folders were named by their e-mail address and we found that row
Step 3: Update Row: One of the fields you can populate to excel is Dropbox link... I had a column that I named "Dropbox link" and populated it there.
Hope this helped!
- otttonnusNew member | Level 2Hey
- chicpatinaNew member | Level 2Hello
- Bob J.Helpful | Level 6
Unfortunatelyt this Public folder feature is about to be removed completely.
Normal users lose it in March 2017 and Pro and Business users in September 2017
But there is a big fight going on over this!
- Brandon B.6New member | Level 2
I don't want to mess around with the API so I just scrape the links using R
1. Put your files in a folder.
2. Get the share link for the folder.
3. Copy link.
4. Log out of dropbox.
5. Go to link.
6. Scroll alllll the way to the bottom.
7. Save page as.
8. Then you can scrape.
Example script.library(rvest) urls <- read_html("path/to/saved/page") %>% html_nodes("a") %>% html_attr("href") cat(urls[grepl("https://www.dropbox.com/sh",urls, fixed = TRUE)], sep = "\n")
- tess3New member | Level 2
I would like to make an bulk export (in .csv) with all the urls of the files in a specific folder. Would that be possible?
- MarkSuper User II
Not natively with Dropbox, no, but you could try writing a program via the API for you?
About View, download, and export
Need support with viewing, downloading, and exporting files and folders from your Dropbox account? Find help from the Dropbox Community.
Need more support
If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X or Facebook.
For more info on available support options for your Dropbox plan, see this article.
If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!