Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Insert a Google Drawing into a Google Spreadsheet

Insert a Google Drawing into a Google Spreadsheet

I was helping my husband type up a worksheet template into a Google Spreadsheet. The middle section of the worksheet asked the students to “Write a paragraph or do a story map.” The write a paragraph part is easy, but how would students draw something in this digital space?

Google Draw

Obviously if you’re going to draw you should use Google Draw. Students can go to their Google Drive (http://drive.google.com) and create their story map. Now, they just have to get that drawing into the spreadsheet.

First they will need to go to File->Publish to the web

Choose to “Start publishing.”

Once the document is published, copy the “Document link”

 Back to the Spreadsheet

To insert the Google Draw image into the spreadsheet, students will want to use the formula =image(“URL”). Notice the URL is in quotations marks. The URL is the document link copied from Google Draw.

By default, the size of the image will fit the cell. In the graphic organizer I was typing up there was a large box for the student to draw their picture.  To accomplish this in a spreadsheet, highlight a block of cells and click on the merge cells icon in the toolbar.

Using the =image(“URL”) formula in the large merged cell would allow for the students drawing to fit right in the specified space for the drawing.

Optionally, the student can use =image(“URL”,2) or =image(“URL”,3).  The =image(“URL”,2) stretches the image to fit the space. This worked well when I had a horizontal image in a vertical space on the spreadsheet. However, the image is stretched and distorted. The =image(“URL”,3) will leave the image the same size as the student drew it (probably 8.5×11). If the image is larger than the provided cell part of the image would be truncated.

Other methods

Within Google spreadsheet, in the insert menu, is the option to insert a drawing. This creates a canvas right in Google Spreadsheet that the student can draw on. This drawing is free floating and not embedded within the spreadsheet.

Pros and Cons

Creating graphic organizers on a Google Spreadsheet is just a substitution for what can be done on paper. This helps with my goal to use at most one ream of paper this year, but it is not a radical departure from the current teaching practice.

An advantage is that the Google Drawing and the spreadsheet are collaborative.

By using the =image(“URL”) instead of insert drawing, the image fits exactly in the correct space rather than covering up content. A floating drawing can get in the way.

Obviously it is extra steps to create a Google Drawing and bring it into the spreadsheet and you have to teach the students the formula. Although, helping students to learn formulas has it’s advantages too.

2 thoughts on “Insert a Google Drawing into a Google Spreadsheet

  1. Hi Alice,

    I’m having some trouble finding a solution for my problem, I hope you can help me. It’s actually the opposite of what you describe here. I made a Google Drawing that represents a customer journey. The information in that customer journey map is based on information that I collected in Google Spreadsheets. Now I wanted to use =IMPORTRANGE(“…”,”…”) in Google Drawings to import the most important numbers from the sheet. It works perfectly fine in any other Spreadsheet, but I can’t seem to get it right in Drawings, even though I insterted a table already. I started wondering whether it’s possible at all to get what I want or if there’s another way for me to get a similar effect. It might also work in Docs, but I’ve encountered the same issue as with Drawings. Maybe I’m missing something.

    Kind regards,

    1. Unfortunately you can not import data into a Google Drawing. You can insert drawings into Google Sheets but they are also not dynamic. The charts you create in Google Sheets are dynamic to the data.

Leave a Reply

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

© 2024 All Rights Reserved.