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.
Search Wikimedia Commons From Google Sheets With a Custom Function
Use the free Wikimedia Commons API in Google Sheets: a short Apps Script function that returns free images with license, author and thumbnail.
Read post →How to Download Images From a List of URLs (No App, No Extension)
Turn a column of image URLs in Google Sheets into a script that downloads every file to one folder. Mac, Linux and Windows steps, no app to install.
Read post →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 →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.