In twenty Excel worksheets, there are image URL links in multiple columns. How to batch extract a single column and convert it into jpg, png, and other image formats?
Translation：简体中文繁體中文EnglishFrançaisDeutschEspañol日本語한국어，Updated on：2025-01-21 17:27
Summary：When working with xlsx files, we store a large number of image URL links in multiple columns of the cells. To directly and intuitively retrieve information from the table and improve interactivity within the table, we need to convert these image URL links into jpg, png, and other image formats for preview in the worksheet. If there are multiple columns with URL links in the Excel table, but we only need to extract the URL links from a specific column, how can we perform the operation of extracting and converting them individually? Below is an introduction on how to convert image URL links in a specific column of cells in multiple xlsx files into image format.
1、Usage Scenarios
In an xlsx file where many columns contain image URL links, extract a specific column individually and convert it sequentially into jpg, png, and other image formats.
For example: In an Excel table, both columns A and B contain http URL links. You need to convert column B into image format. After the conversion, the image URL links in column A remain unchanged, while the image URL links in column B have been converted into the corresponding images.
2、Preview
Before Processing：
After Processing：
3、Operation Steps
Open 【HeSoft Doc Batch Tool】 and select 【Excel Tools】 - 【Convert Image URLs in Excel to Images】.
【Add Files】Add one or multiple xlsx files that need links converted to images.
【Import Files from Folder】Import a folder containing a large number of xlsx files that need links converted to images.
You can also drag files directly into the area below.
【Processing Range】Select a fixed column and choose the column under the column name where http URL links need to be converted to images.
【Image Save Location】Choose to overwrite the cell.
【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 20 converted Excel files.
