horizontal lines

What is a XLSX, XLS, XLTM, XLTX file?


XLSM is an XLSX file that is macro-enabled. Macro-enabled means that it can store instructions to record repeated steps in a spreadsheet program. The macros are programmed in Microsoft Visual Basic for Application (VBA) from the Excel Workbook. The Visual Basic editor is used to record and run macros in Excel.

XLSX is the current standard file format for Excel, but it was XLS until Office 2007. The main difference is that XLSX is an XML(extensible markup language)-based open file format, and XLS is a proprietary Microsoft format. The primary advantage of using the new XML-based format is that it allows users to change their data without converting it back into a binary document. In addition, this makes it easier for users to share their work with other users who might not have access to their original data files (or who may be using another computer).

An XLTX file is an Excel Template file that preserves user-defined settings. Excel 2007 and above can open XLTX files for creating new XLSX files that retain the settings from the template. The Office Open XML standard is used to create an XLTX file and can be viewed by changing its extension to ZIP. In addition, Excel comes with predefined templates that can be opened and populated with spreadsheet data. An XLTM file is the same as an XLTX file, except it supports macros.

These extensions are all Microsoft Excel file formats. Think spreadsheets!

Whether you are a student or an employee, you have likely encountered the XLSX, XLSM, XLS, XLTX, or XLTM file extension at some point in your life. Excel has changed its naming syntax over time, but these files were created and saved by Microsoft Excel.

View additional content:

How to get around Excel's max row limit

Cross file Vlookup- An easier way to find answers