How to Insert Image Inside a Cell in Google Sheets (3 Methods)

Images in Google Sheets can float above the grid instead of staying inside cells. When you sort or filter the sheet, floating images stay in place while rows move. For example, a product photo can end up next to the wrong item.

Inserting images inside cells fixes this. An in-cell image stays attached to its cell, so the image moves with its row and stays aligned with the correct data.

In this tutorial, you will learn three methods to insert an image inside a cell in Google Sheets, along with when to use each one.

Table of Contents

Video Tutorial

Inserting Images Using the Insert Menu

You can place an image into a cell using the built-in Insert menu. This is the native Google Sheets tool and does not require any installation or formulas.

When to use: Insert a single image into one cell without any setup.

1. Select the cell where you want to insert the image.
2. Click Insert in the top menu bar.
3. Select Image.
4. Click Insert image in cell.
5. Select the tab for where your image is stored:

• Upload for a file on your computer.
• Google Drive for a file already in Drive.
• Link for a public image URL.
• Photos for Google Photos.

After you select a tab, its options appear below.

6. Browse or search for your image in the selected panel.
7. Select the image file you want to use.
8. Click Insert.

Note: Most common image formats work, including JPEG, PNG, GIF, and BMP. If your image does not appear, it may be a WebP or SVG file, use the IMAGE function with a public URL instead.

Result

The image appears inside the cell, scaled to fit the current cell size. The image stays attached to the cell. When you sort or filter the sheet, the image moves with its row and stays aligned with the correct data.

If the image looks too small, resize the row or column: drag the row border down or the column border right until the image is clearly visible.

For more details, refer to the official Google Sheets documentation.

Common mistake: Copying and pasting an image places it over the cells as a floating object. To fix this, select the image, click the three-dot menu icon in the top-right corner of the image, and choose Put image in selected cell.

Limitations

• You can insert only one image at a time.
• To add images in multiple cells, you must repeat these steps for each one.

The Insert Menu works for single images, but it becomes slow when you need images in many rows. The IMAGE function provides a faster, formula-based approach - particularly useful when you already have a list of image URLs.

Inserting Images Using the IMAGE Function

You can use the IMAGE function to load images into cells using a URL. This built-in formula pulls an image from a web address and displays it inside the cell.

Instead of inserting images manually, you enter a formula once and copy it down to fill many rows.

When to use: You have direct image URLs and need to insert images across many rows.

1. Find the image online, right-click it, and select Copy image address to copy the direct image URL.

2. Select the target cell.

3. Enter the formula: =IMAGE("image_url"). Replace image_url with the direct web link.

   

4. Press Enter.

5. If Google Sheets asks for permission, click Allow access.

   This lets Google Sheets load the image from the link and show it in the cell. It does not make your sheet public or share your data.

   If you click Deny, the cell will show an error instead of the image.

Bulk use: Add your image URLs in one column, then use =IMAGE(A1) in the next column to show each image. Copy the formula down to the other rows with the fill handle.

Result

Images appear inside cells and automatically update based on the URLs.

If the image does not load: Make sure you copied the direct image address.

A webpage URL, such as /product/shoes, will not work. Right-click the image and select Copy image address, not Copy link address.

Limitations

• Requires public URLs
• Depends on external hosting

If you need to insert multiple images or manage files directly from Google Drive in Google Sheets, refer the next section.

Inserting Multiple Images Using the Drive Explorer Pro Extension

You can use Drive Explorer Pro to insert multiple images directly from Google Drive into Google Sheets without needing public URLs.

The add-on opens a sidebar on the right side of your spreadsheet, where you configure your output and pick files.

When to use: Use this method when working with large datasets, shared drives, or when you need additional file details such as name and size.

Launching the Add-on

Install Drive Explorer Pro from the Google Workspace Marketplace:

1. Go to Extensions → Drive Explorer Pro → Open Drive Explorer

The Drive Explorer Pro sidebar appears on the right side of the screen.

Configuring Drive Explorer Pro Settings

One-time setup: Configure these settings once and reuse them for all future tasks.

Next, configure how the images and file details will appear in your sheet:

1. Go to the List Files tab.

2. Select where to insert the data:

   • Current Cell - use this if the sheet is empty or you want to overwrite from a specific cell.
   • Append Below Existing Data - use this if you already have rows and do not want to overwrite them.

3. Choose what file attributes to display with each image, such as Image Preview, File Name, and File Size. Drag the options to rearrange the column order. To understand each option, see Select File Attributes

4. Click Save selected settings as Default to reuse this configuration in future tasks.

5. Go to the Settings tab and set the image size using Cell Width and Cell Height (in pixels).

6. Configure File Access Settings to control who can open the image files from their Google Drive links.

   • Only me - only you can view the images (default)
   • My organization - people in your organization can view the images
   • Anyone with the link - anyone with the link can view the images

Note: Drive Explorer Pro reads file details such as file name and size, so it can list them in Google Sheets. Your files stay in your Google Workspace.

Inserting Images from Google Drive

Once your settings are configured, you can insert images:

1. Go to the List files tab.

2. Click Select existing files from Drive and List in Sheets.

3. Choose images from your folder. You can select multiple files by holding Ctrl (Windows) or Cmd (Mac) while clicking.

4. Click Select.

The selected images now appear in your sheet, using the insert settings you configured.

Uploading Images from Your Computer

Use this method when the images are still on your computer and you want Drive Explorer Pro to upload them to Google Drive and add them to Google Sheets.

1. Go to the Upload tab.

2. Check the folder shown under Default Google Drive Folder. Drive Explorer Pro will upload the images there.

   To choose another location, click Change and select a different Google Drive folder.

3. Drag and drop files into the upload box, or click the box to select files from your computer. The selected files appear in a list.

   

4. (Optional) If Show preview of selected file(s) is enabled, check the image previews before uploading.

   You can remove a file if needed, or drag files in the preview list to change their upload order.

   

5. Click Upload files to Drive and list in Sheets.

Result

Each file appears in a new row. The columns you selected, such as Image Preview, File Name, and File Size, fill in automatically from left to right starting from your selected cell.

The Image Preview column shows a thumbnail inside the cell.

You can sort and filter the sheet without breaking alignment between images and their corresponding data.

For more details, see Drive Explorer Pro official Documentation

Advantages

• Insert multiple images into Google Sheets in one workflow.
• Add image previews, file names, file links, and other details automatically.
• Keep each image and its file details in the same row.
• Sort and filter the sheet without losing the image-to-row connection.
• Save the same settings for future image uploads or file listings.
• Work with larger image datasets and shared Google Drive folders.

Choosing the Right Method

Based on these features, choose the method that fits your workflow:

If you need to insert many Drive images into Google Sheets, see how to insert images from Google Drive into Google Sheets. Drive Explorer Pro can add the images in bulk without manual URL work.

If your sheet also contains PDF documents alongside images, see how to add a PDF link in Google Sheets to keep all your files accessible from one place.

Conclusion

In-cell images keep your visuals connected to the right rows in Google Sheets, so your sheet stays organized when you sort, filter, or share it.

• For one image, use the Insert menu.
• If you already have public image URLs, use the IMAGE function.
• If you work with multiple images stored in Google Drive or need file details in the same row, use Drive Explorer Pro.

Before sharing the sheet, check the row height and column width so each image is easy to view.