Save picture inserted in Excel document as file

In everyday office work with Excel it can happen that you receive an Excel file in which pictures are inserted. If you want to save these pictures as an image file, e.g. *.jpeg or *.png, you have a problem.

Save as image file not possible

Unfortunately, Excel does not offer a direct way to save one or more images inserted into the Excel document. In Word, for example, this is easily possible by right-clicking on the image and then selecting “Save as graphic…. In Excel, unfortunately, this function is missing in the context menu.

Screenshot Excel document: no possibility to save the inserted image directly
no option to save the pasted image

In the following we show four possibilities to save the picture of the Excel document locally nevertheless.

Procedure 1: Copy and paste image

With this method, you also right-click on the image in question to select it. In the context menu that then opens, select “Copy”.

Then open a graphics program of your choice, in our example the Windows program “Paint” was started. There you can paste the copied image or directly via the key combination “Ctrl+V”.

Copy screenshot image to Excel file and then paste into Paint
Copy image within Excel file and then paste into a drawing program

Now the image can be saved via “File” ­čáŐ “Save as” in any image format as a JPG or PNG file in a local folder. It is quicker again with the key combination “Ctrl+S”.

Procedure 2: Rename Excel file to Zip file

Many people are probably not aware that modern Office file formats, such as an Excel file, are actually many individual files and folders packed into a ZIP file. For this reason, you can simply rename the Excel document in which the inserted pictures are located into a ZIP file. This is also excellent for saving all the images of an Office document, such as Word, at once and making them available for further processing.

To do this, first use the rename function (right-click on the file in Windows Explorer) to change the file extension from “xlsx” to “zip”. If necessary, simply copy the Excel file before renaming it, if you are worried about damaging the original file in some way.

Change file extension to zip file
Rename Excel file to a zip file

You can then unzip the zip file or navigate directly within the zip file. Under the folder path “xl/media” you will then find all the image files contained in the Excel document and can copy out the images you need.

Windows Explorer with open zip file and media folder
navigate to “media” folder in zip file

Now the image or images can be used like any other image file on the computer.

Procedure 3: Take screenshot/screen capture

Admittedly, this is not the prettiest method and is similar in some ways to Procedure 1. But there is still the option of taking a screenshot and then pasting the screen capture into a graphics program such as “Paint”.

You can take a screenshot with the press key. This will take a picture of the entire screen and paste it into the clipboard. With “Ctrl+V” you can now paste it into Paint as described above. The disadvantage is that you have first captured the entire screen and then have to crop the image to the desired image in the Excel program.

Alternatively, you can use the “Snipping Tool”, which is installed by default under Windows. Simply enter “Snipping…” in the Windows search and open the “Snipping Tool”.

Enter snipping in Win menu and start snipping tool
Open snipping tool via Windows menu

 

In the “Snipping Tool” then click on “New” and then with the mouse button held down, drag the frame to capture around the desired image in the Excel file. When you release the mouse button, the image of the drawn frame is copied to the clipboard.

Screenshot application of the snipping tool in Excel
Drag snipping tool “New” and frame over Excel image to capture

Now you can paste the image from the clipboard back into any graphics program as described above and save it there as an image file.

Procedure 4: Save as web page

Many roads lead to Rome, and so there is another workaround. The Excel document in question can also be saved as an HTML page.

To do this, go to “File” ­čáŐ “Save as” and select “Web page (*.htm, *.html)” as the file type, give it a suitable name and select the desired storage location.

Screenshot Excel save as web page
Save the Excel document as a web page

Under the chosen storage path, you will then find a htm-file as well as an associated folder containing all other files, including the image files, that are needed to display the Excel document as a web page.

HTML file and associated folder in Windows Explorer
Images are located in the associated folder of the web page

If you now open the relevant folder, you will find the pictures contained in the Excel document in file format and can copy them for further use.

Screenshot of the image and media files of the website
Image files for the website

As you can see, the original files are saved on one side and a merged file of the images on the other side. This was done by Excel so that the presentation as a web page is exactly the same as in the Excel file.

Leave a Reply

Your email address will not be published. Required fields are marked *