Formulas > =IMAGE()

How To Use IMAGE() Function in Google Sheets


Inserts an image into a cell.

The IMAGE formula in Google Sheets allows you to insert an image into a cell based on a specified URL. Here are answers to the questions you raised:

Common questions about the IMAGE formula:
How do I use the IMAGE formula in Google Sheets?
What is the correct syntax for the IMAGE formula?
Can I use the IMAGE formula to insert images from my local computer?
Can I resize the inserted image using the IMAGE formula?
Does the IMAGE formula support dynamic image URLs?

Appropriate use of the IMAGE formula:
Inserting company logos or icons into spreadsheets for branding purposes.
Displaying product images in an inventory or catalog sheet.
Adding visual elements to enhance the presentation of data or reports.
Including screenshots or images of charts, graphs, or diagrams relevant to the spreadsheet content.

Common mistypings of the IMAGE formula:
Misspelling the word "IMAGE" as "IMAGES" or "IMAG" in the formula.
Incorrectly capitalizing the formula as "Image" instead of "IMAGE."
Neglecting to include the equal sign (=) at the beginning of the formula.

Inappropriate use of the IMAGE formula:
Inserting large images that exceed the cell's dimensions, resulting in distorted or cropped images.
Using the IMAGE formula for non-visual data, such as numeric or textual values.
Trying to insert images from non-publicly accessible URLs that require authentication or permission.

Common pitfalls when using the IMAGE formula:
Using a broken or invalid image URL, which will result in a broken image icon or an error message.
Depending on external image URLs that may change or become unavailable over time, causing broken images.
Forgetting to update image URLs when sharing or distributing the spreadsheet, leading to broken image links.

Common mistakes when using the IMAGE formula:
Forgetting to enclose the image URL within quotation marks (" ") in the formula.
Failing to specify the cell reference where the IMAGE formula should be placed, resulting in errors or unexpected behavior.
Accidentally overwriting an existing IMAGE formula with incorrect or incomplete information, leading to broken image links.

Common misconceptions about the IMAGE formula:
Assuming the IMAGE formula can directly embed images into the spreadsheet file, rather than referencing external URLs.
Believing that the IMAGE formula can resize or manipulate the inserted images beyond the original dimensions provided by the URL.
Mistakenly thinking that the IMAGE formula supports uploading images from local storage without relying on external URLs.

Google Sheet Formula Frustrations Solved
Find every formula you'll ever need in Google Sheets here at Better Sheets. Whether you're a beginner or an advanced user, I’ve got you covered with a comprehensive guide of 504 formulas.

Are you struggling to find a specific value in a column of data? Look no further than the powerful VLOOKUP formula. Or maybe you need to calculate the sum of values that meet specific criteria - try out SUMIF. And when it comes to frequency of values, COUNTIF has you covered.

Have you heard of the mysterious and powerful IF formula? It can turn your spreadsheets into gateways of productivity. And don't forget about the oft-partner ISBLANK(). 

Find step-by-step tutorials for any formula here on Better Sheets. Every formula page comes with links to written blog posts and Better Sheets tutorials featuring the exact formula.

Looking for a way to segment data based on specific criteria? The FILTER formula is perfect for you. 

If you need to replace VLOOKUP, give INDEX/MATCH a try.

At, I have everything you need to take your Google Sheets skills to the next level. 
From ARRAYFORMULA() to ZTEST(), Better Sheets has it all. 

How To Actually Use IMAGE() in Sheets

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

10Better Sheets Tutorials

Learn how to use a free Google API to create QR codes in sheet to any URL. And we'll learn how to make them magically appear as you enter domains.
Revolutionary Method to Manage Your Video Stories! Learn how to delete old videos in just 24 hours. Keep your content fresh and engaging. Click here for the ultimate guide. 
Add pictures to your marketplace inside a google sheet. Might be great for garage sales, and community events.
Create a simple facebook ad mockup with image and primary text in a google sheet. Get character count too!
Google Sheets uses a scripting language called Google Apps Script, which is based on JavaScript. If you know how to code in JavaScript, you'll find Google Apps Script very familiar. To get started, open a new Google Sheet and go to the "Extensions" menu, then click "Apps Script".
Add visual flair to your Google Sheets when sharing company domain information. You’ll learn how to use an undocumented Google API. ( Easier than you think!)
There was a stories craze. Every app/platform/business was adding 24 hour lasting videos to their users accounts. Now you can do that with Google sheets.
Create a growing flower pot from checkboxes with this bountiful formula combination. Members get free access to the sheet in the video.
See how you can create your own API using Google Sheets' Web App feature. Deploy a web app and write doGet() to enable others to use an API you create yourself.
Find out the results of YouTube Thumbnail A/B Tests with this YouTube Thumbnail Image hack we can do in Google Sheets.

Learn more about the IMAGE() formula:

Google Sheets - Use Images in your Spreadsheet

Learn the different ways to insert images into Google Sheets. They can sit on top of the cells or inside of a cell. If you use the IMAGE function, they can be controlled by a formula.

Generate a IMAGE() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.