Google Sheets IMAGE Function: Syntax, Examples & Tips

url:
The URL of the image you want to display in the cell. This must be a valid link to an image file.

mode:
An optional parameter that specifies how the image should be displayed. It can take the following values: 1 (fit to cell), 2 (maintain aspect ratio), 3 (stretch to fill cell), or 4 (custom size).

height:
An optional parameter that defines the height of the image in pixels when using mode 4. If omitted, the height will be automatically determined based on the mode selected.

width:
An optional parameter that defines the width of the image in pixels when using mode 4. If omitted, the width will be automatically determined based on the mode selected.

What is an IMAGE Function in Google Sheets?

The IMAGE function in Google Sheets is a useful tool that allows you to insert and display images directly within your spreadsheet. This function can be particularly helpful for creating visually appealing reports, dashboards, or inventory lists where images of products or items are necessary. With the IMAGE function, you can easily link to images stored online or use local file paths.

In simpler terms, the IMAGE function enables you to show pictures in your Google Sheets, making your data more engaging and informative.

A Practical Example

Imagine you are managing a product catalog in Google Sheets, and you want to display images of each product alongside their details.

Product Catalog Table:

You want to display the images of each product in a separate column.

IMAGE Formula

To achieve this, you would use the IMAGE function as follows:

=IMAGE(C2, 4, 100, 100)

In this formula:

• C2 is the cell containing the URL of the image.
• 4 specifies that the image should be resized to fit the specified dimensions.
• 100 is the width in pixels.
• 100 is the height in pixels.

Result of the Formula

When you apply the IMAGE formula to the Product Catalog Table, the output would look like this:

ProductID	ProductName	ImageURL	Product Image
101	Widget A	https://example.com/widget_a.jpg
102	Widget B	https://example.com/widget_b.jpg
103	Widget C	https://example.com/widget_c.jpg

In this case, each product's image will be displayed in the "Product Image" column.

Why Use IMAGE?

The IMAGE function is beneficial because it enhances the visual appeal of your spreadsheets. It allows you to integrate images seamlessly into your data, making it easier for users to identify products or items at a glance. This can be particularly useful in presentations, reports, or any scenario where visual representation is key.

Key Takeaways:

• IMAGE: A Google Sheets function that allows you to insert and display images directly in your spreadsheet.
• Versatile: Can link to images stored online or use local file paths.
• Customization: Offers options to resize images to fit your layout.
• Common Use Cases: Ideal for product catalogs, dashboards, and reports where visual data representation is necessary.

The IMAGE function is an essential tool for anyone looking to enhance their Google Sheets with visual elements, making data more engaging and easier to understand.

Happy spreadsheeting!