Select a specified column in many xlsx spreadsheet files with http image URLs, overwrite and delete the corresponding right-side cell to convert them into jpg images
Translation：简体中文繁體中文EnglishFrançaisDeutschEspañol日本語한국어，Updated on：2025-02-07 17:29
Summary：In Excel spreadsheets, http URLs reduce file size and enhance data transfer between worksheets. When visualizing links in the spreadsheet, it's necessary to convert these image URL links into image forms. If multiple columns contain URL image links, we need to select one column to convert the corresponding right-side cell into the image from the link, and retain the original URL link. How can this be done? Below is an introduction on how to batch convert a single column of http image URL links in multiple xls, xlsx spreadsheet files into jpg images in the form of overwriting and deleting the corresponding right-side cell, while keeping the converted image URL link unchanged.
1、Usage Scenarios
Generate images from the http URLs in any column of an Excel worksheet file, overwriting the right-side cell, while retaining the http URLs in that column.
For example, if columns B, D, and F contain URL links, generate the images from the http URLs in column D to the right side.
After conversion, the http URLs in column D remain unchanged, and the content of the corresponding cells in column E is completely overwritten, becoming the images from the links in column D.
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 single or multiple xlsx files that require URL links to be converted into images.
【Import Files from Folder】Import a folder containing a large number of xlsx files that need URL links converted into images.
You can also choose to drag files directly into the area below.
【Processing Range】Select a fixed column, and under the column name, choose the column where the http URL links need to be converted into images.
【Image Save Location】Choose to overwrite the right-side cell, also supports overwriting the left-side cell.
【Fixed Image Cell Width and Height】Enter the width and height of the images based on your own needs.
After processing is complete, click the save location to view the converted Excel spreadsheet files.
