How to Use the IMAGE Function in Google Sheets to Insert Dynamic Pictures in Cells

In product inventory databases, e-commerce stock sheets, real estate listings, and employee directories, incorporating visual thumbnails alongside textual data makes spreadsheets significantly more readable. While users can manually insert pictures using the standard “Insert > Image over cells” menu, floating images do not link to row data. When columns are sorted, rows are filtered, or cell heights are modified, floating images become displaced, misaligned, or obscured. Google Sheets provides the native IMAGE function to insert images directly inside individual cells, ensuring pictures lock to their respective data rows permanently.

Mastering the IMAGE function allows you to build dynamic product catalogues, manage cell aspect ratios, set exact pixel dimensions, and automate image generation using spreadsheet formulas.

Syntax and Parameters of the IMAGE Function

The IMAGE function accepts up to four arguments to control display dimensions and scaling:

=IMAGE(url, [mode], [height], [width])

The parameters operate as follows:

• url (Mandatory): The direct web address of the image enclosed in quotation marks (or a cell reference containing the URL). The URL must use the secure https:// protocol and point directly to a supported image file format (such as .png, .jpg, .webp, or .svg).
• mode (Optional): A numeric code (1 through 4) defining how the image scales within cell boundaries:
  • 1 (Default): Resizes the image to fit completely within the cell while strictly preserving original aspect ratio.
  • 2: Stretches or compresses the image to fill the exact cell boundaries, ignoring the native aspect ratio.
  • 3: Displays the image at its original native dimensions, which may cause cropping if the cell is smaller than the image file.
  • 4: Custom dimensions mode, allowing you to explicitly declare exact height and width in pixels.
• height (Optional): The image height in pixels (required only when mode is set to 4).
• width (Optional): The image width in pixels (required only when mode is set to 4).

Basic Implementation: Proportional Fitting (Mode 1)

Mode 1 is the most widely used setting because it guarantees that logos, product photos, and portraits scale proportionally without stretching or pixel distortion:

1. Select the cell where the picture should appear (for example, cell B2).
2. Enter the formula:

=IMAGE("https://example.com/assets/product-thumbnail.jpg", 1)

3. Press Enter. The image renders directly inside the cell.
4. Adjust the cell size by dragging the row height or column width boundaries. Notice that the image dynamically expands or contracts to fit the available space while preserving its natural proportions.

Applying Custom Pixel Dimensions (Mode 4)

When designing uniform summary tables where every thumbnail must adhere to precise dimensions regardless of row sizing:

1. Select your destination cell.
2. Enter the formula specifying Mode 4 along with height and width parameters:

=IMAGE("https://example.com/assets/icon.png", 4, 80, 80)

3. This instruction forces the image to render at exactly 80 pixels wide by 80 pixels tall within the cell boundaries.

Building Automated Image Catalogs via String Concatenation

When managing databases containing hundreds of items, manually pasting individual image formulas is inefficient. If your image server or CDN uses structured filenames matching product SKUs or employee IDs, construct dynamic formulas:

1. Assume product SKU codes reside in column A starting at cell A2 (e.g. SKU-1045).
2. In cell B2, use the ampersand operator (&) to concatenate the base CDN directory URL with the cell value:

=IMAGE("https://cdn.retailer.co.uk/inventory/" & A2 & ".png", 1)

3. Double-click the fill handle at the corner of cell B2. Google Sheets automatically generates valid image formulas down the entire column.

Troubleshooting Common IMAGE Function Issues

If a formula returns an empty cell, a red error flag, or a broken image icon, verify these common constraints:

• Google Drive Sharing Links: Standard Google Drive sharing URLs (e.g. drive.google.com/file/d/FILE_ID/view) point to web preview interfaces, not raw binary assets. To embed an image hosted in Google Drive, convert the URL format to: https://drive.google.com/uc?export=view&id=FILE_ID.
• HTTP vs HTTPS Protocol: Google Sheets blocks unencrypted http:// image URLs for security reasons. Always ensure the URL begins with https://.
• Hotlinking and Bot Protection: Websites utilizing strict Cloudflare Bot Management or referer restrictions can block requests originating from Google’s cloud server infrastructure, resulting in blank cells.