In this tutorial, you will learn how to save an image from google sheets.
In addition to text, numbers and calculations, Google Sheets can also be used to store images, such as logos, graphics or product photos. While it’s always a good idea to keep a copy of images stored somewhere other than inside a Google Sheet, sometimes you may find you don’t know the location of the original image and need to download the image directly from Google Sheets. If you’ve ever tried to do this, you’ve probably been frustrated by the lack of an option to download the image in the right-click menu for Google Sheets images, but fortunately there’s still a way to download those images.
Save Images Floating Over Cells
The easiest images to save are Images added floating over cells. You can identify these images because they float over the cells and can be moved around independent of the cells
Here’s how how to save these images:
Select the image you want to save, then hold down SHIFT on your keyboard and right-click on the image
This will bring up the standard browser right-click context menu you’re familiar with from browsing the internet. Choose the Save Image As… option, or whatever you’d typically choose to save an image from the internet
If prompted to do so, choose a name and location to save the image. Otherwise it will be stored in your browser’s default downloads location, based on your preferences
Save Images in Cells
For images saved in cells, the above method doesn’t work, but it’s easy to put these images over the cells so the above method works for them as well. Here’s how:
Right-click on the image (do not hold down shift this time) and hover over the Image submenu, then choose Put Image Over Cells
The image will be put over the cells and can be saved using the method for floating images above
Note that depending on the size of the original image, the image may get very large when it’s put over the cells. If you intend to leave it over the cells, you can resize it by adjusting the blue drag handles at the corners of the selected image. Otherwise, hit CTRL+Z on your keyboard to undo
Save IMAGE() Formula Images
The last type of Google Sheet images are ones added to the spreadsheet using the IMAGE() function. These are very easy to download because the formula itself contains the URL of the image. To download these images, follow these steps:
Select the cell containing the image and look at the formula in the formula bar. You should see the IMAGE() function, containing a URL wrapped in quotes
Copy the URL and paste it into your browser navigation bar
When the image loads, right-click on it and save it as
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to save an image from google sheets. Want more? Check out all the Google Sheets Tutorials.