Which of the following is the file extension used for excel template files?

From Wikipedia, the free encyclopedia

Jump to navigation Jump to search

The following is a list of filename extensions used by programs in the Microsoft Office suite.

LegacyLegacy filename extensions denote binary Microsoft Word formatting that became outdated with the release of Microsoft Office 2007. Although the latest version of Microsoft Word can still open them, they are no longer developed. Legacy filename extensions include:

• .doc – Legacy Word document; Microsoft Office refers to them as "Microsoft Word 97 – 2003 Document"
• .dot – Legacy Word templates; officially designated "Microsoft Word 97 – 2003 Template"
• .wbk – Legacy Word document backup; referred as "Microsoft Word Backup Document"

OOXMLOffice Open XML (OOXML) format was introduced with Microsoft Office 2007 and became the default format of Microsoft Word ever since. Pertaining file extensions include:

• .docx – Word document
• .docm – Word macro-enabled document; same as docx, but may contain macros and scripts
• .dotx – Word template
• .dotm – Word macro-enabled template; same as dotx, but may contain macros and scripts
• .docb – Word binary document introduced in Microsoft Office 2007
• .pdf – PDF documents
• .wll – Word add-in
• .wwl – Word add-in

LegacyLegacy filename extensions denote binary Microsoft Excel formats that became outdated with the release of Microsoft Office 2007. Although the latest version of Microsoft Excel can still open them, they are no longer developed. Legacy filename extensions include:

• .xls – Legacy Excel worksheets; officially designated "Microsoft Excel 97-2003 Worksheet"
• .xlt – Legacy Excel templates; officially designated "Microsoft Excel 97-2003 Template"
• .xlm – Legacy Excel macro
• .xll_ – Excel 4 for Mac add-in
• .xla_ - Excel 4 for Mac add-in
• .xla5 – Excel 5 for Mac add-in
• .xla8 – Excel 98 for Mac add-in

OOXMLOffice Open XML (OOXML) format was introduced with Microsoft Office 2007 and became the default format of Microsoft Excel ever since. Excel-related file extensions of this format include:

• .xlsx – Excel workbook
• .xlsm – Excel macro-enabled workbook; same as xlsx but may contain macros and scripts
• .xltx – Excel template
• .xltm – Excel macro-enabled template; same as xltx but may contain macros and scripts

Other formatsMicrosoft Excel uses dedicated file formats that are not part of OOXML, and use the following extensions:

• .xlsb – Excel binary worksheet (BIFF12)
• .xla – Excel add-in that can contain macros
• .xlam – Excel macro-enabled add-in
• .xll – Excel XLL add-in; a form of DLL-based add-in
• .xlw – Excel work space; previously known as "workbook"

PowerPoint[edit]

Legacy

• .ppt – Legacy PowerPoint presentation
• .pot – Legacy PowerPoint template
• .pps – Legacy PowerPoint slideshow
• .ppa – PowerPoint (2007?) add-in
• .ppam – PowerPoint 2007 add-in with macros enabled

OOXML

• .pptx – PowerPoint presentation
• .pptm – PowerPoint macro-enabled presentation
• .potx – PowerPoint template
• .potm – PowerPoint macro-enabled template
• .ppam – PowerPoint add-in
• .ppsx – PowerPoint slideshow
• .ppsm – PowerPoint macro-enabled slideshow
• .sldx – PowerPoint slide
• .sldm – PowerPoint macro-enabled slide
• .pa – PowerPoint add-in

Microsoft Access 2007 introduced new file extensions:

• .ACCDA – Access add-in file
• .ACCDB – The file extension for the new Office Access 2007 file format. This takes the place of the MDB file extension.
• .ACCDE – The file extension for Office Access 2007 files that are in "execute only" mode. ACCDE files have all Visual Basic for Applications (VBA) source code hidden. A user of an ACCDE file can only execute VBA code, but not view or modify it. ACCDE takes the place of the MDE file extension.
• .ACCDT – The file extension for Access Database Templates.
• .ACCDR – is a new file extension that enables you to open a database in runtime mode. By simply changing a database's file extension from .accdb to .accdr, you can create a "locked-down" version of your Office Access database. You can change the file extension back to .accdb to restore full functionality.
• .ACCDU – Access add-in file
• .MDA – Access add-in file
• .MDE – Access add-in file

• .one – OneNote export file

• .ecf – Outlook 2013+ add-in file

• .pub – a Microsoft Publisher publication

XPS Document

• .xps – a XML-based document format used for printing (on Windows Vista and later) and preserving documents.

See also[edit]

References[edit]

__NO

Excel file extensions are there to identify the file format. For example, in computer operating systems, file extensions are to identify the file type for the operating system so that it runs and opens the file with the specified format.

If you observe at the end of the file name, you will see the extension of that file.

The above image, includes XLSX, XLSM, XLSB, XLS, and XLAM.

I am sure you know about Excel but not about their formats. If you have no idea about Excel file extensions, this is a tailor-made article. In a general case scenario, you must have seen the xlsx file format in Excel. When you try to save the unsaved workbook Excel automatically saves it as an “xlsx” file.

Note: When we save the existing file with a different Excel file format (extension), some of the features of the current file might not be transferred to the new file extension.

Table of contents

Where to Find File Extensions in Excel?

You must be thinking about where these file formats are. These file formats are available when we see the save dialog box. Under the “Save as type,” we can see many of the accessible file formats in the computer system.

If you look at the above image, the first extension the operating system recognizes is Excel Workbook (*.xlsx) format, and all the other remaining forms follow after.

Top 5 Excel file Formats

Below are some of the top file formats for Excel. You may follow this article to explore some of them.

#1 – XLSX

The default Excel format is “XLSX.” However, when we press the “Save As” option, Excel, by default, recognizes this extension. It is the replacement of the earlier extension called XLS. It is the most popular Excel file extension for non-macro files.

Below is the image which shows how the file is saved under this method.

#2 – XLSM

This Excel file format is used for a VBA Macro file. If we are working with macro in Excel, we need to change the Excel extension to enable the smooth flow of macro running. It is the default extension type for a macro containing a workbook.

XLSX does not support the macro code. Therefore, we need to save the workbook as a macro-enabled workbook to run the macros.

While saving the workbook, we need to select the file type as “Excel Macro-Enabled Workbook.”

#3 – XLSB

Often in Excel, we face the issue of too much data, and the Excel file slows down. In addition, if Excel is saved in the form of “XLSX” or “XLSM” Excel, the workbook tends to slow down.

“XLSB” means “Excel Binary Workbook.” If we save the workbook as a binary workbook, it will reduce the weight of the workbook.

Look at the below image, an Excel workbook saved in the form of “XLSX,” and the total workbook weight is 63.4 KB.

Now, we will save this file as “Excel Binary Workbook.”

Now, look at the size of the workbook.

So, Excel binary workbook reduces the workbook size to 59.4 KB. In the case of a large file, it reduces the size of the workbook by 50%.

#4 – XLS

Probably, we may not see this kind of Excel file format these days. However, this file is saved for the binary workbook of Excel 97 to Excel 2003 binary format.

#5 – XLAM

It is the Excel Add-in. Excel Add-insExcel Add-insAn add-in is an extension that adds more features and options to the existing Microsoft Excel.read more are extra features we add to the Excel workbook. Excel has many built-in features. On top of these available features, we can create some macros and make Excel talk according to our wishes.

Once the macro is created, we need to save the file as “Excel Add-ins.” Once the workbook is saved as “Add-in,” click on Developer TabDeveloper TabEnabling the developer tab in excel can help the user perform various functions for VBA, Macros and Add-ins like importing and exporting XML, designing forms, etc. This tab is disabled by default on excel; thus, the user needs to enable it first from the options menu.read more >Excel Add-ins and select the additional feature created by a User Defined Function (UDF).

Other Additional Excel File Formats

We have seen the top five file formats. On top of these, there are many other additional extensions available.

1. XLC: Excel Chart Type
2. XLT: Excel Template
3. XLD: Excel DataBase
4. XLK: Excel Back up

Things to Remember

• For macros, we need to select the “XLSM” type extension.
• We cannot use the workbook of the Excel “Add-in” extension, but we can use that as an add-in in other workbooks.
• If the Excel is saved as “CSV,” it will not be an Excel workbook. It is to store the data, but it is not very easy to work on it. It will reduce the size of the workbook.
• “Excel Binary Workbook” can reduce the workbook size by 50%.

Recommended Articles

This article is a guide to Excel Extensions. We discussed the top file formats, including XLSX, XLSM, XLSB, XLS, and XLAM, their key features, and applications. You may also look at these useful Excel tools below: –

• Equations in Excel ExamplesEquations In Excel ExamplesIn Excel, equations are the formulas we type into cells. We begin by writing an equation with an equals to symbol (=), which Excel knows as calculate.read more
• AutoFill in ExcelAutoFill In ExcelAutoFill in excel can fill a range in a specific direction by using the fill handle.read more
• Excel vs. Google SheetsExcel Vs. Google SheetsIn Google Sheets, we may share a link with other users to permit them to read or edit the sheet at the same time, however in Excel, only one person can edit the file at a time.read more
• How to use Array Formulas in Excel?How To Use Array Formulas In Excel?Array formulas are extremely helpful and powerful formulas that are used in Excel to execute some of the most complex calculations. There are two types of array formulas: one that returns a single result and the other that returns multiple results.read more
• LINEST Excel FunctionLINEST Excel FunctionThe built-in LINEST Function in Excel calculates statistics for a line by the least-squares regression method & returns an array that defines the line proving to be well-suited for the given data.

  Is XLSX a Excel file?

  XLSX is well-known format for Microsoft Excel documents that was introduced by Microsoft with the release of Microsoft Office 2007.

  Which of the following is the extension of MS Excel 2010 template file?

  XLSX Extension in Excel The XLSX extension is the default extension of Excel when there is no use of macros in it. This extension is based on XML and used primarily for Excel 2007 and Excel 2010. Before Excel 2007, the standard file extension for Excel was XLS.