How to Insert Images in Google Sheets

                     How to Insert Images in Google Sheets
               



Tópico:
                     How to Insert Images in Google Sheets
               
Categoria: Tutoriais | FreeCodeCamp Premium
Idioma Principal: Português (Conteúdo de Tecnologia)

Conteúdo do Tutorial / Guia Passo a Passo:
-------------------------------------------------------------------------
Google Sheets is widely used for tracking data, managing inventories, building product catalogs, and creating dashboards. In many of these use cases, adding images directly into a spreadsheet makes the data easier to understand and work with.

Whether you're displaying product photos, marketing assets, or property listings, Google Sheets provides several ways to insert and display images.

In this tutorial, you'll learn how to:

• Insert images using the Insert menu in Google Sheets

• Display images from a URL using the

Código Selecionar Expandir

IMAGE()function

• Work with multiple images stored in Google Drive

Table of Contents

• Understanding How Images Work in Google Sheets

• Inserting Images Using the Insert Menu in Google Sheets

• Inserting Images in Google Sheets Using the IMAGE Function

• Inserting Multiple Images from URLs

• Best Practices

• Working with Multiple Images Stored in Google Drive

• Which Method Should You Choose?

• Conclusion

Understanding How Images Work in Google Sheets

The way an image is inserted in Google Sheets determines how it behaves when you sort data, resize rows, or build automated workflows.

This becomes particularly important when working with product catalogs, asset trackers, or spreadsheets that are connected to Google Drive workflows, such as listing files from Drive into Google Sheets or uploading files from Google Sheets into Google Drive.

Before inserting images, it's important to understand the two image placement options available in Google Sheets:

Images Inside Cells:

Images become part of the cell itself and behave like spreadsheet data when rows and columns are moved, resized, filtered, or sorted.

The following image shows how the image inserted inside Google Sheets cell looks like:

Benefits of inserting an image inside a cell include:

• Moves with rows and columns

• Resizes when cells are resized

• Sorts correctly with spreadsheet data

• Ideal for inventories and catalogs

Images Over Cells:

Images remain independent of the underlying cells and float above the spreadsheet, allowing them to be freely positioned and resized without affecting spreadsheet data.

The following image shows how the image inserted over the Google Sheets cell looks:

Benefits include:

• Freely position images anywhere on the sheet

• Useful for logos and visual elements

• Better suited for dashboards and reports

For most spreadsheet-based workflows, Images inside Cells is usually the preferred option.

If you're working with a large number of images stored in Google Drive, manually collecting image URLs can quickly become time-consuming.

Tools such as Drive Explorer Pro can help automate this process by listing files and generating image URLs directly in Google Sheets. It can also include additional file metadata such as image previews, file names, download URLs, sharing permissions, and other file details, making it easier to organize, manage files at scale as shown in the following image:

Next, you'll see how to insert images inside cell or over a cell.

Inserting Images Using the Insert Menu in Google Sheets

The Insert menu is the simplest way to add a small number of images to Google Sheets. Using this method, you can insert images either inside cells, where they behave like spreadsheet data, or over cells, where they float above the worksheet.

Image in Cell

• Select the destination cell.

• Click

... [O tutorial continua no link abaixo] ...