How to embed Google Drive images in Google Sheets

embed google drive images in sheets

How do you embed an image from Google Drive into a Google Sheets Spreadsheet?

You would have thought it would be a simple click of a button to embed an image stored on Google Drive into a Google Sheets spreadsheet. As you no doubt already know, it ain’t so. That’s why you’re here, right?

Don’t worry, it’s not terribly difficult. All it takes is one line of code and you’ll be able to display any Google Drive image inside any cell of a Google Sheets spreadsheet.

And here is that line of code:

=IMAGE(SUBSTITUTE("shareable_link","https://drive.google.com/open?id=","https://docs.google.com/uc?export=download&id="))

Use the formula above and replace “shareable_link” with the shareable link from your desired image.

And that’s it! Pretty painless, eh?

Now you too can easily embed Google Drive images into any Google Sheets spreadsheet.

Thanks for reading! If you found this page useful, please share it!



17 Comments

  1. Hi Lee,

    QQ- I use this method as well and it works great but, I had everything perfect on Friday the images were displaying and then this morning I opened my sheet and the URLs were still there but the images were not. Super odd. Do you know why this might happen? I had to re enter everything to get it back to normal.

    Thank you!

    1. Hmm, that is weird. I wonder if it timed out and the browser cached it or something. Either that or something changed in your Google Drive ecosystem that changed the shareable link (it is autogenerated after all), perhaps.

  2. I think there are several ways for this trick/hack to fail. The first is if you’re using a G Suite domain version of Sheets and the Admin has locked down your ability to share outside of your domain. So, some schools or businesses might have a problem using this. The primary requirement for images in cells to work is that the image is available on the web without a sign-in credential. If you can’t post images publicly, this method won’t work.

  3. I am unable to get this to work. I have tried it with both the formula in the cell and using the cell reference to another cell with the shareable link. This is a free Google account I use outside of my company’s domain so I can use the Google Suite. The formula is posted in cell if I click on it, but no picture appears. I would greatly appreciate any help you can give me on this.

        1. Nope. You can keep the spreadsheet as locked down as you like. The =IMAGE() function will allow you to use any image that is publicly viewable from the web.

          1. Ok, I’m 50% there. I cleared my cookies/history and tried from another computer. I can do it with pasting image share url directly to the pic cell.
            The reference formula still is giving me a run for my money. It has to be something so simple..
            =IMAGE(SUBSTITUTE(“F5″,”https://drive.google.com/open?id=”,”https://docs.google.com/uc?export=download&id=”))

          2. Try taking the quotes off “F5”:
            =IMAGE(SUBSTITUTE(F5,”https://drive.google.com/open?id=”,”https://docs.google.com/uc?export=download&id=”))

  4. I am trying
    =IMAGE(SUBSTITUTE(“https://drive.google.com/file/d/1oxHwthFchnGE9gk0uAAp8NeGkUsKcY1A/view?usp=sharing”,”https://drive.google.com/open?id=”,”https://docs.google.com/uc?export=download&id=”))
    with a totally public image and from my personal account but no photo is showing, can anyone help?

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.