Web
IMAGE Function in Excel
Inserts an image from a URL into a cell.
Syntax
- =IMAGE(source, [alt_text], [sizing], [height], [width])
Arguments
- source (required): URL of the image
- alt_text (optional): Alternative text for accessibility
- sizing (optional): 0=fit cell, 1=fill cell, 2=original, 3=custom
- height (optional): Custom height in pixels
- width (optional): Custom width in pixels
Examples
- =IMAGE("https://example.com/logo.png") - Insert image from URL - Result: Image in cell
- =IMAGE(A1, "Product photo", 0) - Image with alt text, fit to cell - Result: Fitted image
Excel IMAGE function documentation
- IMAGE inserts a picture into a cell from a URL — Microsoft 365.
- Syntax: =IMAGE(source, [alt_text], [sizing], [height], [width]).
- Use for product catalogs, avatar dashboards, and dynamic thumbnails from CDN links.
- Related: [WEBSERVICE](/functions/webservice/), [HYPERLINK](/functions/hyperlink/), [SPARKLINE](/functions/sparkline/).
IMAGE syntax and sizing modes
- source: https URL to image file — png jpg gif bmp etc.
- alt_text accessibility description optional.
- sizing: 0 fit cell, 1 fill cell, 2 original size, 3 custom px height width.
- Requires internet to fetch — broken link shows placeholder error.
Step-by-step: product image from URL column
- Step 1 — Image URLs in column C.
- Step 2 — =IMAGE(C2, product_name, 0) in D2 — fit cell.
- Step 3 — Increase row height and column width for visibility.
- Step 4 — Copy down — images load on recalc.
- Step 5 — Offline workbook — images may not refresh — embed static pictures for archives.
IMAGE vs Insert Picture vs WEBSERVICE
- IMAGE — formula-driven URL in cell.
- Insert Picture — static embed.
- WEBSERVICE — raw bytes/text not display image in cell.
- Web category: [/categories/web/](/categories/web/).
Worked examples to copy
- Basic: =IMAGE("https://example.com/logo.png").
- From cell: =IMAGE(A2, "Product photo", 0).
- Custom size: =IMAGE(url, alt, 3, 100, 100).
- IFERROR: =IFERROR(IMAGE(A2), "No image").
People also ask
- IMAGE Excel 2019? — No; Microsoft 365.
- IMAGE local file path? — Generally requires URL not C:\ path in web Excel.
- IMAGE slow many rows? — Each URL fetch — limit count.
- IMAGE security? — Only trusted URLs — same as WEBSERVICE caution.
Common errors
- #VALUE! if URL is invalid
- #CONNECT! if image cannot be loaded
Use cases
- Product catalogs
- Employee directories
- Visual dashboards
- Dynamic reports
Frequently asked questions
- What is the IMAGE function in Excel? IMAGE inserts an image from a URL into a cell. The syntax is =IMAGE(source, [alt_text], [sizing], [height], [width]). Typical use cases include product catalogs, employee directories, visual dashboards.
- How do I use the IMAGE function? To use IMAGE, type =IMAGE( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
- Why is IMAGE not working in my Excel? Common issues with IMAGE include #VALUE! if URL is invalid; #CONNECT! if image cannot be loaded. Start by checking the syntax =IMAGE(source, [alt_text], [sizing], [height], [width]), then verify each referenced cell or range.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.
When to use IMAGE
- Product catalogs — common Web scenario for IMAGE.
- Employee directories — common Web scenario for IMAGE.
- Visual dashboards — common Web scenario for IMAGE.
- Dynamic reports — common Web scenario for IMAGE.
IMAGE in the Web category
- Browse all Web functions at /categories/web/ for related formulas.
- IMAGE syntax: =IMAGE(source, [alt_text], [sizing], [height], [width])
- source (required): URL of the image
- alt_text (optional): Alternative text for accessibility
- sizing (optional): 0=fit cell, 1=fill cell, 2=original, 3=custom
- height (optional): Custom height in pixels
- Confirm IMAGE arguments match the syntax shown above before filling down.
- Lock table and range references with $ when copying formulas across rows or sheets.
Formula checklist before you copy down
- Confirm IMAGE arguments match the syntax shown above before filling down.
- Lock table and range references with $ when copying formulas across rows or sheets.
- If results look wrong, check for text stored as numbers and invisible spaces with TRIM.
- Spot-check three known input rows manually against expected output.
Related Excel functions
- WEBSERVICE (/functions/webservice/): Returns data from a web service on the internet or intranet.
- HYPERLINK (/functions/hyperlink/): Creates a clickable hyperlink to a URL, file, or location within the workbook.
Errors to watch for
- #VALUE! if URL is invalid — review causes on linked error pages in the directory.
- #CONNECT! if image cannot be loaded — review causes on linked error pages in the directory.
Copy-paste audit workflow
- Enter IMAGE on three test rows with known expected output documented on a QA tab.
- Fill down only after absolute references are locked on lookup tables and rate tables.
- Compare against manual calculation or a calculator for financial and statistical functions.
- Search this directory for comparison guides when choosing between similar functions in the same category.
IMAGE worked examples to copy
- =IMAGE("https://example.com/logo.png") — Insert image from URL. Expected result: Image in cell.
- =IMAGE(A1, "Product photo", 0) — Image with alt text, fit to cell. Expected result: Fitted image.
IMAGE reference summary for crawlers and offline review
- IMAGE belongs to the Web category in Excel. Inserts an image from a URL into a cell.
- Full syntax: =IMAGE(source, [alt_text], [sizing], [height], [width]). Open /functions/image/ for parameters, FAQs, and related pages.
- Common mistakes: #VALUE! if URL is invalid; #CONNECT! if image cannot be loaded
- Pair this function with comparison guides when another Excel formula might fit the same task better.
- Review fix-excel-formula-errors when unexpected errors appear after upgrading Excel or sharing across locales.