XLS vs. XLSX

XLS and XLSX are the file extension of the Microsoft spreadsheet called Excel. On Excel, you can arrange and store a lot of data in an organized form.

Advertisement - Continue Reading Below
XLS vs. XLSX

The main difference between these two file extensions is that the XLS is created on the version of Excel prior to 2007 while XLSX is created on the version of Excel 2007 and onward. They are also different on the basis of information storing way. XLS is a binary format while that XLSX is Open XML format.

Comparison Chart

Basis XLS XLSX
The Difference XLS is the default file format for the 2003 version of Excel XLSX is the file format for versions since 2007.
Version older version latest version
Performance XLS files are faster especially on files that require the use of the complex formulas for a large set of data. XLSX files are slower especially on files that require the use of the complex formula for a large set of data.
Readability Readable by all Microsoft Excel versions. Only readable by Microsoft Excel versions 2007 and onwards.
Based On Proprietary Binary Format. Open XML format.
Capability XLS is capable of Macros or not. XLSX is not capable to support Macros.
Number of Rows and Columns the last row is 65536 and last column is IV (256 columns). the last row number is 1048576 and the last column letter is XFD (16384 columns).
Advertisement - Continue Reading Below

What is XLS?

XLS is the file extension of the Microsoft Excel spreadsheet. It is created in the versions of Excel prior to 2007. It is a binary format based upon Binary Interchange File Format (BIFF) and thus it stores information in binary format. It is capable of holding the spreadsheets either containing macros or not.

XLS

What is XLSX?

XLSX is also the file extension of the Microsoft Excel spreadsheet. It is created in the versions of the Excel 2007 and onward. It is based on Open XML format. So it stores the information in text file using XML. It doesn’t support the macros.

Advertisement - Continue Reading Below

XLSX

Key Differences between XLS and XLSX

  1. XLSX is the latest version of Microsoft Excel’s as compare to XLS.
  2. XLS is created on the version of Excel prior to 2007 while XLSX is created on the version of Excel 2007 and onward.
  3. XLS is a binary format while that XLSX is Open XML format.
  4. XLS stores information in the binary format while XLSX stores the information in a text file using XML.
  5. XLS is readable by all versions of Microsoft Excel while XLSX is readable by 2007 version of Microsoft Excel and onward.
  6. XLSX is able to read the files in XLS but vice versa is not possible.
  7. XLS is capable of holding the spreadsheets either containing macros or not while XLSX is not capable to support macros.

Video Explanation

Advertisement - Continue Reading Below

1 thought on “XLS vs. XLSX”

Leave a Comment