When dealing with a large number of JPG image assets, manually checking paths, dimensions, file sizes, and EXIF metadata can be time-consuming. This article starts from the perspective of asset inventory and demonstrates how to import image files using the file information statistics function in office software, select detailed image file information, and export basic file properties, resolution, and metadata to an Excel list for convenient subsequent filtering, archiving, review, and delivery.
Many teams often get stuck on a seemingly simple question when organizing image materials: What are these images called? What path are they stored in? What is the resolution? Is there EXIF metadata like camera model, lens model, ISO, and shooting time? If there are only a few images, opening properties or using an image viewer can handle it; but if a folder contains dozens or hundreds of JPG images, viewing and copying information one by one becomes inefficient and error-prone repetitive work.
This article introduces a processing method more suitable for office scenarios: using the "File Information Statistics" function in HeSoft Doc Batch Tool to batch export file paths, file sizes, creation times, modification times, image widths, image heights, and metadata information of a large number of JPG images to an Excel spreadsheet. Its positioning is as a batch file processing tool within office software, focusing on reducing the time spent manually organizing file information, making image lists directly usable for inspection, summarization, and archiving.
Applicable Scenarios: From Image Materials to Excel Ledgers
Batch generation of image information lists is particularly suitable for work scenarios requiring "traceability, filterability, and deliverability." For example, when a marketing department organizes event materials, it needs to know if the dimensions of each poster and promotional image meet placement requirements; when education or training teams manage course illustrations, they need to quickly locate materials by file name and path; when a design team delivers a project, it needs to organize image files into a list for client or internal review; in photography material management, there may be a need to batch-view camera brand, camera model, lens model, and exposure-related information.
The commonality in these scenarios is that the images themselves are just files; what is truly used for management is the file information. After exporting image file information to Excel, you can use filtering, sorting, conditional formatting, pivot tables, and other methods for further analysis. For example, filter files below standard dimensions by image height, find recently updated materials by modification time, locate oversized images by file size, and confirm if files are in the correct directory by path.
Effect Preview: What Changes Before and After Processing
Before processing, image files exist as a common file list. The screenshot shows a group of jpg files, such as ClassNotesImage.jpg, CourseSummaryImage.jpg, ExamPreparationImage.jpg, KnowledgeReviewImage.jpg, StudyPlanningImage.jpg, etc. At this point, although file names and some dates are visible, it is difficult to directly obtain detailed information like the full path, resolution, color space, and camera model.
After processing, all image information is organized into an Excel spreadsheet. Each row of the table corresponds to one image, and each column corresponds to one field. Basic fields include name, path, extension, size, folder path, creation time, and modification time; image-related fields include width, height, and color space; metadata fields can also show camera manufacturer, camera model, lens model, ISO sensitivity, and more. Information that originally required opening files one by one to view is now centralized in one table.
Operating Steps: Batch Extracting JPG Image Information and Summarizing to Excel
Step 1: Open the File Information Statistics Entry
After launching HeSoft Doc Batch Tool , select "File Organizing" in the left navigation bar. On the right, several function cards related to batch file organizing will appear, including "Classify files by file name," "Classify files by extension," "File Information Statistics," "Folder Information Statistics," etc. According to the screenshot, the mouse is pointing to the 3rd item "File Information Statistics," indicating this function is used for batch statistics of various files' names, paths, sizes, times, and metadata information.
The reason for choosing this entry is clear: what we need to process is not image compression, image conversion, or image editing, but reading information from image files and forming a list. Therefore, one should enter "File Information Statistics" to let the software batch-read attributes and additional information based on file dimensions.
Step 2: Import JPG Images Needing Statistics
After entering the function page, the first step is to "Select records to process." The upper right area of the interface provides two main entries: "Add Files" and "Import Files from Folder." If the number of images is small, you can add them one by one; if materials are concentrated in a folder, it is recommended to choose "Import Files from Folder," which can quickly add images from the target directory to the list.
The list in the screenshot already shows 20 records, all with the jpg extension, located in the D:\test\folders\ directory. The list fields include sequence number, name, path, extension, creation time, and modification time. The "Total records: 20" at the bottom helps confirm if the imported count meets expectations.
In this step, it is recommended to focus on checking two things: first, whether the file count is correct to avoid missing imports; second, whether the file path is correct to avoid mistakenly adding images from other projects to the statistics. For a large number of files, you can use the "Filter" and "Sort" functions in the interface for auxiliary checking. After confirming correctness, click "Next" at the bottom.
Step 3: Check Picture File Detailed Information
After entering "Set Processing Options," the page displays the "Additional Information" area. Here, detailed information options for multiple file types are provided, including Word File Detailed Info, Excel File Detailed Info, PPT File Detailed Info, PDF File Detailed Info, Text File Detailed Info, and Picture File Detailed Info. Since this time we need to extract dimensions and metadata of JPG images, "Picture File Detailed Info" should be checked.
The effect of checking this option is to additionally read image-related fields beyond basic file information. According to the processed table effect, the output results will include image width, image height, color space, and metadata fields. For JPG images that retain EXIF data, the table may also display camera manufacturer, camera model, lens model, ISO sensitivity, and other information. The Excel exported this way is not just a file list, but a more complete image material ledger.
Step 4: Set Save Location and Execute Statistics
After setting the processing options, continue to click "Next." The top of the wizard shows the subsequent processes are "Set save location" and "Start processing." Follow the interface prompts to choose the save location for the output results, then proceed to the start processing step. After processing is complete, opening the output table will show the basic image information and detailed image information summarized by columns.
To facilitate subsequent management, it is recommended that the output file name reflects the statistical scope, such as "Course Image Material Information List," "Project Image Path and Dimension Statistics," "JPG Metadata Summary Table," etc. This way, even if multiple batches of statistical tables are generated later, the source can be quickly distinguished.
How to Utilize the Exported Excel Image List
After obtaining the Excel spreadsheet, many further practical operations can be performed. First, you can check by "Path" or "Folder Path" whether images are placed in the wrong directory. For teams with many project materials, the path field is very important; it is equivalent to the location information for each file.
Secondly, you can filter by "Image Width" and "Image Height." For example, website banners, course covers, and e-commerce main images usually have fixed dimension requirements. After exporting the table, you can quickly find files that do not meet the standards. Compared to opening images one by one to view dimensions, Excel filtering is significantly more efficient.
Furthermore, you can sort by the "Size" field to find abnormally large images, facilitating subsequent decisions on whether to compress them. You can also sort by "Modification Time" to confirm which images were recently updated and which materials might be old versions.
If the images retain EXIF metadata, you can also categorize by fields like camera manufacturer, camera model, and lens model. This is very helpful for tasks like photographic material management, image archiving, and shooting equipment statistics.
Common Issues and Precautions
What to Do If Exported Metadata Is Incomplete
Incomplete metadata is usually related to the image source. Many JPG images captured by cameras or phones contain EXIF information, but after processing via WeChat, web platforms, compression tools, or image editing software, some metadata may be removed. Therefore, if some camera or lens fields are empty in Excel, first check whether the original image actually contains this information.
Will Non-Image Files in the Folder Affect the Results
The file information statistics function is designed for multiple file types; the list will display the extension after import. To get a cleaner image list, it is recommended to confirm the folder contents before importing, or check the extensions in the list. The example imported in this article are all jpg files, making the output table more focused.
Why Keep Both Path and Folder Path
The full path allows precise location of a specific file, while the folder path facilitates categorization by directory. For batch organizing of images, both fields are very valuable. The full path is suitable for finding a single file, while the folder path is suitable for analyzing material distribution and directory structure.
Is It Necessary to Check Picture File Detailed Information Every Time
If only basic information like name, path, size, creation time, and modification time is needed, the additional information can be ignored. But if the goal includes resolution, image width/height, color space, or EXIF metadata, then "Picture File Detailed Info" should be checked. The core requirement of this tutorial is precisely to count image dimensions and metadata, so this option is a key step.
Summary: Replace Viewing Image Properties One by One with Batch File Statistics
Organizing information for a large number of JPG images should not rely on manual, individual viewing. Through the "File Information Statistics" function of HeSoft Doc Batch Tool , image paths, file sizes, creation times, modification times, resolutions, and metadata can be batch-summarized into an Excel spreadsheet. The entire process is clear: enter File Information Statistics, import images, check Picture File Detailed Info, set the save location, and start processing.
For users who frequently manage image materials, create file ledgers, check dimension standards, or organize EXIF information, this method can significantly reduce repetitive work. It is recommended that the next time you organize an image folder, you directly use the batch statistics function to generate an Excel list, and then complete filtering, verification, and archiving within the spreadsheet.