Function Problems

How to Display Images from a CSV File in Excel

Aamir Naveed Akram Sep 25, 2026 869 views

Question details

The user needs to display actual thumbnail images in an Excel spreadsheet when working with a CSV file that contains image URLs or file paths.

How to Display Images from a CSV File in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Importing or opening a CSV file containing image links and needing to render those links as visible pictures within the spreadsheet.
Observed behavior: The CSV file currently displays text-based URLs or file paths, and the goal is to convert these into visible images directly inside the Excel cells.

Before you start

Ensure you have an active internet connection if your CSV file contains web-based image URLs, and verify that the links point directly to supported image formats such as JPG, PNG, or BMP.

Solution 1Recommended

Use the Excel IMAGE Function to Render URLs

The most efficient way to display images from web URLs in Excel is by utilizing the built-in IMAGE function.

The IMAGE function allows you to insert images directly into cells from a source URL, along with optional parameters for alternative text and sizing. Note that this feature is available in Microsoft 365 and Excel for the web.

Open your CSV file

Launch Excel and open your CSV file so that the image URLs populate into a column (e.g., Column A).

Enter the IMAGE formula

Select a blank cell adjacent to your first image URL (e.g., Cell B2). Type the formula =IMAGE(A2) and press Enter. The image should now load into the cell.

Apply to all rows

Click the cell with the loaded image, grab the fill handle in the bottom right corner, and drag it down to apply the formula to the rest of the rows containing URLs.

Use the Excel IMAGE Function to Render URLs

URL Requirements: The IMAGE function only supports HTTPS URLs. Local file paths (e.g., C:\images\pic.jpg) are not supported by this specific function.

Solution 2

Use a VBA Macro for Local File Paths

If your CSV contains local computer paths instead of web URLs, you can use a VBA macro to automate inserting the pictures.

WPS Spreadsheet Solution

Easily Manage CSV Files and Insert Images with WPS Spreadsheet

WPS Spreadsheet provides powerful data management tools, allowing you to easily import CSV files and insert images into cells. Whether you are using URLs or local files, WPS Office makes spreadsheet visualization effortless.

1. Open the CSV in WPS Spreadsheet: Launch WPS Office and open your CSV file directly in the Spreadsheet application.
2. Prepare the columns: Adjust the column widths and row heights to ensure there is enough space to display your image thumbnails properly.
3. Insert images into cells: Navigate to the 'Insert' tab. For local files, you can use the 'Picture' tool to directly embed images. For web URLs, you can utilize compatible web image formulas.

Seamless compatibility with Microsoft Office formats, including .csv and .xlsx files.Built-in tools for easily inserting and resizing images into cells.Lightweight, fast, and completely free to use.Familiar user interface requiring no steep learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the Excel IMAGE function returning a #VALUE! error?

This error usually occurs if the URL does not point directly to a supported image file format, the link is broken, or the URL uses HTTP instead of the required HTTPS protocol.

Can I use the IMAGE function to display pictures stored on my computer?

No, the built-in Excel IMAGE function currently only supports internet-based HTTPS URLs. To display local files from a CSV path, you will need to manually insert the images or run a VBA macro.

How do I resize the thumbnail images loaded by the IMAGE function?

By default, the IMAGE function fits the picture within the cell while maintaining its original aspect ratio. You can change the size of the image by dragging the row and column boundaries, or by using the function's optional height and width parameters.

Excel & Data Problems