Top

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.

XLS

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.

XLSX

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.

XLSM

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.

XLSM to XLSX

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

ActiveWorkbook.Close

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
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.

Convert Excel to PDF in Landscape in Ways

Would you like to convert Excel to PDF in landscape mode? Here are three methods that can help you to do that.

How To Convert PDF to Google Sheets

Are you struggling to convert your PDF files to Google Sheets? Listen. We have the best solution in this article.

Top 5 No-Code Methods to Extract Data from PDF to Excel

When you extract data from PDF to Excel, the formatting is of utmost importance. Here is the right tool to extract table data from PDF.

Convert XLSB to PDF - the Ultimate Guide

Here is how to convert XLSB to PDF(or PDF to XLSB) in 3 Ways with XLSB to PDF converter or Microsoft Excel.

Three Ways to Convert Excel to PDF in Landscape

Would you like to convert Excel to PDF in landscape mode? Here are three methods you can use to do that.