Skip to content
ExcelExcel 2024+

IMAGE function in Excel

Returns an image from a given source

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

IMAGE syntax and parameters

Five arguments, one required.

  • sourcestringRequired
  • alt_textstringOptional
  • sizingnumberOptional
  • heightnumberOptional
  • widthnumberOptional

IMAGE examples

Formulas you'll actually reuse.

  1. A product logo per row from a URL built off the SKU, with alt text:

    =IMAGE("https://example.com/logos/" & A2 & ".png", A2 & " logo")

  2. Show the image at its original size (sizing 3) instead of fit-to-cell:

    =IMAGE("https://example.com/chart.png", "Weekly chart", 3)

IMAGE in Google Sheets

Same name — your formula ports as-is.

Try IMAGE in the playground

Edit the example — nothing to install.

Preloaded with the IMAGE formula from Example 1 — change anything and watch it respond.

Loading the editor…

IMAGE errors

What they mean — and the fixes.

  • #VALUE!

    The URL isn't a supported image type (BMP, JPG, GIF, TIFF, PNG, ICO, WEBP) or the host needs a login.

Related functions

More ways Excel gets this done.