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.
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.
- First and foremost, click on the File tab from your Excel ribbon.
- Afterward, click on the Save As option from the expanded File tab.
- As a result, the Excel Save As window will open. Subsequently, click on the Browse option from this 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.
- As a result, there will be several options in a dropdown list. Choose the option Web Page (*.htm;*.html)
- Now, the updated Save As dialogue box will appear. Subsequently, click on the Save button.
- At this time, there will be a Microsoft Excel dialogue box asking you about the format change. Click on the Yes button.
- As a result, you will see there will be a new folder created upon the Excel file.
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.
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.
- At the very beginning, right-click on your Excel file with the mouse.
- Subsequently, choose the Rename option from the context menu.
- Afterward, remove the .xlsx extension from the name and add the .zip extension at the file name. Subsequently, press the Enter button.
- At this time, a Rename warning dialogue box will appear. Click on the Yes button.
- As a result, you can see that the Excel file is converted into a zip file now.
- Now, right-click your mouse on the Excel file and choose the Extract Here option from the context menu.
- 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.
- Afterward, double-click on the media folder inside the xl folder.
As a result, inside the media folder, you can see the images of your Excel file are saved here.
- 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.
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.
- First, select the image you want to save and click your right-mouse button.
- Afterward, choose the option Save as Picture… from the context menu.
- 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.
- Consequently, you will see the image is saved in your chosen directory.
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.
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!