When macro codes are included in Excel worksheets, Xlsm format can save and run these macros, which can play a very key role in the case of automatic processing and custom functions. Xlsm format supports advanced functions of Excel tables (such as Power Query and Power Pivot) and is suitable for batch processing of big data or complex analysis. The following describes how to batch convert various format files in Excel tables to Xlsm format. Xls, Xlsx, Xlt, Xlts and other formats are supported for scenarios that require macros, complex data processing, or shared automation functions.
1. Use Scenarios
there are a lot of Excel worksheet files that do not support macro code, and it is necessary to run macro code to import and export data or generate reports and other scenarios for a series of automated data processing, we can convert them to Xlsm format in one batch to meet the operation requirements of the file.
2. Effect preview
before treatment:
after treatment:
3. Operation steps
open 【HeSoft Doc Batch Tool], select [Excel Tools]-[Excel to Xlsm]].
[Add File] Add single or multiple Excel files that need to be converted to Xlsm format.
[Import File from Folder] Import all Excel files in the selected folder.
You can view the imported files below.
Once processing is complete, click Save Location to view the converted Xlsm file.
