Note: The other languages of the website are Google-translated. Back to English
English English

Quickly insert multiple pictures into cells based on cell value in Excel

How can we insert pictures into cells based on cell value in Excel? For example, I have a list of product names in Column A, and now I want to insert related product pictures into the cells based on the cell values. Let’s say the cell A2 is Orange, and I want to insert the picture which name is Orange. The Match Import Pictures utility of Kutools for Excel may help you to solve this problem quickly and easily.

Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
  • Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
  • More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
  • Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
  • Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
  • Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
  • Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
  • More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.

Click Kutools Plus >> Import & Export >> Match Import Pictures. See screenshot:

shot match import pictures 1

Import multiple pictures based on cell values

1. Apply this utility by clicking Kutools Plus > Import & Export > Match Import Pictures, in the Match Import Pictures dialog box, click shot match import pictures 3 button under the Match range to specify the cell value that will be based on to import the images, the image files which match the cell values will be listed into a list accordingly. You can also specify the import pictures order as your need, in this case, I will choose Fill vertically cell after cell from the Import order drop down.

shot match import pictures 2-2

2. Then click Add > File or Folder to choose and insert the pictures that you need into the list box, see screenshots:

shot match import pictures 4-4
shot match import pictures 5

Tips: You can delete the pictures you don’t want to insert by selecting it and clicking Remove button.

3. After inserting the pictures, all relative pictures are listed into the list box, and then you can specify the size of the images by clicking Import size button, in the following Import Picture Size dialog, specify one option for the size of your pictures. See screenshot:

shot match import pictures 6-6

Tips: In the Import Picture Size dialog:

(1.) Matching itself size: With checking this option, all the pictures will be inserted with their own size, but if the height of picture is greater than 409 pounds or the width of picture is greater than 1534 pounds, it will not be inserted successfully.

shot match import pictures 10

(2.) Matching cell size: This option will make the imported pictures size as the same as the selected cells.

(3.) Specify size: You can specify the height and width of the pictures, the height should not equal or greater than 409 points, and the width should not equal or greater than 1534 points.

4. Then click Ok > Import, choose one cell or a list of cells to locate your relative images from the popped out Match Import Pictures dialog (you can also select the original cell of the text), see screenshot:

shot match import pictures 7-7

5. And then click OK button, all the pictures which matched with the cell values have been inserted into the worksheet, see screenshot:

shot match import pictures 8-8

Tips: with this feature, you can also insert the pictures horizontally based on the cell values, please just select the Fill horizontally cell after cell from the Import order drop down list, and you will get the following results:

shot match import pictures 9-9


1. If there are no matched pictures with the cell value, nothing will be inserted in the cell.

2. If you check Case sensitive option in the dialog box, the name of the picture must be case sensitive with the cell values, otherwise, the images will not be inserted.

shot match import pictures 11

3. If there are duplicate cell data in the list, you need to insert the pictures time and time again to import other duplicate corresponding pictures.

4. This utility supports Undo (Ctrl + Z).

Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Comments (5)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Please extend this to all file types, not only pictures. "Match Import Files".
This comment was minimized by the moderator on the site
After you completed the match import function, how can you edit it? For example, when you need to switch photos, or you need to change the name of the column of excel worksheet?
This comment was minimized by the moderator on the site
issue with it: my folder has over 10k pictures so it cant import - what is the picture count limit per folder? i can probably divide them up! thank you!!
This comment was minimized by the moderator on the site
not great TBH, it populates a column of cells but by the time it gets to cell 100, they are no longer in the cell, they overlap slightly,and they aren't locked to the cell. So resizing cells screws it up. feels like a half finished fudge. waste of 49$
This comment was minimized by the moderator on the site
if you need an illustration of what I mean - here:-
There are no comments posted here yet
Leave your comments
Posting as Guest
Rate this post:
0   Characters
Suggested Locations