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.
- How to use
- Examples of using
IMAGEformula not working?
- Similar formulas to
IMAGE formula with the syntax shown below, it has 1 required parameter and 3 optional parameters:
- 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.
- mode (optional):
An optional parameter that specifies how to resize the image to fit into the cell. Valid values are 'fit', 'fill', and 'clip'.
- 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.
- 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.
ExamplesHere are a few example use cases that explain how to use the
IMAGE formula in Google Sheets.
Inserting a logo into a report
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
IMAGE formula can be used to add images of products to a catalog to help customers make informed decisions.
Creating a photo album
IMAGE formula can be used to create a photo album in Google Sheets by inserting images into cells and resizing them to fit.
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.
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.
The following functions are similar to
IMAGE or are often used with it in a formula:
SPARKLINEformula 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.
GOOGLEFINANCEformula 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.
IMPORTXMLformula 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.
You can learn more about the
IMAGE Google Sheets function on Google Support.