Need to see if your shared folder is taking up space on your dropbox 👨💻? Find out how to check here.
Forum Discussion
Mourad A.
11 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)
26 Replies
Replies have been turned off for this discussion
- Mark11 years ago
Super User II
No.
- DaveC211 years agoNew member | Level 1
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) - David J.711 years agoNew member | Level 1
Dave, you're a star. I thought I was going to have to manually retrieve heaps of public links. In case anyone else comes across this, here's the solution I employed to get a large text list of public links:-
- ^ What Dave said. ^
- Use a batch file to get a text list of directory contents (Google "batch list directory contents" for plenty of solutions).
- Copy-paste the batch output into Excel (or a freeware CSV editor), B column, fill A column with the public directory path, save as CSV.
- Edit CSV in Notepad, use search/replace to remove the comma separating the directory and filename.
Steps 3 and 4 could be skipped, if I knew how to code batch files, alas no... Too technical for me. If the files need to be web path converted, as Dave says, try Googling "URL encode decode" for more helpful results than "web path converter", and convert the files before step 3.
- Alex T.2011 years agoNew member | Level 1
hi Dave, this is exactly what I need too. BUt I cannot find this "NEVER CHANGING public folder link" how do I get it? Instead i get something like this https://www.dropbox.com/sh/7ukk1v5rs7plv3c/AAChNUFt62VI-FbWsUddd8iDll-4Ka?dl=0 (but not exactly this)
thanks
- Zhao Yao L.11 years agoNew member | Level 1
@Alex, before you share the link, your files must keep in a PUBLIC folder. Eg: dropbox\public
- Alex T.2011 years agoNew member | Level 1
Zhao. please elaborate. Give very specific steps to take.
The folder is called public and it's shared.
thanks
- Rich11 years ago
Super User II
The "Public" folder is a special folder; not one you created. It's also a deprecated feature that no longer exists on new accounts (Pro and Business accounts can still create one; Basic accounts cannot). Public links were replaced by Share links, which can be created for any file or folder in your account (i.e. not limited to the Public folder), but they cannot be generated in bulk.
See here for more information: https://help.dropbox.com/files-folders/public-folder
- Alex T.2011 years agoNew member | Level 1
Rich, thanks for the info, though it's very annoying. I'm post 2012, so what are my options then? I only need 1GB storage but i need URLs I can generate without asking the server.
- Alex T.2011 years agoNew member | Level 1
eg. Can i upgrade for a month and then downgrade?
- Rich11 years ago
Super User II
Can i upgrade for a month and then downgrade?
Yes, you can. Just remember what I said; the Public folder is a deprecated feature and has been replaced by Share links. There's no guarantee that it will be around forever.
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.
The Dropbox Community team is active from Monday to Friday. We try to respond to you as soon as we can, usually within 2 hours.
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, Facebook or Instagram.
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!