Function Problems

How to Display an Image from a URL in an Excel Cell

Maira Mehtab Sep 22, 2026 869 views

Question details

The user wants to automatically display pictures inside an Excel column by fetching them from image URLs stored in an adjacent column.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Managing a spreadsheet containing a list of image web addresses, where visual representation is needed directly inside the cells for better data visualization.
Observed behavior: Currently, the cells only show plain text URLs instead of rendering the actual images.

Before you start

Ensure you are using a compatible version of Excel (such as Microsoft 365) that supports the IMAGE function, and verify that the image URLs are public and point directly to image file extensions like .jpg or .png.

Solution 1Recommended

Use the Excel IMAGE Function

The built-in IMAGE function is the most efficient and dynamic way to load and display pictures directly from web URLs in modern Excel versions.

This function automatically fetches the picture from a web server and resizes it to fit inside the cell. It requires an active internet connection to retrieve the images.

Select the target cell

Click on the cell where you want the image to appear (for example, cell B1).

Enter the formula

Type the formula =IMAGE(A1) into the formula bar, assuming the web URL is located in cell A1.

Load the image

Press Enter to execute the formula. Excel will fetch and display the image directly inside the cell.

Apply to multiple rows

Click and hold the fill handle at the bottom-right corner of cell B1, then drag it down the column to apply the formula to the remaining URLs.

Accessible URLs: Ensure the image URLs do not require a login or password, otherwise the function will not be able to retrieve and display the picture.

Solution 2

Use an Online Image Conversion Service

If you are using an older version of Excel that lacks the IMAGE function, a third-party conversion tool can automatically turn a list of URLs into embedded pictures.

Work Smarter with WPS

Easily Manage Data and Images with WPS Spreadsheet

WPS Spreadsheet provides powerful built-in tools for managing data, links, and formatting. Enjoy an intuitive interface that makes handling large sets of visual data easier than ever.

1. Open your file in WPS: Launch WPS Spreadsheet and open your document containing the image URLs.
2. Select your cell: Click on the cell where you want the visual data to be displayed.
3. Insert or fetch images: Utilize built-in web image functions or navigate to the 'Insert' tab on the top ribbon to directly add and align pictures within your spreadsheet.
4. Adjust layout: Easily resize rows and columns to perfectly frame your images using the right-click formatting menu.

Fully compatible with Microsoft Excel (.xlsx) files and functionsStreamlined interface for inserting and managing cell picturesLightweight, fast, and completely free for basic usageCross-platform support for Windows, Mac, Linux, iOS, and Android

microsoft office alternative - wps office

Frequently Asked Questions

Why does the IMAGE function return a #VALUE! error?

This error typically occurs if the URL does not point directly to a supported image file format (like .jpg, .png, or .gif), or if the URL exceeds Excel's maximum character limit.

Can I adjust the size of the image loaded by the formula?

Yes. The IMAGE function includes optional parameters for resizing. You can use the syntax =IMAGE(source, [alt_text], [sizing], [height], [width]) to define exact dimensions or tell the image to stretch or fit the cell.

Will my images still show if I am working offline?

No. Because the formula dynamically fetches the picture from a web server, you must maintain an active internet connection for the images to render successfully.

Excel & Data Problems