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′]

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

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.

%d