How to make Dropbox image links in bulk?

If you are anyway related to the online industry you will definitely come across the need to make image links for the various portals such as amazon, flipkart, ebay, snapdeal and as well as your own online stores.

Creating image links one by one can be a very tedious and time taking. If creating links is a nightmare for you than I have good news for you, the perfect solution for you which is easy to implement.

In Dropbox we cannot create image links in bulk but there is a work around. Please use the below steps to achieve it:

STEP 1: Copy dropbox link for the folder you want to create the image links.

Step1

STEP 2: Open incognito mode in chrome, without incognito mode also it is possible but make sure you are not logged into your dropbox account.

Step2

STEP 3: Paste the dropbox link which you copied in STEP 1

Step3

STEP 4: Drag and select all the images in the folder and press CTRL+C (Copy all the images from the folder)

Step4

STEP 5: Press CTRL + V and paste all the image links in Column A in the sheet. After that click ALT+F11 to open module in macro. Check STEP 6.

Step5

STEP 6: Paste the below code in the module:

Sub ExtractHL()
Dim HL As Hyperlink
For Each HL In ActiveSheet.Hyperlinks
HL.Range.Offset(0, 1).Value = HL.Address
Next
End Sub

Step6

STEP 7: Press ALT + F8 and run the macro ExtractHL

Step7

You will get the below error, but please ignore and click on End.

Step9

STEP 8: You will get all the links as below in the excel sheet.

Step8

If you think this tutorial made your life easy, please do share among the people who might need it. In case you face any issue please feel free to comment below.

Co-Founder of Prime Seller Hub.

Published by

Alok Paul

Co-Founder of Prime Seller Hub.

13 thoughts on “How to make Dropbox image links in bulk?

  1. Thanks a lot for making it easier, but this is to inform you that links not working for e-commerce listings, it shows invalid URL during upload and also if you will choose the manual method to get Dropbox link and bulk method to get link than you will find both of the link is different (bulk images link is ending with ? mark instead of dl=0)

    1. Hi Rakesh,

      Thanks for the feedback. We are regularly using this method to create these dropbox links and using across all the marketplaces such as amazon, flipkart, snapdeal, shopify etc.
      Please share your excel sheet at info@primesellerhub.com, I will check and revert. In dropbox if a link is ending with ?dl=0 it means do not download automatically. If it ends with ?dl=1 it means download file automatically. In case it ends with ?raw=1 it means the actual image file. Please replace ?dl=0 with ?raw=1 it will work.

      Regards,
      Alok

Leave a Reply