Among the most popular spreadsheet apps, Google Sheets is a free, web-based application that lets you do everything a typical spreadsheet app should be able to do. Depending on how you utilize it, it is an invaluable tool for many professions. One useful way to utilize Google sheets is to add some images like expense-tracking receipts, icon libraries, brand resources, and other inventory images.
Whether you’re a beginner or have been struggling with Google Sheets, this tutorial explores the different options for inserting images. We’ll also discuss the advantages and limitations of each method.
Add Images Using The Insert Menu in Google Sheets
For your first option, you can insert images from your computer into Google Sheets by using the Insert > Image menu in Google Sheets. Choose the Insert image over cells option and select the image you want to insert.
By using this approach, you can place the image wherever you want within the Google Sheet. The image may be readily resized in this manner by sliding the blue handles, and for improved accessibility, you can add an Alt text.
The ability to attach a Google Script to an image and have it run when someone clicks on it is another benefit of this strategy. For instance, you might add a button to the Google Sheet and give it a script that would immediately download the sheet to your computer as a PDF file.
Add Images Using The Image Function
To add an image to a cell, highlight the cell and click F2 to enter the formula mode. Next, enter the formula =IMAGE(“URL”) where URL is the public web address of that image.
This approach is a little more complicated, but it also provides an extra level of customization by allowing you to select the image’s internal cell size. Google Sheets, by default, will scale the image to fit inside the area of the selected cell but you can easily change the default settings by adding another parameter to the IMAGE function.
It’s important to keep in mind that Google Sheets prohibits the use of Google Drive links with the Image feature. it should be noted that SVG-format images will not function with this method.
Add Images Using FileDrop
As compared to the first two methods provided above, this third method provides more opportunities for productivity and convenience. You can easily add images in Google Sheets by using an add-on called FileDrop. It is a free Google Sheets add-on that allows you to drag and drop files such as images into a spreadsheet cell with automatic linking and add them to Google Drive.
To do this, you just have to install the FileDrop Google Sheets add-on. Once installed, you can click on Extensions Menu and select to start FileDrop. On the FileDrop menu on the right side, you can either choose a file from your computer or directly drag and drop the image you need.
Then you can now drag and drop files in the spreadsheet cell. Files uploaded with FileDrop go straight to your Google Drive and are automatically added with the name in your spreadsheet cell. Then it’s linked to the file itself for easy access.
If you wish to upload bulk files and add images into your cells in a streamlined manner, this could be a better option. This approach is also very easy to use.
Conclusion on How to Put Images in Google Sheets
Using the right tools and understanding the different methods can make attaching images in Google Sheets a breeze. If you want to know more about how to maximize your use of Google Sheets, check out FileDrop today!
Get Our Latest Articles
Subscribe to our newsletter below to get amazing new Google Sheets articles, but also tips and tricks.