How to Quickly Extract Pictures From An Excel File

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.

How 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.

Save as Web Page File

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.

All images in Web Page File
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.

All images in media folder

Leave a Reply

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

51 comments
  1. Tomov, Bulgaria
    Tomov, Bulgaria

    Thank you! This is very helpfull for me and my work! Thank you!

  2. TBomb
    TBomb

    This is great. thanks.

  3. avinash
    avinash

    This is simply awesome solution.

  4. akshay
    akshay

    duplicate images will be copied once only.

  5. Yanir
    Yanir

    is there anyway to rename the images according to specific column ?

    • Abdel
      Abdel

      @Yanir Hi Yanir,

      Did you find how to rename the image according to specific columns ?

      Thanks.

  6. Dave-o
    Dave-o

    awesome! thanks

  7. Sarah
    Sarah

    Thanks a lot! So helpful.

  8. lucy
    lucy

    Thank you, this is brilliant!

  9. jignesh patel
    jignesh patel

    Yes , We got our jpg file, but We need to save that JPG file to particular field. In this example Column A is model name, so jpg file will save that name.

    • Abdel
      Abdel

      @jignesh patel Hi,

      Did you find how to rename the image according to specific columns ?

      Thanks.

  10. Edgar
    Edgar

    Thank you for saving me days of work.