Using CSV to bulk upload images

Site URL: https://dressupandparty.squarespace.com

Hi,

I'm fairly new here but here goes, hope you can help!

I am setting up a store which has approx 3000 products in. I have a large spreadsheet of every single product in, and from the supplier, three image files for each product. I am trying to find a way to bulk upload the images for the products in a far quicker way than copying and pasting 3000 links into the spreadsheet.

For example: Image file name is 12345.jpg currently stored locally, but I need to host it to be a link.

I need a link that is for example www.website.com/anything/12345.jpg. In my spreadsheet I can format the cell to have "www.website.com/anything/*TEXT*" which means I could process ALL links in the sheet at once, as long as they all follow that formula with the image filename at the very end.

Is there an easier way to do this? I have found a website that works in a similar way, but when I tried it it wouldn't work properly. Dropbox for example adds a jumble of characters in the web address so this won't do. I'm really struggling to figure it out! I've tried google drive, dropbox, flickr, even squarespace's own static addresses but these still add a jumble of characters!

Please let me know if you can help!

Thanks,

Brendan

I have solved this. A friend has hosted the images himself on a wordpress site. If I find out more I will post it!