Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Inserting Images into a Google Spreadsheet

Inserting Images into a Google Spreadsheet

If you want to insert an image into your Google Spreadsheet you will want to use the formula: =image(“url”)

Type the formula right into the cell in the spreadsheet.  Make sure you start with an equals sign. You will also need quotations around your URL.

My favorite trick is to use www.tinygrab.com and take a screenshot. The URL is automatically uploaded to my clipboard. (Note: make sure you choose private grabs in the tinygrab control panel) This makes is very quick to insert pictures into my spreadsheet if the image is not already on the web.

If you just use the formula =image(“URL”) then the image is shrunk down to fit in the cell. If you use =image(“URL”,2) the image is stretched to fit in the cell.  If you use =image(“URL”,3) the image is regular size so part of your picture might be cut off.  If you use =image(“URL”,4,height,width) you can set the number of pixels manually for the height and width of your image.

[gdocs type=’spreadsheet’ st_id=’0AiqrAI5UxSJNdHo3QWZzcjJOQ2ZZSU5xNmQyVkQxS1E’ wt_id=’od7′]

Click Here to view my sample spreadspreadsheet with images

[gdocs type=’spreadsheet’ st_id=’0AiqrAI5UxSJNdDBrZlZlRGlReGxKSEZ1OXRIQVdCU0E’ wt_id=’od6′]

1 thought on “Inserting Images into a Google Spreadsheet

  1. Hi there,

    Thanks for posting this! But I can’t get it to work in my spread sheet. I don’t know what I am doing wrong!

    This is my code: =image(“http://www.threadsofperu.com/images/eBay products/158.jpg”)

    And I am just getting a little blue icon with a question mark on it, like the image wont show for some reason, but it’s on my server, for sure.

    Any ideas?

    Thanks!!

    Angie

Leave a Reply

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

© 2024 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Mar 28th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for a way to create dynamic and interactive digital lessons. The Desmos platform is completely free and allows for any topic to be created or customized.

Exit this pop up by pressing escape or clicking anywhere off the pop up.