How to extract only the images used in Excel files

This is a useful method if you have a large number of images in the excel file sent to you and you want to save those images in bulk.

To extract only the images used in Excel, follow the steps below.

• Display the extension of the target file.
• Change the extension of the Excel file to .zip, then unzip the file.
• If you move from xl to media in that folder, the image file is saved.

If you don't have a large number of images in Excel, you can save them by right-clicking on only the images you want to save and selecting Save as Picture.

On this page, I will explain in detail how to easily extract only the images used in the Excel file.

This site is run by Japanese.
All the procedures explained on this site are compatible with Japanese Windows OS.
My translation and operational mistakes may have an unexpected negative effect on your computer.
Please use the site at your own risk.

I try to explain and translate as carefully as possible, but if there are any mistakes in my explanation or translation, please let me know in the comments.

Display the extension of the target file.

To extract only the images used in the Excel sheet, you need to change the extension of the Excel file.
The method of displaying the extension is introduced here, so please have a look if the extension is not displayed.

あわせて読みたい

How to display file extensions and hidden files on your computer This page details file extensions and how to easily display hidden files. extensions Open explorer from taskbarGo to [View] → [View] and select [File Name Ex...

Change the extension of the Excel file to Zip file

Once you can see the file extension, change the Excel file extension from [.xls] or [.xlsx] to [.zip].

If you change the file extension, you will not be able to open it in Excel.
If you want to use the Excel file itself afterwards, I recommend duplicating the file in advance.

First of all, Right-click on the target file.
A menu expands down, click Show More Options in it.

Click Rename.

You can also rename the keyboard shortcut with the [F2] key.

Change the file extension to [.zip]

[If you change the extension, the file may become unusable. Do you want to change it? ] Message is displayed.
The meaning of this message is "If you change the extension, you will not be able to open it in Excel anymore."

This time, the purpose is to extract the image from the Excel file, so click [Yes].

If you forget to back up, you can make it an Excel file by changing the extension to [.xlsx].

Unzip the ZIP file and extract image files

This is the final step.
Unzip the zip file and extract the image file saved in the Excel file.

First of all, Right-click on the target file.
A menu expands down, click [Expand All].

[Choose a destination and extract files] is displayed.

Select the save destination and click the [Expand] button.

After clicking [Extract], Explorer will be launched.
You can find the folder labeled [xl] and click on it.

Inside the [xl] folder is a folder named [media]. Click on it to open it.

The image files are saved in the [media] folder.
These image files are the image files used in Excel.