How to Extract and Save Images Embedded in an Excel File

You have an Excel workbook containing pictures, logos, or charts that you need to use outside of Excel. These images are embedded within the file, making them difficult to access individually. Excel does not have a built-in one-click feature to export all images at once. This article explains several methods to extract and save these embedded images as separate files on your computer.

Understanding How Excel Stores Embedded Images

When you insert a picture into an Excel worksheet, the application embeds the image data directly into the workbook file. The image is not linked to an external source. Modern Excel files with the .xlsx, .xlsm, or .xlsb extensions are actually compressed archives containing multiple folders and XML files. Your embedded images are stored within a specific folder inside this archive, typically named “xl/media”. To extract them, you need a method that can access this internal storage. Before starting, ensure you have a saved copy of your workbook. Some methods, like saving as a web page, will create new files but will not alter your original Excel file.

Methods to Extract and Save Images

You can use different techniques depending on whether you need all images or just a few. The Save As Web Page method is best for bulk extraction. The manual copy method works for one or two images. The rename-to-ZIP method is a direct technical approach.

Method 1: Save the Excel File as a Web Page

This method creates an HTML file and a companion folder with all images.

1. Open your workbook in Excel
   Launch Excel and open the file containing the images you want to extract.
2. Click File > Save As
   This opens the Save As dialog box.
3. Choose a save location and select a file type
   In the “Save as type” dropdown menu, select “Web Page (*.htm; *.html)”.
4. Click Save
   Excel will save two items: an .htm file and a folder with the same name followed by “_files”.
5. Locate the image folder
   Navigate to your save location using File Explorer. Open the “[YourFileName]_files” folder. Inside, you will find a subfolder named after the worksheet containing your images. All extracted pictures will be there in .png or .jpg format.

Method 2: Copy and Paste an Image into an Image Editor

Use this for quick extraction of individual images.

1. Select the image in Excel
   Click once on the embedded picture in your worksheet to select it.
2. Copy the image
   Right-click the selected image and choose Copy, or press Ctrl+C on your keyboard.
3. Open an image editing application
   Open Microsoft Paint, Photoshop, or any other image editor. You can also paste directly into a Word document or PowerPoint slide.
4. Paste and save the image
   In the image editor, press Ctrl+V to paste. Then use File > Save As to save the image in your desired format like .jpg or .png.

Method 3: Rename the Excel File to a ZIP Archive

This method directly accesses the internal file structure.

1. Close the Excel workbook
   Ensure the file is not open in Excel.
2. Locate the file in File Explorer
   Find your .xlsx or .xlsm file on your computer.
3. Change the file extension
   Click on the file name once to select it. Click again on the name to edit it, or press F2. Change the “.xlsx” part at the end to “.zip”. Press Enter. Windows will warn you; click “Yes” to confirm.
4. Open the ZIP file
   Double-click the new .zip file to open it like a folder.
5. Navigate to the image folder
   Open the “xl” folder, then the “media” folder. All embedded images from the workbook will be listed here.
6. Extract the images
   You can drag the image files from the media folder to any location on your desktop or documents folder. Remember to rename your .zip file back to .xlsx to open it in Excel again.

Common Mistakes and Limitations

Images Are Blurry or Low Quality After Extraction

Excel sometimes compresses images to reduce file size. When you extract them, you get the compressed version. To avoid this, before extracting, right-click the image in Excel, select Format Picture, go to the Size & Properties icon, and under Picture, set “Compress pictures” to “Do not compress images in file”. Save the workbook and then use an extraction method.

The .zip Method Does Not Show a Media Folder

If the xl/media folder is empty or missing, the images might be in a different format. Charts or SmartArt graphics are not stored as standard image files. They are recreated from data each time you open the file. You must use the copy-paste method for these objects.

Extracted Images Have Generic Names Like image1.png

Excel does not preserve the original image file names when embedding. All extracted images will have system-generated names. You will need to rename them manually after extraction.

Extraction Method Comparison

Item	Save As Web Page	Copy and Paste	Rename to .zip
Best For	Extracting all images at once	Extracting one or two specific images	Technical users who need direct access
Image Quality	Matches Excel display quality	Can be pasted at high resolution	Original embedded quality
Speed	Fast for many images	Fast for single images	Moderate, requires file navigation
File Name Preservation	No, generic names assigned	You name the file on save	No, generic names assigned
Works with Charts/SmartArt	No, exports as static image	Yes, as a copied picture	No

You can now extract any picture from your Excel workbooks for use in reports, presentations, or websites. For bulk operations, the Save As Web Page method is the most reliable. If you frequently work with many images, consider using a dedicated batch image extraction tool. A useful advanced tip is to use the .zip method to also extract other embedded objects, like Excel macros stored in the xl/vbaProject.bin file.