Trying to figure out how to download and save images from Google Sheets has to have been one of the more frustrating things I've had to figure out for something that should be so simple. I spent hours looking at blog posts that wanted you to save to a zip file, or publish to the web, or export to Excel, or use a sketchy extension just to save an image! No need for any of that. Here is the simplest way to save an image from Google Sheets. You'll wonder why this isn't more prevalent.
A personalized Google Ad
Steps to Save/Download Images from Google Sheets
- Select the Image
- Hold the Shift key
- Right mouse click on the image
- Select "Save image as..."
Yeah, it's that simple!
See screenshot below for the amazingly easy function.
This method only works with images inserted "over cells" as opposed to directly "in cell". I suspect though most people use the former method to insert images anyway since the in cell method can be difficult to work with.
It only seems to work when using Google Chrome. Though if you're not using Chrome you probably need to reevaluate all your life choices.
So why was that so hard to do from the start? I'm not really sure but I suspect it has something to do with being in Google's Open Doc platform where the standard right-click opens up a purpose-built menu that's specific to the area you are selecting.
As to why all these other blog posts are recommending doing all these other crazy things, I don't know either.