PDFelement: PDF Editor, Scanner
Edit, Convert, Annotate PDF
Edit, Annotate PDF

Convert XLSM to XLSX/XLS in 3 Ways

Want to convert XLSM to XLSX or XLS? You have come to the right place. In this article, we are going to tell you how to do that in different ways.

Part 1: XLSM, XLSX, XLS, What's the Difference

Excel is used for many purposes and is familiar to many. The extensions of various Excel tables are different. The common ones are XLSX and XLS format and CSV and XLSB format.


In 1987, Microsoft had come with the first Excel spreadsheet for Windows and since then it has been updated several times. One of the biggest features of Excel is it has 65536 rows and 256 columns. So, the data stored in Excel 2007 and its later versions are much different. The XLS format file is a part of Excel's evolutionary history. These days, it is primarily replaced by XLS. But often Excel 2003 is used to save money.


This is a Microsoft Office Excel 2007/2010/2013/2016/2019 extension. In fact, it's the mainstream format of the spreadsheet. In comparison with XLS, it can store data on 104576 rows and 16384.


It is almost the same as XLSX and users can open it with Excel 2007. But the only difference is XLSM begins the macro. Usually, if you record a macro in the XLSX file or just insert a part of the VBA code, it can't be saved normally. You can just save it in XLSM format. XLSX can't save VBA but XLSM can.

Apart from the functional differences, the primary difference between these kinds of tables is the file size. For the same content, XLSB format comes with the smallest size and it's followed by XLSM and XLSM format, and then comes the XLS format.

Part 2: Convert XLSM to XLSX/XLS in Excel

Step 1 To convert the XLSM file to XLSX/XLS format, you will have to follow the steps given below.

Step 2 Open the Excel file you want to convert. Go over to the 'File' option at the top-left corner of the spreadsheet.

Step 3 On the left panel, you will find the option 'Save As'. Click on it. Choose the location where you want to save the file.

Step 4 On the pop-up window, you can choose from different formats by clicking on the drop-down menu 'Save as type'.
Click on XLSX/XLS format. After choosing, click on 'Save' to save the file in the chosen format.


Are you confused about other XLSX conversions? Click the link below and find out how to convert XLS to XLSX.

Part 3: Convert XLSM to XLSM/XLS on Google Drive

You can convert XLSM to XLSX/XLS format for free, you can use Google Sheets online spreadsheet tool. When you do this, it is going to convert the file to a special format for you to make the desired changes. Let's find out how to do it.

Step 1 Upload the file to Google Drive account by going over to the New and then File Upload option. Select 'Folder Upload' if you have to upload an entire folder.

Step 2 Now, right-click on the XLSM file presents in Google Drive and choose 'Open With' and then 'Google Sheets'.

This will automatically convert the format, which allows you to read and use the file with Google Sheets.

Open XLSM in Google Sheet

Part 4: Convert XLSM to XLSX Online without Opening

You can also convert your XLSM files to XLSX format with the help of an online XLSM converter. With these tools, you will be able to convert the file without even opening them.

1. CloudConvert XLSM to XLSX Online

CloudConvert is an online spreadsheet converter that has output quality as same as the file that had been saved through the new Microsoft 2019 suite. The converter has been trusted by users since 2012. It maintains security and ensures that no one except you gets access to the files.

To convert the file, you just have to go XLSM to the XLS converter page and click on 'Select File'. After opening the file, click on convert. So, converting the file is easy and only takes a few minutes.

2. Online XLSM to XLS Converter

ASPOSE offers an online XLSM to XLS online converter for free. You can use the tool from any device you want. It has a drag and drop format when it comes to file conversion. You can use this Excel conversion tool for free. With this, you will be able to upload a maximum of 10 files at the same time.

Step 1 To convert the files, here is what you have to do.

Step 2 Upload the XLSM files for converting. Then press on the 'Convert' button.

Step 3 When you are done, just convert the files instantly. However, if you want. You can also send the download link to your email address and download it when you want.

Step 4 The files are deleted from the server after 24 hours. So, the download link will stop working after that period.

3. XLSM to XLSX Converter

GroupDocs XLSM to XLSX Converter is an online tool that you can use from any browser. To use this, you don't have to register an account. All you have to do is drag and drop the XLSM file, select the desired format, and click on convert. When you are done converting the file, you can download the XLSX file.

The files you are converting will be stored in Cloud. The tool offers 100% privacy. Moreover, all the converted documents are removed from the cloud after 24 hours. The tool works on all formats Android, iOS, MacOS, and Windows.

Part 5: FAQ about XLSM to XLSX

1. Convert .XLSX to .XLSM Using Command Line?

If you want to convert XLSX to XLSM using a command line, check it out below.

Sub TrandformAllXLSFilesToXLSM()

Dim myPath As String

myPath = "C:\Excel\"

WorkFile = Dir(myPath & "*.xls")

Do While WorkFile <> ""

If Right(WorkFile, 4) <> "xlsm" Then

Workbooks.Open FileName:=myPath & WorkFile

ActiveWorkbook.SaveAs FileName:= _

myPath & WorkFile & "m", FileFormat:= _

xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False


End If

WorkFile = Dir()

2. Can I Convert XLSM to XLSX using Power Automate?

No, Power Automate might not let you choose a macro-enabled file. You might have to convert it back to .XLSX. You can do this either manually or with the help of a tool. You should know that there are limitations to using Power Automate with your Excel Connector.

You may also like
[Bonus] 6 Selected Online XLS to PDF Converters

If you're wondering how to convert XLS to PDF online, this article will introduce you to the best online XLS to PDF converter that can come in handy anytime.

[Bonus] 5 High-Scoring PDF to Excel Converters Online

Searching for the best PDF to Excel Converter Online? Here's a complete list of 5 high-scoring options.

5 Ways To Convert PDF to Excel Without Software

Are you stuck trying to convert a PDF file into excel without the software? Go through this article and solve your problem for good.

Step By Step Guide to Using VBA To Convert PDF to Excel

Digital documents are easily convertible from one format to another. This article will discuss various ways to convert a PDF to Excel.

5 Excellent Free PDF-to-Excel Converters Online Without Email Required

A PDF to Excel converter online free without email that is both effective and simple to use is required to convert a PDF to Excel. The top 5 best PDF to Excel converters are listed below.

How To Save Excel As PDF With VBA [Codes Provided]

Do you need to save your Excel spreadsheet as a PDF? You can do so using the VBA programming language. Here is a guide you can use VBA to save Excel as PDF to learn how to do that.