EDUCBA

EDUCBA

MENUMENU
  • Blog
  • All Courses
  • All in One Bundle
  • Login
Home Excel Excel Resources Excel Tips Excel Extensions

Excel Extensions

Madhuri Thakur
Article byMadhuri Thakur

Updated August 16, 2023

Extensions of Excel

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 the Saved File?

Extensions of Excel

Excel is one of the tools with various extensions in which we can save the file. A commonly used extension of Excel is .xlsx, which is used for storing a simple type of data. XLS is another default extension type 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 separated by commas. XLSB extension is used for compression, saving, opening, etc.

For example, the filename “XYZ.doc” has a “.doc” 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. Before Excel 2007, the file extension was XLS. This extension refers to a file that contains all types 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 this technology, the file with XSLX format is much less in weight or size, and compared to the XLS file format, this leads directly to saving space. It requires less time to download or upload Excel documents.

The only disadvantage of this XSLX extension is that this version is incompatible with running files before Excel 2007.

  • XLSM – Excel File Extension

The spreadsheet with the Excel version 2007 onwards generates this extension file type, 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 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 hung and frequently crashes.

How to Change the Excel File Format or Extension?

To change the file extension, follow the below steps:

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

Step 1

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

Step 2

  • Click on the Save As option, as shown below.

Step 3

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

Step 4

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

Excel Extensions Step 1-5

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

Excel Extensions Step 1-6

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

Excel Extensions Step 1-7

  • Under the 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.

Excel file formats

  • Choose the file format and click the Save button to save the file.

Excel Extensions Step 1-9

  • It will save the file with the extension.

How do you know the File Type 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 Properties option from the list.

Excel Extensions Step 2-1

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

file formats excel

Things to Remember about Excel File Formats

  • If 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 and 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
MICROSOFT POWER BI Course Bundle - 8 Courses in 1
34+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
MS Excel & VBA for Data Science Course Bundle - 24 Courses in 1 | 10 Mock Tests
87+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
All-in-One Financial Analyst Masters Training Program Bundle - 550+ Courses | 300+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hours of HD Videos
43 Learning Paths
550+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
All-in-One Data Science Bundle - 400+ Courses | 550+ Mock Tests | 2000+ Hours | Lifetime |
2000+ Hour of HD Videos
80 Learning Paths
400+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Popular Course in this category
MS Excel Course Bundle - 36 Courses in 1 | 13 Mock Tests
 137+ Hours of HD Videos
36 Courses
13 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.9
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more