Skip to main content

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

Author: Xiaoyang Last Modified: 2023-03-03

Kutools for Excel

Boosts Excel With 300+
Powerful Features

How can we insert pictures into cells by matching cell values and picture names in Excel? For example, I have a list of product names in Column A, to quickly insert corresponding product pictures beside the names, the Match Import Pictures utility of Kutools for Excel can do you a favor.


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

shot match import pictures 1


Import pictures by matching cell values and picture names, please do as follows:

1. Select the cell values based on which you will insert pictures. And then Click Kutools Plus > Import & Export > Match Import Pictures.

Note: You can also click the Match Import Pictures feature, and then click the range-selecting icon shot match import pictures icon beside the Match range to select the cell values based on which you will insert pictures.

2. In the pop-up Match Import Pictures dialog box, you will see the cell values listed in the Match range column as shown in the red box below. Now, you can set the import size and import order as you need in More options section.

shot match import pictures 2

Note: There are three size options:
  • Matching itself size: By checking this option, all the pictures will be inserted keeping their own size.
  • Matching cell size: This option will size the imported pictures to fit into the selected cells.
  • Specify size: You can specify the height and width of the pictures with this option. Note that the height should not be greater than 409 pixels, and the width should not be greater than 1342 pixels.

3. Click Add > File or Folder to choose the pictures that you want to insert as shown below.

shot match import pictures 3

4. Now, you will see the pictures are listed in the Picture column with their names matching the cell values. Click Import, and then select the first cell of the range where you will insert the pictures to.

shot match import pictures 4

Note:
  • You can delete the pictures you don't want to insert by selecting it and clicking the Remove shot match import pictures remove button.
  • To remove all pictures, select the Remove all shot match import pictures remove all button.

5. All the pictures are inserted with their names matching the cell values, see screenshot:

shot match import pictures 8-8

Tips: In the above example, I selected Fill vertically cell after cell from the Import order menu. You can also insert the pictures horizontally based on the cell values as shown below by selecting the Fill horizontally cell after cell option.

shot match import pictures 9-9


Notes:

1. If there are no pictures' names matching any of the cell values, then no pictures will be inserted.

2. By checking the Case sensitive option in the dialog box, the utility will perform a case-sensitive match.

shot match import pictures 11

3. This utility supports importing pictures to multiple ranges even if the ranges have filtered/hidden rows.

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

Match import pictures


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 30 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

 

Comments (7)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Hi, this one doesn't work on combined cells. Is it possible to make it available for combined cells?
Besides, I want the picture to be changed when I change the source cell.
If I edit Cat1 to Dog2 the picture should be changed automatically.

If anyone knows how I can do this, can you please help me?

Thanks
This comment was minimized by the moderator on the site
Hello, Engin,
Sorry, our current feature does not support cell merging.
As for how to change the corresponding picture based on the changes in the cell, we recommend that you use our picture drop-down list feature. With this feature, you can easily update the pictures based on the cell content. Please view the following article:
https://www.extendoffice.com/product/kutools-for-excel/excel-drop-down-list-with-images.html
This comment was minimized by the moderator on the site
if you need an illustration of what I mean - here:-
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
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
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?
There are no comments posted here yet
Load More
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations