Excel Extensions

Extension File (Table of Contents)

• Extensions of Excel
• How to Change the Excel file format or Extension?
• How do you know the file type of saved file?

Extensions of Excel

Excel is one the tool which has a variety of extension in which we can save the file. A commonly used extension in Excel is .xlsx, which is used for storing a simple type of data. XLS is another type of default extension which was used until MS Office 2007. For storing a VBA code, we have XLSM. This is purely made for macros. Another extension, CSV (Comma Separated Values), delimits the data, which is separated by commas. XLSB extension is used for compression, saving, opening etc.

For example, the filename “XYZ.doc” has an extension of “.doc, ” a file extension associated with the document file.

Excel file extensions can be of various types. Here we will cover the most common file type:

• XLS – Excel file extension

This extension is the most common and default type in the spreadsheet generated by Microsoft office. Prior to Excel 2007, the file extension was XLS. This extension refers to a file which contains all type of information including data, formats, graphics etc. The operating system recognizes the file type with the help of an extension and operates this file using the Excel application.

The XLS is the default file type for Excel version 2.0 to Excel 2003.

• XLSX – Excel file extension

This extension is used by the spreadsheet files generated with the Excel version 2007 onwards. For an Excel file, the current default file extension is XLSX.

XSLX is an XML based file format. With the use of this technology, the file with XSLX format is very less in weight or size, and as compared to the XLS file format, this leads directly to saving space. It requires less time to download or upload excel documents.

Only one disadvantage of this XSLX extension is that this version is incompatible to run the files prior to Excel 2007.

• XLSM – Excel file extension

This extension file type is generated by the spreadsheet with the excel version 2007 onwards, including Excel macros.

With the help of an extension, it’s easy to understand that the file contains a macro. Because of security reasons and for protecting a file with computer viruses, malicious macros, infecting computers, etc., this version comes into existence.

This file extension is very reliable in terms of macros and for security reasons.

• XLSB – Excel file extension

If excel files contain a large amount of data or information, this file extension type fully supports in the compression process, saving, opening, etc.

An excel file that contains a large amount of data takes a lot of time in the opening in processing that file. Sometimes while opening, it gets hanged and frequently crashes.

How to Change the Excel file format or Extension?

For changing the file extension, follow the below steps:

• Open the workbook for which you want to change the format.
• Go to the FILE tab.

• It will open a left pane window. There are a lot of options available in this pane. Refer to the below screenshot.

• Click on Save As option as shown below.

• It will open a dialog box, as shown below.

• Now you need to select where you want to save the file in the system. Refer to the below screenshot.

• I have selected the Desktop for saving this file as a destination.

• Under the File name field, give the file name for the workbook.

• Under Save as type field, we need to choose the file format.
• Click on Save as type filed; it will open a list of formats as shown in the below screenshot.

• Choose the file format and click on the Save button for saving the file.

• It will save the file with the extension.

How do you know the file type of saved file?

For this, follow below steps:

• Select the file for which you want to know the file format.
• Right-click on that file.
• It will open a drop-down list of options.
• Click on the Properties option from the list. Refer to the below screenshot.

• It will open a Properties window.
• Under the Type of file option, you can see the file type or extension of the file. Refer to the below screenshot.

Things to Remember about Excel File Formats

• Any file format doesn’t support all the features of excel like formulas etc.; then it will display an alert message box.
• Then you can change the file format again.

Recommended Articles

This has been a guide to Extensions of Excel. Here we discuss how to Change the Excel file format or Extension along with its practical examples. You can also go through our other suggested articles –

1. Cheat Sheet of Excel Formulas
2. CSV Files into Excel
3. Sort Columns in Excel
4. Data Table in Excel