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

11 Comments on "Insert Images Into Google Spreadsheet Cells"

Notify of
avatar

Sort by:   newest | oldest | most voted
Chris Britton
Guest
Chris Britton
September 25, 2013 1:26 pm

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

Marcus
Guest
Marcus
August 27, 2013 11:29 am

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

Yaphet
Guest
Yaphet
August 23, 2013 1:49 am

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
August 26, 2013 1:34 am

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?

Rob
Guest
Rob
August 23, 2013 3:22 pm

Way Cool

Doug
Guest
Doug
April 8, 2015 4:21 pm

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?

joe
Guest
joe
May 19, 2016 11:34 pm

THANK YOU SO MUCH.

joe
Guest
joe
May 19, 2016 11:34 pm

THANK YOU SO MUCH.

Klaus
Guest
Klaus
August 24, 2013 9:50 am

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
August 26, 2013 1:30 am

what bit is the key?

Klaus
Guest
Klaus
August 30, 2013 9:23 am

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=

Greg
Guest
Greg
January 7, 2016 9:52 am
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 »
wpDiscuz
Loading Facebook Comments ...

REGISTER

FOR OUR WEBINAR TO GET
THE LATEST 451 RESEARCH REPORT


REGISTER HERE