dropbox

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 dropbox 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.

dropbox

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.

dropbox

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

dropbox

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

dropbox

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.

dropbox

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

dropbox

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

dropbox

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

dropbox

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

dropbox

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 or email at info@primesellerhub.in.

Co-Founder of Prime Seller Hub.

Published by

Alok Paul

Co-Founder of Prime Seller Hub.

20 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

  2. Thanks dude. This saved so much of my time.. Just one little query, when I copy and paste the cpoied dropbox links, the names ( also the links after performing module) come in alternate rows(i.e. every other row is blank) then I have to use goto function and delete blank rows, so is there any other solution?

  3. Hi,

    Thanks for the info.

    However, while I am trying to paste the image links on the excel file, the actual images are getting pasted instead of the links. Can you help me to understand how to get rid of this?

    1. The links are just behind the images. Just increase the column width and you will be able to find your links.

      After running the macro, to get rid of images, just copy both the column and paste onto another sheet as values and you will be able to find what you are looking for.

  4. Hi Aloke, Please can you help me :

    I tried this method to copy links to the images in dropbox. 1. It is taking huge time for copying to excel sheet and feels that it will fail. 2.So, I tried with 2 images – instead of the link being copied onto excel the images appeared. 3. Then, The module is not opening on pressing ALT+F11 instead, the brightness gets adjusted. I am using windows 10.

    Also I want solution to get links in bulk from goodle drive. I tried this by getting ADDON in the google sheet but there it is pulling the downloadable links – which i dont need. I need viewable links for amazon, flipkart etc.

    Thanks, gautam

  5. owever, while I am trying to paste the image links on the excel file, the actual images are getting pasted instead of the links. Can you help me to understand how to get rid of this?

Leave a Reply