If you want to quickly extract pictures from an Excel file that embedded many pictures, you cannot be simply to do this. There's no build-in function to do this in Excel. Here are two simple ways to quickly extract pictures from an Excel file.
1. Open your Excel file, click File tab, choose Save As, in the Save As window, click the drop-down menu labeled Save as type:, scroll down and choose Web Page (*.htm;*.html), Click Save.
When a web page is saved in a computer two files are actually generated. One is the html file, and another is a folder that contains all the images and other component files that are a part of the web page. For example, an Excel file named Products.xls saved as a web page will generate Products.htm and a folder labeled Products_files. If Products.xls contained images, these images will now be in the Products.xls_files folder. Now, open Products.xls_files folder, you will sell all the pictures.
2. Change the Excel file extension (only available with .xlsx) as a RAR file, For example, change Products.xlsx to Products.rar, extract the Products.rar file, you will see 3 folders (_rels, docProps and xl) and 1 xml file ([Content_Types].xml), open xl folder, open media folder, you will sell all the images in the media folder.
I tried this solution but for some reason it saves each image twice. Any Idea why that might be?
Thanks
awesome solution so far! you rock! 🙂
This is a bad solution as the images are extracted using the resolution of the cell and not the source image.
@Michael Nolsøe Madsen Hi Michael.. then what you do, is first change the size of all pictures quickly. press F5 and choose to select all objects. then in the picture tools all the way on the right choose a size for the width, let's say 5" and then follow the procedure above, which btw is an excelent solution!
@Keshav Hi Keshav,
Thanks so much, you make life easier. =)
@Keshav This page was VERY HELPFUL, especially your suggestion about using F5 to select all, then resizing to a common width. Thanks