How to display Image from URL in Google Sheets? (and apply it to multiple rows)

Question

So I created a list of members in Google Sheets, each member having a profile image, name, location, etc.

I exported this list from import.io, a data extraction tool. The only problem is that when I export it, I get the profile image url for each member, instead of getting the image itself as a thumbnail.

Someone asked a similar question here. I tried using the =image("url") function and it worked, I can see the image.

What I want is a simple way of applying this function to the 200 cells I have that include a link to an image.

Any idea on how this can be achieved?

Thanks

Answer 1

=image() works with Arrayformula so if your image urls are in rows, starting in cell A1, ending in cell A2, formula in B1 would be =Arrayformula(image(A1:A2)).