Extracting Filenames from Dropbox Download Links
Use GSheets to easily get the filename from a URL address
Extracting Filenames from Dropbox Download Links
JD Berkowitz 2 November, 2021
Share this post

If you spend time wrangling product data or other spreadsheets with FQDNs (Fully qualified domain names) then you may need to split out the filename from the URL. Recently I had a customer whose product data was all in excel with links to the Dropbox image asset. Unfortutantly this makes life difficult for importing into an PIM or eCommerce platform such as Akeneo, BigCommerce or Shopify. 

Here is a quick formula to sperate the filename of URLs in excel

=REGEXEXTRACT(A1,"[^/]+$")

So if we have a cell with a URL such as 

https://www.dropbox.com/s/wlnb20hjaliqomy/E3DL-4-Ortho.jpg?dl=0

We will get a result of

E3DL-4-Ortho.jpg?dl=0 

which then you can remove the ?dl=0 using find and replace.

Now you can use the formula for any regular image resource address!


Sign in to leave a comment
Sales & Orders Discontinues Free Tier
No More Free BigCommerce Plugin for Google Shopping