Batch convert local image paths in one hundred xlsx and xls spreadsheet files into jpg, png, and other image formats
Translation：简体中文繁體中文EnglishFrançaisDeutschEspañol日本語한국어，Updated on：2025-01-21 15:58，Editor-in-Chief：system
Summary：When creating Excel worksheets, local images are often referenced and inserted into the cells of the table. To reduce the size of the Excel file to improve loading speed, view images without an internet connection, and facilitate the updating and management of images in the workbook, we usually input the local image disk path instead of the image. When working with xlsx worksheets, if we no longer need the local image paths but want to convert all the paths into visualized images for easier file preview and to avoid opening the paths to view them, what should we do? Below is an introduction on how to convert all local image paths in numerous Excel files into previewable jpg, png, and other image formats.
1、Usage Scenarios
The local disk image file paths in the cells of the Excel spreadsheet are converted into jpg, png, and other image formats sequentially according to the file paths.
2、Preview
Before Processing：
After Processing：
3、Operation Steps
Open 【HeSoft Doc Batch Tool】, select 【Excel Tools】 - 【Convert Image Addresses in Excel to Images】.
【Add File】Add a single or multiple xlsx files that need file path conversion to images.
【Import Files from Folder】Import a folder containing a large number of xlsx files that need path conversion to images.
You can also directly drag files into the area below.
【Processing Range】Select all cells.
【Image Save Location】Choose to overwrite cells.
【Fix Image Cell Width and Height】Input the width and height of the image according to your needs.
After the processing is complete, click the save location to view the 100 converted xlsx files.
