# Google Sheets IMAGE Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/image-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The IMAGE function displays an image in a cell, allowing you to embed pictures from a URL or a local file within your Google Sheets. ``` IMAGE(url, [mode], [height], [width]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the IMAGE you need in plain EnglishGenerate Formula ## Parameters **`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: | ProductID | ProductName | ImageURL | | - | - | - | | 101 | Widget A | | | 102 | Widget B | | | 103 | Widget C | | 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 | | ![Widget A](https://example.com/widget_a.jpg) | | 102 | Widget B | | ![Widget B](https://example.com/widget_b.jpg) | | 103 | Widget C | | ![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! ## Example use case You have a table with product names in Column A and their corresponding images in Column B. By using the IMAGE formula, you can display product images directly in your sheet, enhancing visual representation and making it easier to identify products at a glance. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Make A Line Graph In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-line-graph-in-google-sheets) - [How To Make A Pie Chart In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-pie-chart-in-google-sheets) - [How To Make A Table In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-table-in-google-sheets) - [How To Merge Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-merge-cells-in-google-sheets) - [How To Multiply In Google Sheets](https://betteranalyst.com/google-sheets/how-to-multiply-in-google-sheets) - [How To Password Protect An Google Sheets File](https://betteranalyst.com/google-sheets/how-to-password-protect-an-google-sheets-file) - [How To Remove Blank Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-remove-blank-rows-in-google-sheets) - [How To Remove Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-remove-duplicates-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.