Batch convert http URL links in dozens of Excel spreadsheet cells into images
Translation：简体中文繁體中文EnglishFrançaisDeutschEspañol日本語한국어，Updated on：2025-01-21 15:03，Editor-in-Chief：system
Summary：When working with various stores or tasks that require previewing images in spreadsheets, after collecting images using xlsx format files for easier data transmission, many workbook files use URLs or other hyperlinks to replace images. This results in only seeing text and links during file preview, without visualized images. You have to open each link individually to view, identify, and distinguish, which greatly affects efficiency. Below is an introduction on how to convert all URL links in the cells of multiple Excel spreadsheet files into images.
1、Usage Scenarios
There are many image URL links in the xlsx file, which can be uniformly converted into visualized jpg images sequentially according to the URL links.
2、Preview
Before Processing：
After Processing：
3、Operation Steps
Open 【HeSoft Doc Batch Tool】, select 【Excel Tools】 - 【Convert Image URLs in Excel to Images】.
【Add File】Add one or multiple xlsx files that need links to be converted into images.
【Import Files from Folder】Import a folder containing a large number of xlsx files that need links to be converted into images.
You can also drag and drop files directly below.
【Processing Range】Select all cells.
【Image Save Location】Choose to overwrite cells.
【Fixed Image Cell Width and Height】Enter the width and height of the image according to your needs.
After the processing is complete, click the save location to view the converted Excel spreadsheet file.
