Save Picture from Excel to Folder (3 Simple Ways)

Get FREE Advanced Excel Exercises with Solutions!

When using Excel files, sometimes we have to deal with several pictures embedded in the file. Sometimes, we fall in dire need to save those pictures in a folder. In this article, I will show you 3 simple ways to save picture from Excel to a folder.


Download Practice Workbook

You can download and practice from our workbook here for free!


3 Simple Ways to Save Picture from Excel to Folder

Say, we have an Excel file containing some images. Now, we want to save the images in an external folder. You can follow any of the 3 easy ways below to do this. Here, I have used the Office 365 version of Microsoft Excel. You can apply any of these ways for any other version available to you too. If you face any problem applying these ways, please let me know in the comment section.

Pictures that Need to be Saved


1. Format Excel File as Web Page to Save Picture to Folder

The most common way to save picture from Excel to folder is to save the file as as a Web Page file. Follow the steps below to accomplish this.

📌 Steps:

  • First and foremost, click on the File tab from your Excel ribbon.

Access the File Tab

  • Afterward, click on the Save As option from the expanded File tab.

Choose the Save As Option

  • As a result, the Excel Save As window will open. Subsequently, click on the Browse option from this window.

Excel Save As Window

  • At this time, the Save As dialogue box will appear.
  • Now, write your file name at the File name: text box and click on the Save as type: box.

Save As Dialogue Box

  • As a result, there will be several options in a dropdown list. Choose the option Web Page (*.htm;*.html)

Save as Web Page Type to Save Picture from Excel to Folder

  • Now, the updated Save As dialogue box will appear. Subsequently, click on the Save button.

Click on the Save Button to save Pictures from Excel to Folder

  • At this time, there will be a Microsoft Excel dialogue box asking you about the format change. Click on the Yes button.

Confirm the Save to Save Picture from Excel to Folder

  • As a result, you will see there will be a new folder created upon the Excel file.

New Folder Created

In this folder, there will be all your images of the Excel file. To be sure, you can double-click on the created folder and thus you can see there are the images.

Picture Saved from Excel to Folder

Read More: How to Save Image from Excel as JPG (4 Simple Ways)


2. Use .zip File Extension

Another easy way to save pictures from Excel to folder is to use the .zip file extension. Go through the steps below to achieve this.

📌 Steps:

  • At the very beginning, right-click on your Excel file with the mouse.

Right Click on Excel File

  • Subsequently, choose the Rename option from the context menu.

Choose Rename Option

  • Afterward, remove the .xlsx extension from the name and add the .zip extension at the file name.  Subsequently, press the Enter button.

Change the Extension of the File to Save Picture from Excel to Folder

  • At this time, a Rename warning dialogue box will appear. Click on the Yes button.

Confirm the Rename to Save Picture from Excel to Folder

  • As a result, you can see that the Excel file is converted into a zip file now.

Converted Zip File

  • Now, right-click your mouse on the Excel file and choose the Extract Here option from the context menu.

Extract the Zip File to Save Picture from Excel to Folder

  • As a result, you will see that, several folders and files pop up after extracting. Thus, your images are saved in any of the folders present here. To find the directory, double-click on the xl folder.

Go to the xl Folder

  • Afterward, double-click on the media folder inside the xl folder.

Go to the Media Folder

As a result, inside the media folder, you can see the images of your Excel file are saved here.

Saved Pictures from Excel to Folder

Note:

  • Copy your Excel file before converting it into a zip file. Otherwise, you may lose your original Excel file.
  • If you find trouble to find the extension in the file name, go to your File Explorer >> View option >> Show/hide group >>  put tick mark on the File name extensions.

Enable File Name Extension of Your PC


3. Using the ‘Save as Picture’ Option

Moreover, you can save picture from Excel one by one to a folder using the Save as Picture option. Follow the steps below to do this.

📌 Steps:

  • First, select the image you want to save and click your right-mouse button.

Right-click on the Desired Image

  • Afterward, choose the option Save as Picture… from the context menu.

Choose the Save as Picture to Save Picture from Excel to Folder

  • As a result, the Save As Picture window will open.
  • Subsequently, browse the directory where you want to save the picture >> write the file name in the File name: text box >> click on the Save button.

Save Picture from Excel to Folder

  • Consequently, you will see the image is saved in your chosen directory.

Saved Picture in Desired Folder

Similarly, save all the images in the same directory and thus, you will get all the images saved in a single folder as your requirements.

All Pictures Saved from Excel to Folder


Conclusion

To sum up, in this article, I have shown you 3 simple and easy ways to save pictures from Excel to a folder. I suggest you read the full article carefully and practice with our free workbook given. I hope you find this article helpful and informative. If you have any further queries or recommendations, please feel free to comment here.
And, visit ExcelDemy for many more articles like this. Keep learning new things and keep growing! Thank you!


Related Articles

Tanjim Reza

Tanjim Reza

Hello! I am Md. Tanjim Reza Tanim. I have just completed my B.Sc from Naval Architecture & Marine Engineering Department, BUET. Currently, I am working as an Excel & VBA content developer. I always had a great fascination with Microsoft Excel and its cool functions and formulas. Here, I am learning every day about new functions and formulas and working on applying MS Excel to the analysis of our real-life problems. I have great enthusiasm for learning any kind of new things, writing articles, and solving real-life problems.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo