Check Sheet Logo
Check Sheet

IMAGE

The IMAGE formula in Google Sheets is used to insert an image into a cell. The image can be a URL or a data URI. The formula supports various modes for resizing the image and can also specify the height and width of the image. This formula is commonly used to create visually appealing spreadsheets or to add images to tables and reports.

Usage

Use the IMAGE formula with the syntax shown below, it has 1 required parameter and 3 optional parameters:

=IMAGE(url, [mode], [height], [width])
Parameters:
  1. url (required):
    The URL or data URI of the image to insert. The image must be in a web-supported format such as JPG, PNG, or GIF.
  2. mode (optional):
    An optional parameter that specifies how to resize the image to fit into the cell. Valid values are 'fit', 'fill', and 'clip'.
  3. height (optional):
    An optional parameter that specifies the height of the image in pixels. If not specified, the height will be determined automatically based on the image aspect ratio and the width of the cell.
  4. width (optional):
    An optional parameter that specifies the width of the image in pixels. If not specified, the width will be determined automatically based on the image aspect ratio and the height of the cell.

Examples

Here are a few example use cases that explain how to use the IMAGE formula in Google Sheets.

Inserting a logo into a report

The IMAGE formula can be used to insert a company logo into a report to make it more professional and visually appealing.

Adding images to a product catalog

The IMAGE formula can be used to add images of products to a catalog to help customers make informed decisions.

Creating a photo album

The IMAGE formula can be used to create a photo album in Google Sheets by inserting images into cells and resizing them to fit.

Common Mistakes

IMAGE not working? Here are some common mistakes people make when using the IMAGE Google Sheets Formula:

Missing or incorrect URL

One of the most common mistakes is to provide a URL that is incorrect or incomplete. Make sure to double-check the URL and ensure that it is a valid image URL that includes the file extension (e.g. .jpg, .png).

Incorrect mode parameter

If the mode parameter is not specified or is incorrect, the image may not display properly. Make sure to use one of the supported modes (crop or fit) and double-check the spelling and capitalization.

Incorrect height or width

If the specified height or width is too large or too small, the image may not display properly. Make sure to use reasonable values that fit within the boundaries of your sheet.

Incorrect syntax

Make sure you are using the correct syntax for the IMAGE formula including the correct number of parameters, commas between parameters, and square brackets around optional parameters.

Image not loading

If the image is not loading, check that the URL is correct, the image is accessible, and that you have an active internet connection.

Related Formulas

The following functions are similar to IMAGE or are often used with it in a formula:

  • SPARKLINE

    The SPARKLINE formula is used to create a small chart in a single cell, which can be used to show trends and variations in data. It is commonly used in dashboards and reports to provide a quick visual representation of data. The chart can be customized using various options such as chart type, color, axis, and more.

  • GOOGLEFINANCE

    The GOOGLEFINANCE formula is used to retrieve market data from Google Finance. This formula can be used to retrieve stock quotes, currency exchange rates, futures, and mutual funds. It is most commonly used to retrieve stock quotes. The formula requires a ticker symbol as input and can also take additional optional parameters such as the attribute to retrieve, the start and end dates, and the interval of time between data points.

  • IMPORTXML

    The IMPORTXML formula allows you to import data from an XML or HTML document on the web. This can be useful for scraping data from websites or for importing data from APIs that return XML data. The formula takes a URL and an XPath query as inputs and returns the data that matches the query.

Learn More

You can learn more about the IMAGE Google Sheets function on Google Support.