Excel What File Extension Is Added To A Template File?

Since the release of Office 2007, all workbook files are saved in an "Open XML" file format by default (a compressed nada file). This file format uses four-alphabetic character file extensions (.xlsx, .xlsm, .xlsb, .xltx, .xltm, and .xlam). Using the XML file format, a developer or a 3rd party awarding can easily edit the workbook without having the Office application installed on their calculator. In this tutorial you'll see what a file extension telling y'all virtually itself.

Permit's pause the file extension in three parts:
Excel File Types

The first and second letters of the file extension refer to the application:
- 40 = Excel
The third letter refer to the specific file blazon:
- s = Spreadsheet
- t = Template
- a = Add together-in
The last letter specifies whether the file format is XML based or information technology supports macros:
- 10 = XML based file format, tin't shop VBA macro code
- m = Macro-enabled and XML based file format
- b = Binary file format (support faster loading and saving). This non-XML based file format tin store VBA macro code.

Excel 2007-2019 file extensions

. xlsx = Excel Workbook
It is the default Excel file format.

.xlsm = Excel Macro-Enabled Workbook
The file format with all macros it contains enabled.

.xlsb = Excel Binary Workbook
The binary file format, optimized for the faster loading of really large workbooks with tons of data.

.xltx = Excel Template
An Excel template file can employ to generate new workbooks containing the same layout and content equally the template.

.xltm = Excel Macro-Enabled Template
An Excel template file format with all the macros it contains enabled.

.xlam = Excel Add-in
An Excel add-in is a workbook that gives additional functionality to any workbook. Its open automatically when information technology starts-up.

Excel 97-2003 file extensions

.xls = Excel Workbook
This binary file format is used by earlier versions of Excel 97 through Excel 2003.

.xlt = Excel Template
Binary files for an Excel template.

.xla = Excel Add-in
Binary files for an Excel add-in.

Open source spreadsheet programs file extension

.ods = OpenDocument Spreadsheet
You tin can save (or open) a workbook in ODF format with an .ods filename extension that's used by other Part suites of programs, such equally StarOffice OpenOffice.

Other file formats supported in Excel

.csv = Comma delimited text file
.dbf = dBase file format
.dif = Data Interchange Format
.htm, .html = Spider web-Page, saved in a folder, all supporting files saved in that binder.
.mht, .mhtml = Unmarried File Web Page, includes all supporting files, such equally images
.pdf = Portable Document Format, this format preserves file formatting when sharing with others.
.prn = Lotus space-delimited format.
.slk = Symbolic Link Format
.txt = Manifestly text file
.xml = XML file format
.xps = XPS Certificate