Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
IMAGE
IMAGE displays a picture from a public URL inside a cell in Google Sheets. You can control the sizing behavior — fit to cell, stretch to fill, use original size, or specify exact pixel dimensions. Use it to add product photos, logos, or visual indicators directly in your spreadsheet without manual insertion.
Excel
=IMAGE("https://example.com/logo.png",1)Google Sheets
=IMAGE("https://example.com/logo.png",1)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Enter the public URL to an image file (PNG, JPG, GIF, etc.) as the first argument.
- 2Choose a sizing mode: 1 = fit to cell (default), 2 = stretch to fill, 3 = original size, 4 = custom dimensions.
- 3For mode 4, add width and height in pixels as third and fourth arguments (e.g., =IMAGE(url,4,100,50)).