When we need to export all images from an Excel spreadsheet for archiving or other purposes, many people only know how to manually select and save each image one by one. When dealing with hundreds of images or Excel files, it can take days to finish. Below are three methods to batch export images from Excel, and you can even specify a column in the table to automatically name the images. A fully automated process to free your hands!
In our daily work and life, we often encounter a situation where we need to extract all images from an Excel spreadsheet and use the corresponding information for those images as their file names.
For example, a company's employee information sheet or a school's student roster typically contains basic personal information along with ID photos. We need to batch export everyone's photos to a computer and name them after each person's name for easy uploading into other systems.
In the e-commerce industry, spreadsheets are frequently used to record product information and images. Often, you need to batch export all product images to a computer and automatically name them by the product name. Or, if a spreadsheet contains numerous reimbursement receipts, you need to batch export these receipts and name them by the claimant or reimbursement number.
Anyone can manually save and rename images, but when dealing with a large number of files, doing them one by one is undoubtedly time-consuming and laborious. Therefore, it is essential to learn how to batch export Excel images and put an end to this repetitive, meaningless task.
Preview of the Effect of Batch Extracting Excel Images and Auto-Naming
Before processing:
After processing:
Method 1: Use HeSoft Doc Batch Tool
Recommendation Index: ★★★★★
Pros:
Can export all images from an Excel spreadsheet with one click, and also supports batch image export from hundreds of Excel files.
Allows for custom image naming; exported images can use a default name or a specified column as the image name.
Easy to operate, no coding or scripting required, can be done effortlessly with just a few mouse clicks.
Cons:
Requires installation on a computer and only supports Windows systems.
Steps:
1. Open HeSoft Doc Batch Tool , select Excel Tools → Export images from Excel cells.
2. Add all the Excel files; you can add them manually or simply drag and drop the files in.
3. Choose to use the cell content from a certain column as the file name, and specify that column according to your needs. We'll use column A as an example.
4. Once processing is complete, click directly to view the save location. All images from the Excel spreadsheet have been exported and automatically named using the cell content from column A.
Method 2: Save Excel as an HTML Web Page
Recommendation Index: ★★★☆☆
Pros:
No need for other tools; Excel has a built-in function to export as an HTML web page, simple and direct.
Does not require a network connection, making this method more effective if other software installation is prohibited on the computer or if it's on a company intranet.
Cons:
Exported images are named by default as image001, image002, etc., and cannot be named based on cell content.
Steps:
Open the Excel file, click File → Save As, and choose the HTML web page format. A folder with the same name will be automatically generated, containing all the images. You will then need to manually rename each image one by one.
Method 3: Use VBA Macro to Export and Auto-Name with One Click
Recommendation Index: ★★★☆☆
Pros:
Can export all images from an Excel spreadsheet with one click, also supports batch processing of multiple files, and has a high degree of automation.
While exporting images, it can automatically rename them based on cell content, eliminating manual operation.
No other tools needed; just open the VBA macro directly in Excel and paste the code to automatically export images.
Cons:
Operation is relatively difficult because it involves code, making it easy for beginners to make mistakes and cause other troubles.
Steps:
1. Place the Excel files you want to extract images from into the same folder, then create a new Excel file in .xlsm format.
2. Open this xlsm file, press Alt + F11 to open the VBA editor, click Insert → Module, and then paste the code.
3. Return to Excel, press Alt + F8 to select the newly created module, and run it. Then choose the folder where the Excel spreadsheets are stored, and the macro will automatically export the images from each Excel file for you.
