Retain the image URL links in the xlsx table and batch overwrite the left cells with jpg, png, and other format images from the links for preview
Translation：简体中文繁體中文EnglishFrançaisDeutschEspañol日本語한국어，Updated on：2025-02-07 09:03
Summary：In dozens of Excel spreadsheet files, there are a large amount of text data and image URL links. To make the worksheet data visually display and enhance content integrity, it is often necessary to convert the http URL links in the workbook into images. If it is necessary to retain the URL links in the Excel spreadsheet and also preview the images to ensure information integrity, we can choose to overwrite the corresponding cell to the left of the image URL link or support overwriting the right cell. Below is how to batch visualize the http URL links in dozens of xlsx worksheets by overwriting the cell on the left.
1、Usage Scenarios
Keep the http URL links in the Excel table and overlay the images from the links onto the content of the corresponding left or right cells for preview.
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 their links converted to images.
【Import Files from Folder】Import a folder containing a large number of xlsx files that need link-to-image conversion.
You can also directly drag and drop files below.
【Processing Range】Select all cells.
【Image Save Location】Choose to overwrite the image in the URL link to the left or right according to your needs.
【Fixed Image Cell Width and Height】Enter the width and height of the image according to your needs.
After processing is complete, click the save location to view the dozens of converted Excel files.
