Excel Functions Tutorials
- Excel Tips
- Excel vs Access
- Excel Rows vs Columns
- Apple Numbers vs Excel
- 3D Reference in Excel
- Absolute Reference in Excel
- Mixed References in Excel
- Excel Reference to Another Sheet
- Array Formulas in Excel
- Arrays in Excel VBA
- Auto Numbering in Excel
- AutoFit in Excel
- AutoCorrect in Excel
- AutoSave in Excel
- AutoRecover in Excel
- Bullet Points in Excel
- Break Links in Excel
- Barcode in Excel
- Change Case in Excel
- CAGR Formula in Excel
- Calculate Age in Excel
- Calculate Percentage in Excel Formula
- Cell Reference in Excel
- Checklist in Excel
- Circular Reference in Excel
- Column Sort in Excel
- Column Lock in Excel
- Move Columns in Excel
- Custom List in Excel
- Consolidate in Excel
- Combine Cells in Excel
- Compare Two Columns in Excel
- Compare and Match Columns in Excel
- Compound Interest Formula in Excel
- Convert Columns to Rows in Excel
- Convert Date to Text in Excel
- Convert Numbers to Text in Excel
- Convert Text to Numbers in Excel
- Convert Excel to CSV
- Count Characters in Excel
- Count Rows in Excel
- Count Unique Values in Excel
- Countif not Blank in Excel
- Create Templates in Excel
- Family Tree in Excel Template
- Custom Number Format in Excel
- Delete Row Shortcut in Excel
- Divide in Excel Formula
- Drop Down List in Excel
- Dynamic Tables in Excel
- Dashboard in Excel
- KPI Dashboard in Excel
- Date to Text in Excel
- Date Format in Excel
- Database in Excel
- Delta Symbol in Excel
- $ Symbol in Excel
- Excel Column to Number
- Edit Drop-Down List in Excel
- Equations in Excel
- Exponents in Excel
- Excel Extensions
- Excel Translate
- Excel Not Responding
- Excel Find and Replace
- Find and Select in Excel
- Excel Subtraction Formula
- Excel Formula for Grade
- Excel as Calculator
- Excel Formula Not Working (Updating)
- Excel Table Styles & Formats
- Excel vs Google Sheets
- External Links in Excel
- Excel Alternate Row Color
- Excel Worksheet Tab
- Extract Number from String Excel
- Evaluate Formula in Excel
- Find Duplicates in Excel
- Finding Links in Excel
- Filter Shortcut in Excel
- Formatting in Excel
- Format Numbers to Millions & Thousands in Excel
- Format Phone Numbers in Excel
- Formula Errors in Excel
- Fractions in Excel
- Frequency Distribution in Excel
- Group in Excel
- Group Worksheets in Excel
- Group Columns in Excel
- Hide Formula in Excel
- Hiding a Column in Excel
- Highlight Every Other Row in Excel
- Highlight Duplicates in Excel
- How to Create a Formula in Excel?
- How to Create an Excel Spreadsheet?
- How to Add Text in Excel Formula?
- How to Create Dashboard in Excel?
- How to Copy Sheet in Excel?
- How to Delete Pivot Table?
- How to Calculate Percentage Increase in Excel?
- How to Multiply in Excel Formula?
- How to Unhide Columns in Excel?
- Insert Date in Excel
- Insert Calendar in Excel
- Import Data into Excel
- Insert Comment in Excel
- Insert Hyperlinks in Excel
- Insert Multiple Rows in Excel
- Insert Row Shortcut in Excel
- Insert New Worksheet in Excel
- Insert (Embed) an Object in Excel
- Insert Image in Excel Cell
- Insert Page Break in Excel
- Line Breaks in Excel
- Linear Interpolation in Excel
- Leading Zeros in Excel
- Last Day of the Month in Excel
- Logical Operators in Excel
- Lookup Table in Excel
- Mortgage Calculator in Excel
- Moving Average in Excel
- Not Equal to in Excel
- Numbering in Excel
- Name Manager in Excel
- Page Numbers in Excel
- Page Break in Excel
- Personal Budget Template in Excel
- Project Management Template in Excel
- Percentage Difference in Excel (Increase / Decrease)
- Pivot Table Calculated Field & Formula
- Pivot Table Sort
- Pivot Table From Multiple Sheets
- Print Comments in Excel
- Print Excel Gridlines
- Print in Excel
- Print Preview in Excel
- Print Area in Excel
- Print Titles in Excel
- Print Labels From Excel
- Project Timeline in Excel
- Protect Sheet in Excel
- Ratio in Excel Formula
- Random Numbers in Excel
- Randomize List in Excel
- Refresh Pivot Table in Excel
- Relative References in Excel
- Remove Blank Rows in Excel
- Remove Duplicates in Excel
- Remove Duplicates from Excel Column
- Remove Hyperlinks in Excel
- Remove Space in Excel
- Remove Leading Spaces in Excel
- Remove Watermark in Excel
- Row Limit in Excel
- Rows and Columns in Excel
- Rows to Columns in Excel
- Row Header in Excel
- Search in Excel
- Search For Text in Excel
- Share an Excel Workbook
- Shortcut to Merge Cells in Excel
- Show Formula in Excel
- Split Cells in Excel
- Separate Text in Excel
- Strikethrough in Excel
- Strikethrough Text in Excel
- Sum by Color in Excel
- Subscript in Excel
- Superscript in Excel
- Themes in Excel
- Timesheet Calculator in Excel
- Top 20 Keyboard Shortcuts in Excel
- Unmerge Cells in Excel
- Uppercase in Excel
- Word Count in Excel
- Word Cloud in Excel
- Watermark in Excel
- Weighted Average in Excel
- Wildcard in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- VBA (162+)
- Power Bi (35+)
Excel Extensions (Table of Contents)
Extensions in Excel
What is the first thing will come to your mind when you think of extensions. When I joined a company, the first thing I learned about extensions was telephone extensions. Telephone extensions are there to reach specific persons in the company. Every person assigned an extension to reach out to him. Similarly, in excel we have extensions to reach out specific excel workbooks.
If you observe at the end of the file name you will see the extension of that file.
In the above image, extensions are XLSX, XLSM, XLSB, XLS, and XLAM.
Excel File Extensions are there to identify the file format. 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.
I am sure you know about excel but not about their formats. If you have no idea about excel File extensions this is the tailor-made article for you.
In a general case scenario, you must have seen xlsx file format in excel. When you try to save the unsaved excel workbook excel automatically save it as “xlsx” file.
Note: When we save the existing file with the different excel file format (extension) some of the existing files features might not be transferred to the new file extension.
Where to Find File Extensions in Excel?
You must be thinking where these file formats are. These file formats are available when you see the save dialogue box. Under the Save as type, we can see many of the available file formats in the computer system.
If you look at the above image the first extension operating system recognises is Excel Workbook (*.xlsx) format and all the other remaining formats follow after.
Top 5 Excel file Formats
Below are some of the Top file formats for excel. Follow this article to explore some of them.
#1 – XLSX – Excel Extension XLSX
The default excels format is XLSX, when you hit save as option excels by default recognises this extension. This is the replacement of the earlier extension called XLS. This is the most popular excel file extension for the non-macro file.
Below is the image which shows the how the file is saved under this method.
#2 – XLSM -Excel Extension XLSM
This excel file format is used for VBA Macro file. If you are working with macro in excel you need to change the excel extension to enable the smooth flow of macro running. This is the default extension type for macro containing workbook.
XLSX does not support the macro code. In order to run the macros, you need to save the workbook as a macro-enabled workbook.
While saving the workbook we need to select the file type as Excel Macro-Enabled Workbook.
#3 – XLSB – Excel Extension XLSB
Often in excel we face the issue of too much of the data and excel fil slows down. If the excel is saved in the form of XLSX or XLSM excel workbook tends to slow down.
XLSB means Excel Binary Workbook. If you save the workbook as 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 I will save this file as Excel Binary Workbook.
Now, look at the size of the workbook.
So excel binary workbook reduce 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 – Excel Extension XLS
Probably you will not see this kind of excel file format these days. This file is saved for binary workbook of Excel 97 to Excel 2003 binary format.
#5 – XLAM – Excel Extension XLAM
This is the Excel Add-in. Excel Add-ins are extra features we are adding to the excel workbook. Excel has many built-in features on top of these available features we create some macros and make the excel talk according to our wish.
Once the macro is created we need to save the file as Excel Add-in. Once the workbook is saved as Add-in click on Developer Tab > Excel Add-in a select the additional feature created by a user-defined function.
Other Additional Excel File Formats
We have seen top five file formats on top these there are many other additional extensions are available.
- XLC: Excel Chart Type
- XLT: Excel Template
- XLD: Excel Data Base
- XLK: Excel Back up
Things to Remember About Excel File Formats
- For macros, we need to select XLSM type extension
- We cannot use the workbook of 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. This is just to store the data but very complicated to work on it. It will reduce the size of the workbook.
- Excel Binary workbook reduces the size of the workbook by 50%.
This has been a guide to Excel Extensions. Here we will discuss the top file formats including XLSX, XLSM, XLSB, XLS & XLAM, its key features and applications. You may also look at these useful excel tools below –