If you work in IT, learn how BetterCloud’s Unified SaaS Management platform can help you manage G Suite and other applications. Also, learn how you can 10x your G Suite productivity

If you’re a frequent user of Google Spreadsheets, you probably already know that you can insert images from the Insert Image menu option. This doesn’t actually insert images into a cell, which is often what people are trying to do.

The Insert Image menu option actually places an image on top of a Spreadsheet, rather than inside a cell. So if you’re trying to insert several images into a Spreadsheet in some sort of order this isn’t terribly helpful.

Using the =IMAGE Spreadsheet function allows us to insert an image inside a cell, using the image’s URL. This makes it really easy to insert images into a particular cell, and will get larger or smaller depending on the size of the cell (while maintaining the image’s aspect ratio).

There are actually several variations of this function that give you even more functionality:

  • =IMAGE(“URL”) – image retains aspect ratio while increasing / decreasing the cell size
  • =IMAGE(“URL”,2) – image stretches to fit all edges of the cell
  • =IMAGE(“URL”,3) – image retains its original size
  • =IMAGE(“URL”,4,50,50) – set the size of the image by replacing 50,50 with desired dimensions

Click here to watch this video on YouTube.

Shares

UP NEXT: How to Change the Paper Size in Word

Leave a Reply

25 Comments on "Insert Images Into Google Spreadsheet Cells"

Notify of
avatar
Sort by:   newest | oldest | most voted
Chris Britton
Guest
Chris Britton

Is there a way to insert an image into the cell that is not hosted online somewhere, i.e.- a screenshot I’ve taken.

Alexia
Guest
Alexia

Did you ever figure this out? I’m trying to do the same thing.

Bug
Guest
Bug

Also wanted to know.
I think Google Drive works, but even so, directly from the PC would be nice

Shortreed
Guest
Shortreed

Tried google drive, google photo and google sites to give the image a url, but no success.

A H
Guest
A H

Place the image in a Google photos album and set the album to public.

Yaphet
Guest
Yaphet

Does it matter where the source image is from? I’ve tried pasting from dropbox and it get “no image found at the url”. I tried pasting from google drive and i get “invalid url”.

Ed
Guest
Ed

I’ve tried combinations from Google Drive URL, from public access, to anyone with a link, with no success. How do I get the correct Google Drive URL?

Kathi SMith
Guest
Kathi SMith

I can not get this to work. I have photos in Google Photos – using the URL from there and nothing shows up.
=image(“https://goo.gl/photos/t9M3B4kFV3aNoSidA”)
any suggestions?
Also tried the long url – but that too did not work.

Kathi SMith
Guest
Kathi SMith

I can not get this to work. I have photos in Google Photos – using the URL from there and nothing shows up.
=image(“https://goo.gl/photos/t9M3B4kFV3aNoSidA”)
any suggestions?
Also tried the long url – but that too did not work.

Klaus
Guest
Klaus

Also got an error inserting an image from Google Drive. After some Googling found this ‘trick’ from Nicolas Cheetham which works: copy the key from the Google Drive url and append https://docs.google.com/uc?export=download&id=
Google should really fix this so that their own urls also work 😉

Ed
Guest
Ed

what bit is the key?

Klaus
Guest
Klaus

Ed if you open the image in your Google Drive the key is between / / before edit at the end e.g. /ajlkajcdcsdckjsdch/edit so ajlkajcdcsdckjsdch would be the key to insert at id=

evatar
Guest
evatar

Is his even English? All we’re trying to achieve is something SIMPLE that both Excel and Numbers can do easily. And the ‘answer’ is for Google Sheets is to jump through a wormhole while juggling. Ugh.

Marcus
Guest
Marcus

I can’t get it to work. Eveything I tried lead to a Parse Error.

Annabananas
Guest
Annabananas

But what if it’s an image from your desktop and you don’t have a URL??

Annabananas
Guest
Annabananas

I have uploaded the photo I need to insert to a folder in my google drive. I then clicked on that pic and copied the URL in the search bar. I then typed =IMAGE(“URL”) into a cell. The URL turned green but when I hit “enter” the cell does not have a pic in it… I really need this to work asap. Any solutions?

Val
Guest
Val

I have the same issue. Its looks like its accepting my URL but no image is appearing in the cell. I’ve checked google sheets through various servers (Firefox, iOS, Safari) and nothing. Is it possible this is an Apple related issue? If, so google needs get their sh*T together.

Cosmo
Guest
Cosmo

If you copy and paste =IMAGE(“URL”) directly from this webpage to the spreadsheet, it won’t recognize the specific open and closed quotation marks that this page uses. You have to use regular ” marks like =IMAGE(“URL”). Pretty frustrating detail to overlook for a website trying to help people who are new to something if you ask me.

JonathanTest SantiagoTest
Guest
JonathanTest SantiagoTest

That’s it! Thanks you!

Rob
Guest
Rob

Way Cool

Doug
Guest
Doug

Does any one know of a way to put a variable into the image string so it can reference a cell to change the place to lookup the image?

Shortreed
Guest
Shortreed

you could use a vlookup put the number in the cell in front of the image .

Greg
Guest
Greg
Hi Gooru, Great information – thanks for the tip. I have a related question that I hope you can answer. If I want to insert an image inside a cell, how can I assign a script to the newly inserted image? What I’d like to do is create a table of contents tab inside a Google Sheet that has many other tabs. On the table of contents, I’d love to have inserted images that act as buttons to navigate to these different tabs. I can “assign script” to images that have been inserted through the menu toolbar (e.g., Insert >… Read more »
joe
Guest
joe

THANK YOU SO MUCH.

joe
Guest
joe

THANK YOU SO MUCH.

Erica
Guest
Erica

Hey! This worked very well up until I noticed that everyone else sharing this spreadsheet with me couldn’t see the images! They are in a public folder on Google Docs. Do you have any recommendations?

NEETA
Guest
NEETA

how to insert the images from google drive to cells. Please help

wpDiscuz