Google Sheets - Use Images in your Spreadsheet

Learn the different ways to insert images into Google Sheets. They can sit on top of the cells or inside of a cell. If you use the IMAGE function, they can be controlled by a formula.
The icons used in the video are attributed as follows:
Mild icon
By Google
editor Li Chao
CC BY-SA 4.0
commons.wikime...
Hot icon
By Google
github.com/goo...
Apache License 2.0
commons.wikime...
Following in the spirit of sharing content with others, this video is Creative Commons so feel free to reuse and edit it as you wish. Please attribute my channel if you do.
The formula for the awesome weather calculator:
=IF(K33[*less than]=55,IMAGE("1st image URL"),IMAGE("2nd image URL"))
*Replace [less than] with the symbol. It can’t be used in a KZbin video description.
More information on the IMAGE function:
sheetshelp.com...
Learn how to collect data into your Google Sheet using Google Forms:
• Collect Data into Goog...
#googlesheets #IMAGEfunction #prolificoaktree

[@TravelTipsbyLaurie]

How do I see the image full screen once I have added image into cell?

[@ProlificOaktree]

You can't after that.

[@LookWhosBlogging]

Hi. I need help. So in your 2nd method where you insert an image into a cell.....is there a way to view it at full size later?? I can't seem to do it. HELP!!!

[@ProlificOaktree]

Try Insert, Image, Image over cells

[@basiccomponents]

thanks this was really useful!

[@ProlificOaktree]

Glad it was helpful!

[@Elliria_home]

Thank you. That's very helpful and, as always, you explained and demonstrated it perfectly.

[@ProlificOaktree]

Thank you, much appreciated!

[@mohdamar8237]

why response picture from google form when go to google sheet cannot see??

[@rabindrasasmal7445]

Is there any way we can upload the pictures in bulk ? Please help .

[@ProlificOaktree]

No there isn’t

[@ProductionDepartment-m6q]

I used impotrange to take data from one google sheet to the other. However, this function unable to import the images. Would you please advise a way to import images & data together from one sheet to the other?

[@ProlificOaktree]

I don't know of a way to do that. Best to use the IMAGE function and point it to a web address hosting the image.

[@dobur5036]

If I write a word inside a cell and I want that an image of that word (got from the first result of a google image search ) appear inside other one, what can I do?

[@carlperl412]

Thank for this tutorial sir! Can I call several images to only one cell?

[@nataliemckenzie2928]

How do you link a certain image to a data validation selection that is a list of items. So that when one of the items is selected, the image in the next column cell changes based on what is selected?

[@ProlificOaktree]

Probably with IF or IFS that takes the value of the data validation cell and returns the IMAGE function if it is a certain value.

[@FlyingJones]

how can insert multiple images into the sheet at the same time?

[@choirlivingwater9115]

Is it possible to add images as a note?

[@ProlificOaktree]

I don't think so.

[@reuvenlavie]

I added an image to the sheet using "paste" and saw the image in full on the sheet. After I left the sheet and came back to it, I saw only a square of the image and inside it a small icon of an image in the upper right corner of the square. The image disappearedץ How do I bring back the image I pasted to the sheet? Please help.

[@ProlificOaktree]

Put it in there through the Insert menu.

[@reuvenlavie]

@@ProlificOaktree Thanks very much...

[@voorachter3563]

Nice. I was wondering how can we have image *and text* in the same cell.

[@shivathedestination2847]

Any solution for this having same problem ?

[@katherinetroche8812]

@@shivathedestination2847I think by using the & symbol u can join image with text or try the join function but I am still learning so can’t give u exact formula. But I have seen it done with the “place image formula & text”. Try that hope it helps

[@gracemelody]

Do you know how I can keep the images from moving? Every time I open the spreadsheet I see that some images moved. Thanks in advance!

[@ProlificOaktree]

I've never heard of that. Maybe insert them into cells instead of on top. That should anchor them.

[@urNightmare13]

Same problem

[@jhone3241]

How to get URL for images, I used the drive link for my image but it is not working..... please help

[@ProlificOaktree]

Look through the comments on the linked website. I think there is discussion of it there.

[@MrMattsMedia]

I have a column with 100's of image URLs and I want to display a thumbnail of the image in the column next to it. Is there a formula for this?

[@ProlificOaktree]

Yeah, just use the IMAGE function and point it to the cell with the URL instead of typing the URL into the function.

[@MrMattsMedia]

@@ProlificOaktree but then I still have to manually enter the cell number 100's of times... Right? Sorry I'm a newbie..

[@ProlificOaktree]

@@MrMattsMedia No worries. Just click on the cell to make it active. There should be a blue square in the bottom right of the rectangle surrounding the cell. Double click that. It should auto fill down. Or just click and drag. Or copy past....all of those methods will adjust the formulas for each row.

[@MrMattsMedia]

Got it, thanks!

[@bharatsuryavanshi5578]

How do I view an inserted image

[@alexz4738]

does anyone know how you can click on a cell that's behind an image?

[@ProlificOaktree]

Type the cell reference into the rectangle just above and to the left of the grid. I think it's called the name manager.

[@JejeLaTortue64]

Hello guys, know that today it's need to swap the "," by a ";" to have the right syntaxe ! ;) Edit : only if you use the app' in a language with wich people write long number as "10 000" and not "10,000" !

[@ProlificOaktree]

Thanks for stopping by. This tip applies if you're in a country that uses a decimal for the thousands separator.

[@JejeLaTortue64]

@@ProlificOaktree ooooh ! Ok I understand :) my bad then

[@adamsteinfurth9315]

@@JejeLaTortue64 Hey, still helpful, just not for everyone!

[@JejeLaTortue64]

@@adamsteinfurth9315 True ! Thanks for the info' ;) I just edit my first message, is it right ?

Sir, can you make a video in making google forms in apps script

[@ProlificOaktree]

I don't know anything about apps script!

[@timelesstimesgoneby]

How to pull picture into google sheet with titles of same name

[@ProlificOaktree]

I don't know of a way to do that.

[@colinscrypto3307]

How you do get an image into a chart?

[@ProlificOaktree]

I doubt it's possible.