when there are a large number of Excel files in a folder, manually open each workbook to view the number of Sheet pages, and then write the number of pages into the file name, which is not only time-consuming, but also error-prone. This article introduces how to use office software around the actual office requirement of "adding Sheet page number information in batch at the beginning of Excel file name" HeSoft Doc Batch Tool , batch import xlsx and other Excel files, and through the "file name to add the total number of pages of the document" function, the Sheet pages are automatically written in front of the file name. The article will combine the operation interface to explain the applicable scene, the effect before and after processing, the specific steps and precautions, to help you quickly complete batch renaming and improve the efficiency of file arrangement.
In daily office work, many people will encounter such a situation: there are dozens or even hundreds of Excel workbooks in a folder, which need to distinguish the content complexity according to the number of Sheet pages of each file, or as an auxiliary mark for filing, delivery and review. If you manually open xlsx files one by one, check the number of worksheets, and rename them one by one, the workload is very heavy, and it is easy to miss and correct mistakes.
The problem to be solved in this paper is: how to batch add sheet number information at the beginning of Excel file name. With office software HeSoft Doc Batch Tool , can directly batch process multiple Excel file names, the document page number information automatically written into the file name prefix, significantly reduce duplication of labor, improve file finishing efficiency.
Applicable Scenarios
this batch processing method is very useful if you have the following needs:
- you need to organize Excel files in batches and quickly identify the file structure according to the number of Sheets;
- to multiple xlsx workbooks unified plus page identification, easy to file, send or review;
- there are many project data, financial statements and business ledgers, and it is hoped that the file name will be more standardized;
- do not want to manually open the Excel file one by one to rename, want to complete the batch at a time.
In addition to the common .xlsx files, in the actual office, similar batch renaming ideas are often used for other document finishing tasks. For posts that require high-frequency processing of file names, the value of this type of office software is: batch processing of documents to reduce duplication of effort.
Effect Preview
before treatment
as you can see from the example file list in the interface, the original file name is similar:
- Mars.xlsx
- Mercury.xlsx
- Moon.xlsx
- NutritionForum.xlsx
- Peanut.xlsx
this type of file name itself does not contain Sheet page information, and it is impossible to directly determine how many worksheets each Excel workbook contains when viewing.
After treatment
according to the settings interface, the software supports adding "total pages of document" to the file name, and the current position is set start Position at the same time, the left and right text are customized:
- left text:[Total
- right Text: pages]
therefore, after the processing is completed, the file name will become a form similar to this:
- kill
- however
- however
that is to say, Sheet number information is added to the beginning of the Excel file name, subsequent browsing, filtering and archiving will be more convenient.
Operation steps
step 1: Enter the "Total Pages of File Name Add Document" function
in the first screenshot, you can see that the left side of the software has been switched file Name classification, selected in the right function card "5, file name to add the total number of pages of the document".
The purpose of this step is to enter a dedicated function page that adds page number information to the file name in batches. For the current requirement, it corresponds exactly to the number of Sheet pages added in bulk to the Excel file name.
Expected results: enter the "Total Pages of File Name Add Document" processing interface to prepare to import the Excel file to be renamed.
Step 2: Batch import Excel files to be processed
in the second screenshot, the page title is already displayed file name Total number of pages of the added document. Currently in step 1: select records to process.
Two main import portals are visible at the top of the page:
- add File
- import files from a folder
if your Excel files are scattered, you can use "Add Files" to select them one by one or in batches. If multiple xlsx files are in the same directory, it is more efficient to directly use "Import Files from Folder.
After the file is imported, the file name, path, extension, creation time, and modification time are displayed in the list. In the screenshot, you have imported multiple Excel files, such as Mars.xlsx, Mercury.xlsx, and Moon.xlsx, with the extension xlsx.
The operational purpose of this step: add Excel files that need to be processed uniformly to the task list at one time.
Expected results: the task list displays the files to be processed in full, and click at the bottom after confirming that they are correct. Next step enter the parameter settings.
Step 3: Set the page number information to insert in front of the file name
the third screenshot shows step 2: set processing options.
There are three key settings here:
- location: Select start Position
- customize the text on the left: Enter [Total
- customize the text on the right: enter pages]
because the choice here is start Position, so the system will add the "total number of pages of the document" as the prefix of the file name, that is, in front of the original file name.
The role of the text on the left and the text on the right is to wrap the pages into a more readable format. For example, if the number of pages is 4, the resulting prefix may be:
[Total4pages]
combined with the original file name, you get something like:
much
The operational purpose of this step: specify the location where page information is added and set the format of the final file name.
Expected results: after all Excel files are processed, the Sheet page number information will be added to the beginning of the file name.
Step 4: Continue to the next step and complete batch processing
according to the interface process, after completing the "Set Processing Options", click the bottom next step, the follow-up will also enter:
- step 3: set Save Location
- step 4: start processing
although the screenshot does not have the specific details of the last two steps, it can be reasonably judged from the process bar. Next, you only need to continue to press the wizard to complete the save location setting and then execute the processing.
The operational purpose of this step: confirm the output location and formally execute the batch rename task.
Expected results: the software automatically reads the total number of pages of each Excel workbook (I. e. the corresponding Sheet quantity information) and updates the file names in batches without manual modification one by one.
Frequently Asked Questions or Precautions
1. How do you understand the "total number of pages" here when used in Excel?
From the current usage scenario, this article corresponds to add Sheet Page Number Information in Batch at the Beginning of Excel File Name. In other words, in the Excel workbook scenario, the number of pages here can be understood as the number of Sheets in the workbook, which is used to quickly identify the file structure.
2. It is recommended to check whether the imported files are all xlsx files that need to be processed first.
Before starting processing, it is recommended to check the file name, path and extension in the list to avoid adding Excel files that do not need to be modified to the task. Especially when there is more data under the same folder, this step can reduce misoperation.
3. Custom text should be named in advance
the setting format in the screenshot is in the style of [Total pages], which is suitable for English naming environment. If your file naming habits are partial to Chinese, you can also adjust the left and right text according to your own specifications to make the final file name more uniform and easier to read.
4. It is recommended to keep the original file backup before batch processing.
Although the batch renaming of office software is very efficient, it is still recommended to back up a copy of the original document for important ledgers, financial statements and project data, especially when processing large quantities for the first time.
5. File name specification unified more conducive to retrieval and archiving
add the number of Sheet pages to the Excel file name, not only for "good looking", but also for more efficient subsequent retrieval. For example, when multiple people collaborate, seeing the file name can initially determine the complexity of the workbook and reduce the time to repeatedly open the file for confirmation.
Summary
for people who need to organize Excel and xlsx files frequently, add the number of Sheet pages in bulk at the beginning of the file name, is a very practical file management action. By HeSoft Doc Batch Tool in file name Total number of pages of the added document function, you can turn the original need to open files one by one, manually rename the work, into a process of import, unified settings, batch completion.
This is the core value of office software in practical work: batch processing documents, reduce duplication of labor, improve efficiency.
If you currently need to modify Excel file names in batches, you may as well directly follow the steps in this article: first enter the function of "adding total pages of documents to file names", import xlsx files, select the starting location, set the left and right text, and then continue to complete saving and processing. In this way, the Sheet page number information can be quickly added to the front of the file name, so that the file arrangement is more standardized and the search is more time-saving.