When macro code is included in an Excel worksheet, the Xlsm format can save and run these macros. It plays a critical role in scenarios requiring automated processing and custom functions. Moreover, the Xlsm format supports advanced Excel features (such as Power Query, Power Pivot), making it suitable for batch processing of large data or complex analysis. The following explains how to batch convert various file formats in Excel tables to Xlsm format, addressing scenarios where macros are needed, complex data is processed, or automated functions are shared. It supports formats such as Xls, Xlsx, Xlt, and Xlts.
1. Usage Scenarios
In scenarios where you have a large number of Excel worksheet files that do not support macro code, but you need to run macro code for automated data processing tasks such as data import/export or report generation, you can batch convert them to Xlsm format at once to meet the operational requirements for the files.
2. Effect Preview
Before processing:
After processing:
3. Operation Steps
Open【 HeSoft Doc Batch Tool 】, select【Excel Tools】-【Convert Excel to Xlsm】.
【Add Files】Add single or multiple Excel files that need to be converted to Xlsm format.
【Import Files from Folder】Import all Excel files within the selected folder.
You can view the imported files below.
After processing is complete, click the save location to view the successfully converted Xlsm files.
