What is IMAGE in Google Sheets?
IMAGE fetches a picture from a public URL and renders it inside a cell. Modes control fit, stretch, and custom height. Product catalogs, team directories, and asset trackers use IMAGE to show thumbnails beside SKUs without manual insert image menus.
When to use it
Use IMAGE when image URLs are stable, public, and you want thumbnails driven by a formula column in a catalog or gallery sheet.
When to skip it
Skip IMAGE for private Drive files without public links, huge print layouts, or when Insert image manual placement is a one-time design task.
How it works
-
1
Store a full HTTPS image URL in a cell.
-
2
Write =IMAGE(url) for default fit-in-cell behavior.
-
3
Add mode argument to stretch, fit, or set custom pixel size per documentation.
-
4
Resize row height and column width so thumbnails display clearly.
-
5
Use IFERROR or a placeholder URL when the image link is missing.
-
6
Prefer CDN or hosted URLs with consistent hotlink permissions.
Examples in Google Sheets
Product thumb
=IMAGE(D2) shows thumbnail from URL in column D beside SKU and title.
Sized avatar
=IMAGE(E2, 4, 48, 48) forces 48px square avatars in a team roster.
Conditional image
=IF(A2="Gold", IMAGE(gold_badge_url), IMAGE(silver_badge_url)) swaps badge art by tier.
Better Sheets resources
Common mistakes
-
Drive share links that require login, showing broken image icons.
-
HTTP mixed content blocked in some contexts; prefer HTTPS.
-
Row height left at default so images clip unreadably.
-
Huge full-resolution URLs slowing sheet load on hundreds of rows.
-
Hotlink protection on vendor sites blocking Google fetch.
Frequently asked questions
- IMAGE vs Insert image?
- IMAGE is formula-driven from URLs. Insert image is manual placement.
- Google Drive IMAGE URL?
- Needs a direct or published link format that allows anonymous fetch.
- IMAGE size modes?
- Modes control fit, stretch, original size, and custom height width per help docs.
- Why broken image?
- Bad URL, permission block, or deleted host file.
- IMAGE in exported PDF?
- Often prints if loaded at export time. Test before client delivery.
- Multiple images one cell?
- One IMAGE per cell. Use separate columns or rows.
- IMAGE and HYPERLINK?
- Combine HYPERLINK on text with IMAGE in neighbor cell for clickable galleries.
Related Tutorials
Watch how IMAGE works
How to Create AI Images From Google Sheets
Make Unsplash in Google Sheets - Part 2
Make Unsplash in a Google Sheet w/ BuyMeACoffee - Part 1
How to make a Pill Form Field in Google Sheets
Search for Photos in a Google Sheet
Related blog posts
Guides that explain IMAGE in more depth.
7 Best Beginner Tutorials Featuring the INDEX() Google Sheet Formula
Master Google Sheets with 7 beginner tutorials on using the INDEX formula. Turn data into results with free tools, templates, and tutorials!
Read post →How To Make That Viral Growing Plant Progress Chart
You might have seen a viral TikTok where there is a progress bar and a growing sort of garden of flowers or potted plant that's growing as you check off these task bars tasks. So I want to walk through what this formula, the combination is how it's really cool it
Read post →How to Easily Add Company Logos to Your Google Sheets
I wanted to share this really cool little thing that I discovered from my friend, James Ivins, over on Twitter. He said that Google has a secret API that you can use to show any website's icon on your site and he had this URL he used.
Read post →Related terms
HYPERLINK
HYPERLINK builds a clickable link in a cell. Pass a URL and optional friendly label text. Reports use it for open invoice, view doc, or mailto support links without ugly raw URLs filling the grid.
Read guide →IMPORTRANGE
IMPORTRANGE loads values from a range in another Google spreadsheet into your current file. You pass the spreadsheet URL or key plus a range string with an optional sheet name. After you grant access once, the link stays live and updates when the source changes.
Read guide →SPARKLINE
SPARKLINE draws a miniature chart inside one cell from a row or column of numbers. Choose line, column, bar, or winloss types and pass an options object for color, axis, and markers. Dashboard tables use sparklines to show trend without full charts.
Read guide →QUERY
QUERY runs a SQL-like statement against a range of cells and returns a new table of results. You pass a data range, a query string with SELECT, WHERE, ORDER BY, and optional headers. It is the fastest way to filter, sort, group, and pivot sheet data without helper columns.
Read guide →Done reading about IMAGE?
Membership unlocks 600+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.