Watch Video – Insert an Image in Google Sheets
When working with data and collaborating with others, you may sometimes need to insert an image into a cell in Google Sheets.
These Google Sheets Images could be company logos or product images, etc.
You will be quite surprised to know that Google Sheets makes it really easy to add images in a cell quite easily. There are a couple of methods you can use to insert an image in Google, such as:
- Inserting images using the Google Sheets Image in Cell option
- Inserting images to Google Sheets using Drawing
- Adding an image to Google Sheets using the IMAGE Formula
- Inserting images in Google Sheets with Dynamic Image Lookup Functionality
- Adding images using Cellmage Builder API in App Scripts
In this tutorial, I will show you how you can insert images in Google Sheets using these methods.
Insert an Image Using the Google Sheets Image in Cell Option
Alongside the formula, Google Sheets insert image in a cell is the simplest option.
This option is available in the Insert option on the menu.
Below are the steps to insert a Google spreadsheet image in a cell:
- Select the cell in which you want to insert the image in a cell in Google Sheets
- Click the Insert option in the menu
- Hover the cursor over the Image option
- Click on the ‘Image in cell’ option
- In the Insert Image dialog box, select the option through which you want to insert the image. You can upload an image file, take a snapshot and insert that, use a URL to insert the image, use your albums/Google Drive to insert the image or search and then insert it. In this example, I will use the URL to insert the image
- Enter the image URL from which you want to insert the image in the cell
- Click on Select.
The above steps would insert the specified image in the selected cell.
Note that the image inserted using this method is placed in the cell, and it moves and sizes with the cell. Also, if you hide the cell or filter it, the image would stick to the cell and would also get hidden/filtered.
There is also an option to insert an image over the cells. This will place the image as an object over the cells, and you would have to manually fit it within a cell by sizing and moving it. Also, when you place an image over the cells, it won’t move and size with the cell. If you move the row/column or hide it, the image will not follow suit.
Insert Google Sheets Image Using Drawing
You can also add images in Google Sheets using the drawing option. This method is similar to the insert image method. The only difference is that there’s no option to add an image to a cell.
Here’s how to insert an image using the drawing option:
- Click Insert, then Drawing.
- Click the image icon, and an insert image window will appear.
- Select the method you wish to use to add the image. You can upload an image file from your device or drag and drop it into the space. You can also use your image URL or upload the image from your Google drive.
- In this case, we used “by URL”. Enter your image URL and click select if you are satisfied with your chosen image.
- Once you have uploaded your image file, you can edit it or add a text box or shapes to it.
- When you are done editing the image, click save and close.
The image will appear above the cells, and you can resize it and move it around the page. In case you add a text box to the image it will be part of the image and you can’t move it or edit it independently.
Advantages of Using Drawing
The advantage of this method is that you can edit your image in several different ways.
- You can add a border and change its shape and size
- You can add other shapes to the image, like arrows, circles, or lines
- You can add multiple images and make them into one image.
Anything you add to the image in the drawing edit tab will be part of the image once you click save and close. This means that if you resize or move your image, it will also affect everything else.
If you want to edit it, you can double-click the image, and it will take you back to the drawing edit tab.
How to Add an Image to Google Sheets Using the IMAGE Formula
Yes, there is a formula that you can use to add an image to a cell in Google Sheets.
Through the IMAGE formula, you can easily start the process of adding a picture in their preferred cell and changing its aspect ratio.
Syntax of the IMAGE function:
IMAGE (URL, [mode], [height], [width])
- URL: The link of the image should be included with an HTTPS or HTTP for it to work. It should also be surrounded by double quotes if you’re entering it as text only. You can even refer to a cell that has the URL of your image already.
- [mode] The mode is 1 by default, but you can switch it up. It is entirely up to the user to decide the image size which comes in four sizes.
- Size 1 simply just changes the size of the image to fit in easily inside the cell.
- Size 2 compresses or stretches your picture so that it can easily fit in the cell.
- Size 3 will crop the image so that it fits in the cell without changing the size of the image.
- Size 4 allows the user to choose the size (height/width) of the image.
- [height]: The height option simply indicates how long the picture should be to stay inside the cell and also be completely visible. If you want to use height, make sure your mode is 4.
- [width]: To use the width parameter, once again, your mode should be 4; otherwise, your whole image formula will result in an error. The width option lets the user define how wide the picture should be to stay completely visible in the cell.
Now that you know the syntax of the image function, let’s see some examples of how you can use it to insert an image in a cell in Google Sheets.
In this entire tutorial, I will be using the following image URL of the logo of Google to show you how to use the IMAGE function in Google Sheets:
This image URL has been taken from the homepage of Google (source: https://www.Google.com/)
Now let’s have a look at some examples.
To insert an image in a cell using the above URL, I can use the below formula in Google Sheets:
The above formula gives the result as shown below:
Since I have not provided any of the optional arguments, it will insert the image and fit the image into the cell.
Now let’s go through all the modes you can use in the IMAGE function and how it will impact the result.
When Mode is 1 – Image Resizes to Fit the Cell Size
= IMAGE (URL,1, [HEIGHT], [WIDTH])
The result you get when the mode is specified as 1 would be the same as you get when you don’t specify any mode value.
In this mode, the image is resized to fit the cell. And if you change the size of the cell, the image would also resize.
When Mode is 2 – Image Stretches to Fit the cell
= IMAGE (URL, 2)
When you specify the mode as 2, the image would stretch (in height as well as width) to fit the cell (as shown below).
In this case, the aspect ratio is not maintained and you may end up getting an image that completely fits the cell.
When Mode is 3 – Image Displayed at Original Size
= IMAGE (URL,3)
When you specify the mode as 3, the image would be displayed in its original size.
In case the cell height/width are not large enough to accommodate the image, the image would be cropped. And in case the size of the cell is larger than the image size, you will have empty white spaces in the cell (around the image).
When Mode is 4 – Displays the image with the specified Height/Width
= IMAGE (URL,4, [HEIGHT], [WIDTH])
When you specify the mode as 4, you also need to specify the height and width of the image in the cell (in pixels). For example, the below formula will insert the Google logo in a cell and make the size as 50 as height and 50 as width.
You can repeat this process in other cells using a repeat formula. We have a tutorial for you on 6 ways to use the repeat formula.
Benefits of Using the IMAGE Function
There are a couple of benefits of using the IMAGE function over inserting the image using the ‘Image in Cell’ functionality:
- The IMAGE function allows a lot more flexibility than the ‘Image in cell’ option. You can choose from four different modes that allow you to choose whether you want the image to fit perfectly, stretch and fill the cell, or remain at a specific aspect ratio.
- IMAGE function can take a cell reference as the input (where the cell reference has the URL to the image). This makes it dynamic, meaning that if you change the URL in the reference cell, the image will automatically update. Also, if you have 10 image URLs in a column, you can easily use the IMAGE function to get the images quickly for all 10 image links.
How to Insert Image in Google Sheets With Dynamic Image Lookup Functionality
Since the IMAGE function can easily update when you change the image URL, you can use this to create an image lookup (picture lookup) functionality in Google Sheets.
Something as shown below:
In the above example, as soon as I select a company name, that company’s logo automatically updates in the adjacent cell. This is made possible using the IMAGE function (along with the VLOOKUP function).
Below are the steps I have used to create this picture lookup in Google Sheets:
- Have the company names and the image links in a sheet in Google Sheets. This could be on the same sheet where you want the picture lookup or could be on a different sheet. In this example, I have these names and logos in a sheet named – ‘Image Links’
- Create a drop-down list in the sheet where you want the picture lookup to work. For this drop-down, use the company names so that these same names appear in the drop-down.
- In the adjacent cell, use the following formula to fetch the URL for the company logo. This fetched URL is used in the IMAGE function to insert the image of that fetched URL. Since this is connected to the drop-down value, when you change the value, the logo also changes:
This could be useful when you’re creating a dashboard and you want an image to appear based on the selection from the drop-down.
If you have a large document and want to add images you can jump to cells to do so.
Related Reading: Save a Chart as an Image in Google Sheets
How to Insert Google Sheets Images Using Cellmage Builder
This last method is for the tech nerds who like to code and use Google App Script to automate tasks in Google Sheets. Previously you could only add an image over the cells in scripts, but with Cellmage, you can insert images in a cell.
- On your Google Sheets, go to extension and click App Scripts
- This will take you to a new window for APP Script with a file saved as code.gs. You can erase the function there.
- First, we are going to create a menu to automatically add the image. Create an onOpen function
- Name your menu in the brackets, in this case, I named mine “Image Automate”
- Next, addItem Insert Image and add toUi.
- Save the function, then click Run. Here’s what the code should look like:
- If you go back to your spreadsheet, you will find the new menu “Image Automate”
- Now we will add a new function for inserting the cell image.
- We will then create a constant sheet.
- We need to tell the script where to find the image url.
- After that we need to tell the script which cell or cells to put the image in.
- Now we need to build the value for the image URL.
- Finally, we set the image range to tell the image to go to the right cell.
This is the final script you should have:
- Now just get your image URL and paste it into cell A1,
- Once you’re done, save the function then run it. You might be asked for authorization in which case you can just allow it.
- Go back to your Google Sheets and click the menu Image Automate, then click Insert image.
Your image should appear in the cell you designated it to.
The Cellmage API is a fairly new feature in App Script that lets you insert images into cells and also lets you automate the process.
Frequently Asked Questions
Can I Insert an Image in a Spreadsheet Cell? Can You Put Images in Google Sheets?
You can use any of the methods we mentioned to do this.
- Through the insert menu
- With the IMAGE formula
- With dynamic lookup and the IMAGE formula
How Do I Lock an Image in Google Sheets?
You have to use the same method as locking a cell for any other reason. Right-click the cell and use the Protect range option.
How Do I Make an Image a Link in Google Sheets?
- Click on the image in the cell, the Image option box should pop up
- Click Change link and paste in the URL you want to direct to
How Do I View an Image in a Cell?
To view a full-size image from a cell, you can right-click and then select Put image over cells. When you’re done, use the undo shortcut (Ctrl+z) to return it back to the way it was.
Can You Paste Images Into Google Sheets?
Yes, but not just by using Ctrl+V. You have to Insert the image instead.
Can You Put an Image Behind Cells in Google Sheets?
There are only two options for image placement in Google Sheets; to place the image in the cell or over the cell. You cannot put an image behind a cell in Google Sheets.
Can I Have an Image and Text in a Cell in Google Sheets?
No, once you put an image in a cell in Google Sheets, you can’t add text to that cell. You can add a text box to an image that is not in a cell in Google Sheets using the drawing method. There are also other ways to insert a text box in Google Sheets.
The Bottom Line
Whichever method you use for inserting Google Sheets images, you should now easily be able to place images into your spreadsheet with ease. If you found this tutorial helpful,
You may also like the following Google Sheets tutorials: