How We Can See File Extension in Excel Windows
A free Office suite fully compatible with Microsoft Office
The extension of an Excel file provides you with important information about that file before you open it. It also lets you organize the files you save into your directories as template files, macro-enabled files, and more. With just a glance at the Excel file extension, you know more about the Excel file and what it’s used for.
Excel file extensions tell you:
Whether macros or VBA are included.
If the file was saved with an older version of Excel.
Whether the file format is based on XML documents or binary.
The general legacy version of the file was saved.
Whether the file is a template.
Excel File Extensions By Version
The first group of file extensions are related primarily to which version of Excel the worksheet was saved with. The following extension types are connected to the Excel versions shown here:
Excel 97-2003: *.xls
Excel 97-2003 template: *.xlt
XML Spreadsheet 2003: *.xml
Microsoft Excel 5.0/95 Workbook: *.xls
Excel 97-2003 Add-in: *.xlam
Excel 4.0: *.xlw
Microsoft Works: *.xlr
How to Change the Excel file Extension?
For changing the file extension, follow the below steps:
Open the workbook for which you want to change the format.
Go to the Home
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
It will open a dialog box, as shown below.
Select the type in which you want to save your document.
Now you need to select where you want to save the file in the system. Refer to the below screenshot.
I have selected theDocuments for saving this file as a destination.
Under the File namefield, give the file name for the workbook.
Under Save as typefield, 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 Savebutton to save the file.
It will save the file with the extension.
How do you know the file extension of the saved file?
For this, follow the 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 Propertiesoption from the list. Refer to the below screenshot.
It will open a Properties window.
Under the Type of fileoption, 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.
Did you learn how we can see file extensions in excel? You can follow WPS Academy to learn more features of Word Document, Excel Spreadsheets, and PowerPoint Slides.
You can also download WPS Office to edit the word documents, excel, PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to add text to beginning or end of all cells in Excel
- 5. How to color cell based on value in Excel?
- 6. How to compare two excel sheets and highlight differences