How to Insert Images in Google Sheets from Google Drive (2 Methods)

If your image is already in Google Drive, copying and pasting its Drive link into Google Sheets will not show the image inside the cell. The link stays as a clickable text link.

To show the actual image in the sheet, you need to insert it as an in-cell image or use a method that imports the Drive image into the cell.

This matters for reports, product catalogs, dashboards, or image trackers, where each image must stay tied to its row.

In this tutorial, you will learn two ways to insert images in Google Sheets from Google Drive and when to use each one.

Table of Contents

Video Tutorial

Inserting a Single Image Using the Built-in Insert Menu

If you only need to insert a single image, use the built-in Insert menu in Google Sheets. This is the fastest way to insert one image inside a Google Sheets cell without installing anything.

When to use: Use this method for inserting a single image without extra file details such as file name, size, or link. For multiple images or file details, use the Drive Explorer Pro approach.

1. Select the cell where you want to insert the image.

2. Click Insert in the top menu bar.

3. Select Image.
   

4. Choose one of the following options:

   • Image in cell - Locks the image inside the cell. It moves with the row when sorting or filtering.
   • Image over cells - Places the image above the grid. You can move and resize it freely, but it does not stay attached to any row. Use this only for decorative images or logos that are not tied to specific data rows.

   Note: In-cell images are recommended for structured datasets because they maintain alignment during sorting, filtering, and data updates.

5. Select the Google Drive tab at the top of the dialog.

6. Browse and select the file from your Drive.

7. Click Insert.

Result:

After clicking Insert, the image appears in your sheet. Here is how it behaves based on your selection:

• If you selected In cell, the image moves with the row during sorting and filtering.

  

• If you selected Over cells, the image floats above the grid. You can resize and drag it, but it will not follow the row.

Tip: Increase the column width and row height to make the image larger and easier to see.

• Right-click the column header → click Resize column
• Drag the row border downward to increase height

For more details, refer to the official Google Sheets documentation: Add an image to a spreadsheet

Limitations

• You can insert only one image at a time. To add multiple images, repeat these steps for each file.
• You cannot add file details automatically beside the image, such as the file name, file size, or Google Drive link.

The built-in menu works well for one or two images. When you need to insert multiple images with file details, the next section covers that.

Inserting Multiple Images Using Drive Explorer Pro

Drive Explorer Pro is a Google Sheets add-on that helps you upload files to Google Drive and organize their links in Google Sheets.

You can use Drive Explorer Pro when you need to insert multiple Google Drive images into Google Sheets and keep each image connected to its file name, link, size, and other details.

This works well for product catalogs, reports, inventories, asset trackers, and dashboards.

Why use Drive Explorer Pro

• Insert multiple images at once.
• Add file details like name, size, and download link automatically.
• Keep images anchored to their rows during sorting and filtering.
• Save settings for future image-listing tasks.

Install Drive Explorer Pro from the Google Workspace Marketplace:

Launching Drive Explorer Pro

1. Open Google Sheets.
2. Go to Extensions > Drive Explorer Pro > Open Drive Explorer Pro.

The Drive Explorer Pro sidebar opens on the right side of your sheet.

One-time setup: Configure these settings once. Drive Explorer Pro will reuse them for future image-listing tasks, so you do not need to repeat the setup each time.

Configuring the Sheet Output

Before inserting images, choose where the data should appear and which file details should be added to the sheet.

1. Go to the List Files tab.

2. Under Start listing file from, choose one option:

   • Current Cell - starts from the selected cell.
   • Append Below Existing Data - adds new rows below existing content.

3. Under Select File Attributes to list, choose the details you want to add with each image.

For most image workflows, select Image Preview, File Name Linked to URL, and File Size (MB).

You can drag the selected attributes to change the column order. To understand each option, see the Select File Attributes documentation.

4. Click Save Selected Settings as Default.

Setting the Image Preview Size

Set how large each image preview should appear inside the Google Sheets cells.

1. Go to the Settings tab.

2. In the Image Settings, set the Cell Width and Cell Height in pixels.

A size between 100 and 150 pixels works well for most image lists. Use a smaller size for large sheets, or a larger size when users need to identify images without opening them in Google Drive.

3. Under File Access Settings, choose who can open the photo links:

   File Access Setting	What it means
   Only me	The photos stay private in your Google Drive
   My organization	People inside your company or school can open the photo links
   Anyone with the link	Anyone with the link can open the photos

4. Click Save Selected Settings as Default.

Inserting Images from Google Drive

After choosing the folder, file attributes, and preview size, you can insert the images into Google Sheets.

1. Go back to the List Files tab.

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

3. Select one or more images from Google Drive.

4. Click Select.

5. When it finishes, the images appear in the sheet, one row per file.

Do not close the sidebar while the images are being added. Closing it early can stop the process and leave rows incomplete.

File access note: Image previews can appear in Google Sheets, but if you are sharing, the recipients still need permission to open the original Google Drive files. If you need to upload photos and create shareable links, see Upload Photos to Google Drive and Share a Link.

Result

Your Google Drive images appear in Google Sheets as structured rows. Each row can include the image preview, file name, file size, and link, based on the attributes you selected.

Because the previews are inserted into cells, the images stay connected to their rows when you sort or filter the sheet.

For more details, see the Drive Explorer Pro official documentation.

Choosing the Right Method

The two methods serve different needs. Use the tables below to decide which approach fits your situation

If you work with large datasets or image-heavy reports, the Drive Explorer Pro add-on saves time and reduces repetitive work.

If the images are still on your computer and not yet in Google Drive, see how to mass upload images to Google Sheets automatically to upload and list them in one workflow.

Conclusion

Images work best in Google Sheets when they stay connected to the correct row. This keeps reports, product catalogs, dashboards, and image trackers easier to sort, filter, and share.

• Use the Insert menu when you need to add one image from Google Drive.
• Use Drive Explorer Pro when you need to insert multiple images with previews, file names, links, and other file details in the same row.

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