When working with various stores or tasks that require previewing images in worksheets, using xlsx format files to collect images facilitates data transfer. However, many workbook files contain images represented as hyperlinks such as urls, which results in only seeing text and links when previewing the file, without any visual images. This forces you to open each link individually to view, identify, and distinguish them, significantly impacting your efficiency. Below is an introduction on how to convert all url links within cells of multiple Excel worksheet files into images for display.
1. Use Cases
When an xlsx file contains many image URL links, they can be uniformly converted into viewable jpg images based on the web links step by step.
2. Preview
Before processing:
After processing:
3. Steps
Open HeSoft Doc Batch Tool , select [Excel Tools] - [Convert Image Addresses to Images in Excel].
[Add File] adds one or more xlsx files that require link-to-image conversion.
[Import Files from Folder] imports a folder containing a large number of xlsx files that require link-to-image conversion.
You can also drag and drop files directly below.
[Processing Range] selects all cells.
[Image Saving Location] selects cover cells.
[Fixed Image Cell Width and Height] enter the desired image width and height as needed.
After processing is complete, click the save location to view the converted Excel spreadsheet file.
