Ravindra BagaleCourses & study guides Track your progress

Excel IMAGE Function

By · Last updated:

Chala mitrano — today we learn IMAGE. Read Why → What → How, then try the practice list.

Version note. Microsoft 365. Needs web access / permitted URLs. Not classic Insert → Pictures replacement for every case.
Fictional sample data for learning. Example.com URLs are samples only — use your own permitted images when practising.

Purpose

Insert an image into a cell from a URL (and optional alt text / sizing).

Return value

An image displayed in the cell (not a normal file embed dialog).

Syntax

IMAGE(source, [alt_text], [sizing], [height], [width])

Arguments

ArgumentRequired?Description
sourceRequiredURL of the image (https).
alt_textOptionalAccessibility text.
sizingOptionalHow the image fits (fit, fill, original, custom — see Microsoft docs for codes).
heightOptionalPixel height when custom.
widthOptionalPixel width when custom.

Version

Microsoft 365. Needs web access / permitted URLs. Not classic Insert → Pictures replacement for every case.

How to use — Why → What → How

Why: Dashboards sometimes need logos or product thumbs that update from a link.

What: IMAGE pulls a picture into the grid from a URL.

How — numbered steps:

  1. Get a direct image URL (ends with .png/.jpg when possible).
  2. Type =IMAGE("https://…/logo.png","Company logo").
  3. Widen the row height so you can see it.
  4. Use alt_text for screen readers.
  5. Avoid huge images — they slow the sheet.

Ravindra Bagale's Tip

Only use trusted URLs. Random internet images are a security and licensing risk.

Ravindra Bagale's Tip

IMAGE is not a substitute for proper brand asset management.

Worked examples

1) Simple logo

Place a PNG URL.

Formula: =IMAGE("https://example.com/logo.png","Logo")

Result: Logo in cell

What it means: Replace with a real allowed URL when you practise.

2) Product thumb from table

URL in B2.

Formula: =IMAGE(B2, A2)

Result: Thumb + alt from name

What it means: Alt text from product name.

3) Sizing hint

Custom size if supported.

Formula: =IMAGE(B2,"Alt",1,60,60)

Result: Sized image

What it means: Confirm sizing codes on your build.

4) Dashboard header

Merge-friendly row height.

Formula: =IMAGE(LogoURL,"Ravindra Bagale Excel")

Result: Header art

What it means: Training branding toy.

5) Broken URL behaviour

Bad link.

Formula: =IMAGE("https://example.invalid/x.png","x")

Result: Error / blank depending on build

What it means: Always test links.

Common errors

#VALUE! / #BLOCKED!: URL not allowed or invalid.
Privacy / sign-in walls: Image host refuses anonymous fetch.

Practice tasks (10+)

  1. Task 1. Insert IMAGE with a public sample PNG you own rights to.
    Hint: try on a tiny range first
  2. Task 2. Add meaningful alt_text.
    Hint: try on a tiny range first
  3. Task 3. Pull URL from a cell.
    Hint: try on a tiny range first
  4. Task 4. Adjust row height.
    Hint: try on a tiny range first
  5. Task 5. Document licensing of the image.
    Hint: try on a tiny range first
  6. Task 6. Compare to Insert → Pictures.
    Hint: try on a tiny range first
  7. Task 7. Explain security caution.
    Hint: try on a tiny range first
  8. Task 8. Try sizing arguments on your build.
    Hint: try on a tiny range first
  9. Task 9. Note what happens offline.
    Hint: try on a tiny range first
  10. Task 10. Bonus: IMAGE beside a product XLOOKUP.
    Hint: try on a tiny range first

Quick quiz

Q1. IMAGE needs a URL source.
Q2. Any random URL is always safe.
Q3. Alt text helps accessibility.
Q4. IMAGE is mainly a 365 feature.

Answers: Q1=True, Q2=False, Q3=True, Q4=True

Related: LAMBDA · LET · GROUPBY · Function hub · Learning path