Saving Images from Google Docs

When edtech rockstar Matt Miller says “Hey Jake, you should make this into an #EduGIF!” you listen.  He was right, too.  It was an awesome tip.

It was a pickle that I had been in before, but I had never known the solution.  You’re preparing something–a lesson, a blog post, whatever–and you need a picture.  Not just any picture, but a picture that you’ve used before.  It’s in that one Google Doc, but you can’t get to the picture from anywhere else.  So, you right-click on it in that Google Doc . . . but there’s no Save Image option.

There are a handful of ways that you can get that image saved as a file on your computer, but the one that Matt sent to me is pretty awesome.  It’s just a few steps and super easy.  And it’s even more convenient if you have multiple images that you need from the same Google Doc.  So, let’s get to it – first an animated #EduGIF and then the steps for those of you who like to read words.

Save Images from Docs Animation

  1. Open the Google Doc
  2. Select File > Download As > Web Page (.html, zipped)
  3. Locate the saved file on your computer
  4. Unzip the file (on my Mac, all that I have to do is double-click)
  5. A new folder should have been created. Inside of that folder will be all of the images that are in that Google Doc.  Feel free to move your image out of there and delete the other files as well as the zipped file.

Dropdown List in Google Sheets

Did you know that you could add a dropdown list of options to a cell (or cells, plural) in Google Sheets?  This is nice for creating something like a “multiple-choice option,” but is also nice when you want to force your collaborators (or yourself!) to select from a specific list of choices.

It can be especially useful if you have formulas acting on that cell.  For example, if you were keeping track of a budget and wanted different things (i.e., adding versus subtracting) to happen if a row was marked as a deposit, purchase or interest.

Here’s an animated GIF about how to do it followed, as usual, by a list of the steps.

Sheets Dropdown Animation

Step 1: Click on the cell or cells that you plan to add the dropdown list to
Step 2: Right-click & select Data Validation
Step 3: In the dropdown by Criteria, select List of Items
Step 4: Type your options into the box, separating them with commas (I tend to alphabetize them)
Step 5: Click Save.