When you need to extract images from cells in an Excel worksheet for separate saving, having too many images in the sheet and saving them one by one is extremely inefficient. If the images need to be exported with the text from a specific column in the Excel workbook as the filename, renaming them individually is even more tedious. The following explains how to batch export a large number of image files from Excel spreadsheets using cell text content as the filename.
1. Use Cases
Export images from xlsx or xls files, using the text content of any column as the file name.
For example: Images in an Excel worksheet are in column C, while columns A and B both contain text content.
At this point, you need to use the text A1, A2, A3 in column A as the image file names.
The exported images will then be A1.jpg, A2.jpg, A3.jpg.
2. Preview of Results
Before processing:
After processing:
3. Steps
Open 【 HeSoft Doc Batch Tool 】, select 【Excel Tools】-【Export Images from Excel Cells】.
【Add Files】 Add one or more xlsx or xls files from which you need to export images within cells.
【Import Files from Folder】 Import a folder containing a large number of xlsx or xls files from which you need to export images within cells.
You can also drag files directly into the area below. Then click Next Step.
【File Name Type】 Select to use the cell content of a specific column as the file name, then choose the column for the file name under 【Column Name】 below.
After processing is complete, click the save location to view the exported image files.
