Insert images into Google Spreadsheet cells

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

Comments (8) Write a comment

  1. 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”.

    Reply

    • 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?

      Reply

      • 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=

        Reply

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

    Reply

Leave a Reply

Required fields are marked *.