Trying to embed and display hyperlink images within spreadsheet

Hi there,

I am new here and trying to make a number of improvements on a master price list table to be sent to customers.

Right now it is just text and I want to display product photos for each item but I do not want to embed them in the file itself since there are over 1k products. I want to put a hyperlink either on the model # or as a separate field in the same row.

All the images are hosted on my server but I want the images to display automatically as a hover/comment box, pop-up that can be shown/hidden, or even require the user to click the model to display the image but still have it displayed on the sheet as opposed to opening a browser which is my least favorite option but I know how to do that. I don't want it to be permanently displayed on each row since it would make all the row heights way too big and the images are not all the same size. Current row height should remain around 12.75 to fit the text.

As a secondary function, i am exporting this sheet into .csv and will need to have the full url of the image available for output into the csv in it's own field

Let me know if you can help or if you require additional information.

Thanks