When a folder accumulates a large number of Word, docx, and doc documents, it is very time-consuming to open them one by one to check the page count, path, author, modification time, and Office metadata. This article introduces how to use the "File Information Statistics" feature in HeSoft Doc Batch Tool to batch summarize the names, full paths, extensions, sizes, creation times, modification times, page counts, and metadata information such as titles, subjects, and authors of multiple Word files into an Excel spreadsheet, suitable for scenarios like data archiving, document inventory, and project delivery checklist organization.
In daily office work, many teams encounter a common problem: a folder containing dozens or even hundreds of Word documents, requiring the statistics of each file's path, page count, creation time, and modification time, as well as the organization of Office metadata such as the title, subject, author, and last saved by. Manually opening each docx or doc file to view and then copying the data into Excel is not only time-consuming but also prone to omissions and errors.
This article addresses the issue of "batch statistics for the path, page count, and metadata of numerous Word files, and summarizing them into an Excel spreadsheet." Leveraging the "File Information Statistics" feature of the office software " HeSoft Doc Batch Tool ", you can import Word files scattered across folders in one go, automatically read basic file information and detailed Word data, and finally generate an Excel summary table that can be filtered, archived, and further analyzed.
Applicable Scenarios: When do you need batch statistics of Word file information
Batch statistics for Word document information is not a rare requirement, especially when the number of files is large and a list or ledger needs to be created, significantly reducing repetitive work. The following scenarios are ideal for the method described in this article:
- Data Archiving: Organizing learning materials, training documents, contract templates, policy files, and other Word documents into an Excel list for easy retrieval and handover.
- Project Delivery: Listing all docx file names, paths, page counts, and modification times before delivery to facilitate checking whether the documentation is complete.
- Document Auditing: Viewing metadata such as the author, last saved by, and last save date to assess the document source and version status.
- File Inventory: Counting the number, size, location, and update time of Word files on shared drives, project folders, or repositories.
- Page Count Summary: Quickly determining the page count of each Word file when dealing with numerous training handouts, thesis materials, and report documents.
If only a small number of files need to be counted, manual operation might be acceptable. However, once the file count increases to dozens or hundreds, the value of batch processing with office software becomes very apparent. Its core advantage is not "opening a single file for you," but rather completing the repetitive tasks of file reading, information extraction, and table summarization in one go.
Effect Preview: Before processing, a batch of scattered Word files
Before processing, you can see many Word documents in the folder, such as AcademicWritingNotes.docx, ActiveReadingGuide.docx, DailyStudyPlanner.docx, ExamReviewChecklist.docx, etc. While the file names, modification times, types, and sizes are visible in Windows Explorer, the full path, page count, and internal Office metadata cannot be viewed directly or in batch.
The problem with this type of list is that the information displayed by the Explorer is limited and unsuitable for a formal statistical result. If an Excel ledger is needed, data must still be organized row by row; if fields like page count, author, title, subject, and comments are also required, manual statistics will almost inevitably waste a significant amount of time.
Effect Preview: After processing, an Excel summary table is generated
Once the processing is complete, the software aggregates the Word file information into an Excel file. The resulting table shows that each row corresponds to a Word document, and each column is a statistical field. The table includes file path, name, extension, size, containing folder, creation time, modification time, page count, and multiple Office metadata fields.
From the screenshot, it's evident that the exported Excel doesn't just list file names; it also includes fields like "Page Count," "Office - Metadata - Title," "Office - Metadata - Subject," "Office - Metadata - Tags," "Office - Metadata - Category," "Office - Metadata - Comments," "Office - Metadata - Author," "Office - Metadata - Last Saved By," "Office - Metadata - Revision Number," "Office - Metadata - Company," "Office - Metadata - Manager," and "Office - Metadata - Last Save Date." This information is highly suitable for subsequent filtering, sorting, archiving, and review.
Operating Steps: Batch exporting Word information using the File Information Statistics feature
Step 1: Enter "File Information Statistics" under "File Arrangement"
Open HeSoft Doc Batch Tool , and select "File Arrangement" in the left-hand navigation. Find the feature card "3. File Information Statistics," whose description indicates it is for batch statistics of various files' names, paths, sizes, times, and metadata. Click this feature to enter the processing wizard.
The purpose of this step is to choose the correct batch processing entry point. As this article aims to count Word file paths, page numbers, and metadata, do not enter standard Word editing functions. Instead, enter "File Information Statistics," which can read both basic and detailed file information.
Step 2: Add the Word files that need to be counted
After entering the "File Information Statistics" page, the first step is to "Select the records to be processed." You'll see buttons like "Add Files," "Import Files from Folder," "Clear," and "More" at the upper right of the interface. For Word documents already gathered in one folder, choosing "Import Files from Folder" is usually more convenient; if you only want to count specific docx or doc files, you can also use "Add Files" to select them individually.
After import, the list will display details like sequence number, name, path, extension, creation time, and modification time. The screenshot shows 20 records have been imported, each showing its full path, e.g., D:\test\folders\AcademicWritingNotes.docx. At this point, you can check if the file count is correct and the paths meet expectations. If extraneous files were imported, you can delete them using the action column in the list; if imported incorrectly, you can also use "Clear" to reselect.
The expected result of this step is that all Word files requiring statistics appear in the software list, with their extension confirmed as docx or another Word format. Once confirmed, click "Next" at the bottom.
Step 3: Check the Word file detailed information option in the processing settings
On the second step, "Set Processing Options," you will see an "Additional Information" area. The interface provides detailed information options for various file types, including "Word File Details," "Excel File Details," "PPT File Details," "PDF File Details," "Text File Details," "Image File Details," etc.
Because this article focuses on counting Word document page counts and Office metadata, you need to check "Word File Details." This option is shown as checked in the screenshot. This step is crucial: if only basic file information is counted, you typically get only fields like name, path, size, and time; by checking Word file details, the software will further read internal Word document information, such as page count and Office metadata.
After checking this box, click "Next." The purpose here is to instruct the software to attach Word-specific detailed fields when exporting to Excel, beyond just file system information.
Step 4: Set the save location and start processing
Following the wizard flow at the top of the page, subsequent steps include "Set Save Location" and "Start Processing." Upon reaching the save location step, follow the interface prompts to choose where the exported Excel file will be saved. It's recommended to save the output table to the current project directory or a dedicated statistics results folder for easier retrieval and archiving later.
After setting the save location, proceed to "Start Processing." The software will batch read the added Word files and write the statistical results into Excel. Once processing is complete, open the generated Excel file to see the Word document list summarized by row.
How to use the exported Excel table
The generated Excel summary table is not just a one-off result file; it can be further utilized in various office scenarios:
- Sort by Page Count: Quickly identify the Word documents with the most or fewest pages.
- Filter by Modification Time: Check which documents were recently updated and which have not been maintained for a long time.
- Filter by Author or Last Saved By: View the document's source or the last person who edited it.
- Group by Path: Analyze the distribution of Word documents across different folders.
- Use as a Delivery Checklist: Send the Excel table to project members or clients for verifying the scope of documentation.
Compared to manual arrangement, the batch-exported table structure is more uniform and better suited for subsequent filtering, sorting, pivot analysis, and record-keeping.
Common Questions and Precautions
1. Why must "Word File Details" be checked?
Because content like page count and Office metadata are detailed properties of Word documents. If files are imported without checking this option, the exported results may mainly consist of basic file attributes like name, path, extension, creation time, and modification time. To count docx page numbers and metadata, you must check "Word File Details" in the "Additional Information" section.
2. Can doc and docx files both be counted?
Judging by its functional positioning, this feature is used for counting names, paths, sizes, times, and metadata of various files, and it provides an option for Word file details. In practice, you can import the Word documents you need statistics for into the list. For different Word file versions, it's recommended to test with a small sample first to see if the exported fields meet your expectations before batch-processing the entire folder.
3. Do I need to open each Word file before exporting?
No, you don't need to manually open them one by one. The value of batch processing lies precisely in importing multiple files at once and having the software read them uniformly to generate an Excel table. This avoids the repetitive manual work of opening, viewing, copying, and pasting.
4. What should I note when there are many files?
It's advisable to first confirm the source and scope of the files to avoid importing unrelated ones. If the folder structure has many levels, consider processing in batches by project or category first, making the exported Excel easier to manage. After processing, it's also recommended to check if the record count matches expectations.
Summary: Replace manual copying with batch statistics to quickly establish a Word document ledger
Batch counting Word file paths, page counts, and metadata essentially solves the problem of repetitive labor in document management. Using the "File Information Statistics" feature of HeSoft Doc Batch Tool , you can automatically extract the name, path, size, time, page count, and Office metadata from a batch of scattered docx and doc documents and aggregate them into an Excel table.
If you are organizing project materials, archiving training documents, inventorying files on a shared drive, or need to submit a Word document list to others, it's recommended to use this batch processing method directly. First import the files, then check "Word File Details," and finally export to Excel. This compresses the work that originally required opening and counting each file individually into just a few steps, significantly boosting office efficiency.