Many xlsx table files choose to specify a column of http picture URL links to override and delete the corresponding right cell to convert to jpg picture
Translation：EnglishFrançaisDeutschEspañol日本語한국어，Updated on：2025-06-07 20:20
Http URL links in Excel tables reduce the size of files and enhance the mutual data transmission between worksheet files. When visualizing links in tables, all these picture url links need to be converted into picture forms. If there are url picture URL links in multiple columns of cells, we only need to take one of the corresponding cells on the right to convert them into pictures in the links, and we also need to keep the original URL links. How should we operate? The following describes how to batch generate jpg pictures by linking multiple xls and xlsx table files with a single column of http picture web addresses to overwrite and delete the corresponding right cell, and keep the converted picture web address links unchanged.
1. Use Scenarios
the pictures in the http URL link of any column in the Excel worksheet file are generated in the form of covering the cell on the right, and the http URL link of this column is retained.
For example, there are web address links in columns B, D and F in the table, and pictures of these links need to be generated on the right side of the http web address links in column D.
After the conversion is completed, the http website link of column d will remain unchanged, and the cell contents corresponding to column e will be overwritten and deleted into the picture in column d link.
2. Effect preview
before treatment:
after treatment:
3. Operation steps
open 【HeSoft Doc Batch Tool], select [Excel Tools]-[Convert Picture Address in Excel to Picture]].
[Add File] Add single or multiple xlsx files that need to be converted from URL links to pictures.
[Import File from Folder] Import a large number of folders that require URL link conversion image xlsx files.
You can also choose to drag files directly below.
[Processing Range] Select a fixed column and select the column that needs to convert http URL links into pictures under the column name.
[Picture Save Location] Select to overwrite the right cell and also support overwriting the left cell.
[Fixed picture cell width and height] Enter the width and height of the picture according to your own needs.
After waiting for the processing to complete, click Save Location to view the converted Excel spreadsheet file.
