IMAGE Function – Google Sheets

The IMAGE function lets a spreadsheet user insert a picture file into a cell. You must specify the source of the picture file as a URL.



  • url – The location of the picture on the web – (“”). You must either use quotation marks around the URL or put the address in another cell and reference it.
  • [mode] – Optional size specification.
    • 1 – Resize to fit the cell as much as possible while retaining the aspect ratio so the picture does not distort.
    • 2 – Fit the entire cell. This will disregard the aspect ratio.
    • 3 – Maintains original size even if it gets cropped.
    • 4 – Custom see height and width below
  • [height] – If you specify 4 for custom mode, use this for the height.
  • [width] – If you specify 4 for custom mode, use this for the width.

Video Tutorial


#N/A – The function does not have enough arguments. This error can occur because you used option #4 but did not specify height and width arguments.


These examples use the same image but scale it with different techniques. Note that if you specify 4 for custom scaling, you will receive an error if you omit the dimensions.

Different images output by differing IMAGE functions.
IMAGE Examples

Live Examples in Sheets

Go to this spreadsheet for examples of the IMAGE function shown above that you can study and use anywhere you would like.

19 thoughts on “IMAGE Function – Google Sheets”

  1. Based on a number in a cell (0-9) I want to display a particular image in another cell.
    Your example only shows if a number is higher or lower than a particular number.
    Can you expand beyond two image location references to ten in my case?
    Any help would be much appreciated

  2. Hello,

    I have images saved on my google drive that I’d like to use an =IF(A2>=B2,IMAGE(“URL”),””) function on a google sheet.

    Is there a way I can link this cell to images saved in google drive? Or how would I go about linking these custom images?

    Thank you!

    • I doubt it would work or if it did, it may stop working later. If you want to try it, maybe try the share functionality, get shareable link, make it public, and let us know how it goes.

    • I tried to link to Google Drive, Dropbox, and Box images. Nothing worked. So I published them to a Blogger blog and got the URL from there.

  3. Hi, I would like to know if the image formula still working on… my cell with this formula is about a half has no picture in it… but the url is good if I just type it in chrome, thanks!

      • Does it download and put it in the sheets or does it fetch the image from the URL everytime you open the sheet? I’m using an API to get an image but the image would change depending upon when I make the request

  4. What if my URL consists of https://“blabla”.png ?
    This does not work with the =IMAGE formula since I need to put “” inside the parenthesis which then interferes with the URL if the URL already has “”.
    Help please.

  5. I’m trying to get my images to display in Sheets from a link posted in another cell. For example, I have an image link in C1 (http://imagelink.png), and am trying to display it in D1 using the =image function. Do you know how I could do this?

    • Not sure. Maybe integrate the TEXT function somehow. I’m assuming you tried a simple cell reference? Like typing =C1 in to D1.

  6. Can you have a drop down reference in the URL of the IMAGE function?

    =IF($I6>0,IMAGE(“”, 3),””)

    In the example above I would like to have the part that says AIK to be pulled from the drop down so when I choose another team it change the images to match the new team selected.

    i have an appsheet APPLICATION with a column for signature, when i try it, the signatures appear as IMAGE url in google sheets. HOW DO I DISPLAY THESE IMAGES IN GOOGLE SHEETS.???????

  8. Hello, I am attempting to use forms to create an inventory with images, but so far, I am only able to add the link for each image. I have my images divided into separate folders on my google drive. Is it possible to convert that link to fill the cell after it is uploaded to sheets?


Leave a Comment