This article introduces how to use office software to batch count information of a large number of JPG image files, and summarize file paths, file names, sizes, creation dates, modification dates, image width and height, resolution, and EXIF metadata into an Excel spreadsheet. It is suitable for scenarios such as material archiving, image asset inventory, photography file organization, and educational image management, helping to avoid checking properties and manually copying information one by one, significantly reducing repetitive work.
When a folder contains dozens, hundreds, or even more images, manually viewing file properties to organize metadata such as the full path, file size, creation date, modification date, width and height resolution, color space, camera model, lens information, ISO, and exposure time for each image is practically infeasible. Especially in tasks like archiving image assets, creating project delivery lists, organizing teaching resources, managing photographic works, or reviewing website images, it is often necessary to consolidate this information into an Excel spreadsheet for easier filtering, sorting, verification, and record-keeping.
This article will demonstrate, with screenshots, how to use the "File Information Statistics" feature in the office software " HeSoft Doc Batch Tool " to batch compile the paths, resolutions, and metadata of many JPG image files and generate a summary Excel table. Its core value lies not in viewing a single image, but in batch processing files to reduce repetitive operations, consolidating data that would otherwise require manual copying one by one.
Applicable Scenarios: When Do You Need to Batch Compile Image Information?
Batch compiling image paths, resolutions, and metadata is not only useful for photographers. As long as a workflow involves a large number of image files and requires creating a list that is searchable, deliverable, and auditable, this method can be used.
1. Image Asset Library Inventory
Corporate communications, design, and operations teams often accumulate large volumes of image assets in formats like JPG, JPEG, and PNG. Over time, these assets become scattered across different folders, making it difficult to determine an image's source, dimensions, and suitability for continued use based solely on the file name. Batch compiling image information quickly provides data such as each image's path, parent folder, file size, width, and height. This makes it easier to subsequently filter for low-resolution images or reorganize duplicate assets in Excel.
2. Organizing EXIF Information from Photos
Photographic works often contain EXIF metadata such as capture time, camera manufacturer, camera model, lens model, ISO, focal length, exposure time, and aperture. Archiving a batch of photos or analyzing shooting parameters is inefficient if you have to open and view the information for each one. The File Information Statistics feature can extract detailed image file information into a table all at once, facilitating a horizontal comparison of shooting parameters across different photos.
3. Project Delivery or Audit Checklists
In scenarios like educational courseware, website redesigns, graphic projects, and image library organization, it is often necessary to submit an image list specifying the image name, path, size, creation time, modification time, and dimensions. An Excel checklist is more standardized than a simple folder screenshot and more convenient for clients or colleagues to review.
4. Batch Screening for Image Dimension Compliance
Many platforms have requirements for image dimensions, such as cover images, detail page images, ID photos, and promotional posters. After exporting image width and height to Excel, you can quickly filter out files that do not meet the dimensional specifications, avoiding the need to manually open images and view their properties repeatedly.
Result Preview: Before Processing, Only a Batch of Scattered JPG Images
Before processing, the folder contains a batch of JPG image files. The screenshot shows file names like ClassNotesImage.jpg, CourseSummaryImage.jpg, ExamPreparationImage.jpg, GrammarReviewImage.jpg, etc., with the file modification time displayed on the right. At this point, if you want to know the full path, file size, resolution, and metadata for each image, the information available in the file explorer list is insufficient.
Common problems in this state are: numerous files with scattered information; only some basic fields are visible; extracting the full path requires copying each one individually; viewing image dimensions or EXIF requires opening image properties or a dedicated viewer; compiling this into an Excel table involves manual pasting, which is time-consuming and error-prone.
Result Preview: After Processing, an Excel Table Containing Paths, Resolutions, and Metadata is Generated
After processing is complete, you get a summary Excel table. The screenshot shows the table listing the information for each image file row by row. The fields include not only the serial number, path, name, extension, size, parent folder path, parent folder name, creation time, and modification time, but also image-related information such as image width, image height, image resolution, color space, and multiple image metadata fields.
From the results table, it can be seen that the office software has converted the image file information into structured data. Subsequently, users can directly filter, sort, search, and perform statistics in Excel. For example, filtering for images with "Image-Width" less than 1000 pixels, finding images that don't meet specifications by "Image-Height", counting the number of assets in different directories by "Parent Folder Path", or analyzing photo sources based on fields like camera model and lens model.
Operation Steps: Using File Information Statistics to Export Image Information in Batch
The following explains the operation process according to the sequence of screenshots. The overall process can be understood in four steps: entering the function, importing image files, checking the image file details option, and setting the save location then starting the process. The operation goal is to batch consolidate the paths, resolutions, and metadata of a batch of JPG image files into an Excel table.
Step 1: Enter the "File Information Statistics" Function in "File Organization"
After opening " HeSoft Doc Batch Tool ", select "File Organization" in the left navigation bar. In the function card area, you can see multiple functions related to batch file organization, such as classify by file name, classify by extension, and folder information statistics. The function to select here is "3. File Information Statistics". The red arrow in the screenshot also points to this function card, noting that it can "batch compile information such as name, path, size, time, and metadata for various files".
The purpose of this step is to enter the functional module specifically for compiling file information. Since this article aims to compile information for image files, the "Detailed Image File Information" option will be enabled later in the processing options. Note that "File Information Statistics" is not only applicable to image files; it can also be used for basic information compilation of other office files, but this article focuses on the paths, resolutions, and image metadata of JPG pictures.
Step 2: Add Image Files or Import Images from a Folder
After entering the "File Information Statistics" page, the top of the interface shows the process flow: Select records to process -> Set processing options -> Set save location -> Start processing. The first step is to select the records for processing. The screenshot shows buttons such as "Add Files", "Import Files from Folder", "Clear", and "More" on the upper right.
If the number of images is small, you can click "Add Files" and manually select the JPG images to be compiled. If the images are all concentrated in a specific directory, it is recommended to use "Import Files from Folder", which can add all images from the folder to the list at once, reducing the time spent selecting files individually. After importing, the software lists the file records in a table, including basic information like serial number, name, path, extension, creation time, and modification time.
From the screenshot, we can see that 20 records have been imported into the list, with names including ClassNotesImage.jpg, CourseSummaryImage.jpg, ExamPreparationImage.jpg, etc., and their paths located in the D:\test\folders\ directory. At this point, users can first check the number of files and their paths to confirm that the images intended for compilation are in the list. If an import error is found, you can use the delete operation on the right side of each row, or use "Clear" to re-import.
Step 3: Enable "Detailed Image File Information" in Processing Options
After confirming the file list is correct, click "Next" at the bottom to enter "Set Processing Options". On this page, you can see the "Additional Information" area, which provides options for various file detail types, including Word file details, Excel file details, PPT file details, PDF file details, text file details, and image file details.
This article needs to compile image paths, resolutions, and metadata, so "Image File Details" must be enabled. In the screenshot, this option is selected. After enabling it, the software will additionally extract image-related fields while compiling basic file information. Based on the processed Excel result preview, it can be reasonably expected that the results will include fields like image width, image height, image resolution, color space, as well as image metadata fields such as capture time, camera manufacturer, camera model, lens model, ISO, focal length, flash, and exposure time.
This step is critical. If you only import files without enabling detailed image file information, the final output may only contain basic information like file name, path, size, and time, failing to produce a complete list of image resolutions and EXIF metadata. Therefore, as long as the goal is to batch compile detailed attributes for JPG, JPEG, and similar images, ensure that "Image File Details" is selected.
Step 4: Set Save Location and Start Processing
After completing the processing options setup, continue clicking "Next" to enter "Set Save Location". The interface flow shows the third step is setting the save location, and the fourth step is starting the process. The save location specifies where the final Excel summary table will be output. It is recommended to choose an easily locatable directory, such as the project folder, asset organization directory, or a specific folder for statistical results, to avoid difficulty finding the output file after processing is complete.
After setting the save location, proceed to "Start Processing". The software will read the image file information item by item according to the imported list and write the compiled results into the Excel table. For directories with many images, the waiting time may vary depending on the number of files, file sizes, and disk speed. Once processing is finished, you can open the generated Excel file to view the results.
Step 5: Verify and Secondarily Organize the Compiled Results in Excel
Upon opening the processed Excel file, you will see each image file represented in a row, with each information field in a column. Common verification methods include: checking if the "Path" column contains the complete file path; checking if the "Extension" column shows 'jpg' or the desired image format; judging whether the resolution meets requirements using "Image-Width" and "Image-Height"; understanding recent file updates via "Modification Time"; and analyzing photo capture information using fields like camera model, lens model, ISO, and focal length.
Because Excel inherently supports filtering, sorting, conditional formatting, and pivot tables, the exported results can be used for further in-depth office processing. For example, you could filter images with a width less than 800 pixels and mark them as low resolution; count the number of images in different categories by parent folder; filter for recently updated assets by modification time; or include the image list as a project delivery attachment.
Frequently Asked Questions and Notes
1. Why are some metadata fields empty for certain images?
Not every image contains complete EXIF information. Some images might have had their capture parameters stripped after being screenshotted, compressed, exported by editing software, or re-uploaded from social platforms. Therefore, it is normal for fields like camera model, lens model, ISO, and exposure time to be empty in the Excel sheet. Basic file information and image dimensions can usually still be compiled.
2. Can only JPG images be compiled?
The sample files in the screenshots are in jpg format, and the processed table also shows the extension as jpg. In practice, the results should be based on what the software imports and recognizes. If a directory contains a mix of JPEG, PNG, BMP, and other image types, you can import the files first, check the extensions in the list, and then determine which fields are available based on the compilation results. For the scenario in this article, the focus is on batch compiling information for JPG image files.
3. Can the compiled results be directly used for project delivery?
It can serve as the base version of a delivery checklist. Since the result is already an Excel table, users can delete unnecessary columns, reorder columns, add comment columns or review status columns according to project requirements. For instance, keep core fields like file name, full path, image width and height, resolution, size, and modification time, and then save as the file format required by the project.
4. Is it necessary to organize the folder before importing files?
It is not strictly required, but it is recommended to first ensure there are no irrelevant files in the directory to be compiled. If a folder contains many files that do not need to be compiled, you can check them through the folder structure or the list after import. Keeping the input files clean can reduce subsequent Excel cleanup work.
5. What is the purpose of the path column?
The path column is a very important field when batch compiling image information. It helps users locate the original image file in Excel, preventing the situation where one can see the file name but doesn't know where the file is located. For identically named images, cross-folder assets, and project archival files, the full path is more reliable than just the file name.
Summary: Delegate the Repetitive Task of Viewing Image Properties to a Batch Processing Tool
Batch compiling image paths, resolutions, and metadata is essentially about converting a large number of image properties scattered across the file system into manageable Excel data. Using the "File Information Statistics" feature of " HeSoft Doc Batch Tool ", you can import multiple JPG images at once, enable "Detailed Image File Information", and then generate a summary table containing path, size, time, width and height, resolution, and EXIF metadata.
Compared to right-clicking to view properties, manually copying paths, and recording dimensions one by one, this method is more suitable for batch file processing in office scenarios. Whether it is a photo asset inventory, compilation of photographic parameters, or creation of a project delivery checklist, it can reduce repetitive work and improve statistical accuracy. When needing to organize a large number of image files, it is recommended to prioritize using batch compilation methods, freeing up time for filtering, decision-making, and content management rather than spending it on mechanical copying.