Quickly batch convert a large number of Excel spreadsheet files into the macro-enabled Xlsm format
Translation：简体中文繁體中文EnglishFrançaisDeutschEspañol日本語한국어，Updated on：2025-03-12 11:03
Summary：When an Excel worksheet contains macro code, the Xlsm format can save and run these macros, playing a crucial role in scenarios requiring automated processing and custom functions. Additionally, the Xlsm format supports advanced Excel features (such as Power Query and Power Pivot), making it suitable for batch processing large datasets or performing complex analyses. The following describes how to batch convert various format files in Excel spreadsheets to Xlsm format, addressing scenarios that require macros, complex data processing, or sharing automation features, and supports formats like Xls, Xlsx, Xlt, Xlts, etc.
1、Usage Scenarios
When there are many Excel worksheet files that do not support macro code, and you need to run macro code for data import/export or generating reports and other automated data processing scenarios, you can batch convert them to Xlsm format at once to meet the operational requirements for the files.
2、Preview
Before Processing：
After Processing：
3、Operation Steps
Open 【HeSoft Doc Batch Tool】, select 【Excel Tools】 - 【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 from the selected folder.
Below you can view the imported files.
After processing is complete, click on the save location to view the successfully converted Xlsm files.
