excel Excel file formats

Excel 2007 introduced a new default file format, and that format is also used in Excel 2010.
However, these recent versions can still read and write older Excel file formats.
To change the default file save setting, choose File➜Options and click the Save tab in
the Excel Options dialog box. You’ll find a drop-down list that lets you select the
default file format.
Table 4-2 lists the Excel file types that Excel 2010 supports. Keep in mind that an Excel workbook
or add-in file can have any extension that you like. In other words, these files don’t need to be
stored with the standard extensions shown in the table. However, Excel may display a warning if
you try to open a file in which the content does not match the extension.
Table 4-2: Excel File Types
File Type Extension Read/Write Notes
Excel Workbook xlsx Yes/Yes The default Excel 2010 file format. It can’t store VBA
or XLM macro code.
Excel Macro-Enabled
Workbook
xlsm Yes/Yes The Excel 2010 file format for workbooks that contain
macros.
Excel Binary
Workbook
xlsb Yes/Yes The Excel 2010 binary file format. It’s an updated version of the previous XLS format.
Template xltx Yes/Yes The Excel 2010 file format for a template. It can’t
store VBA or XLM macro code.
Macro-Enabled
Template
xltm Yes/Yes The Excel 2010 file format for a template that contains macros.
Excel Add-In xlam Yes/Yes The Excel 2010 file format for an add-in. It can store
VBA and XLM macros.
Excel 97–Excel 2003
Workbook
xls Yes/Yes The Excel binary format (BIFF8) that’s compatible
with Excel 97 through Excel 2003.
Excel 97–Excel 2003
Template
xlt Yes/Yes The Excel binary template format (BIFF8) that’s compatible with Excel 97 through Excel 2003.

File Type Extension Read/Write Notes
Excel 97–Excel 2003
Add-In
xla Yes/Yes The Excel binary format (BIFF8) for add-ins that’s
compatible with Excel 97 through Excel 2003.
Microsoft Excel
5.0/95 Workbook
xls Yes/Yes The Excel binary format (BIFF5) that’s compatible
with Excel 5.0 and Excel 95.
XML Spreadsheet
2003
xml Yes/Yes Microsoft’s XML Spreadsheet 2003 file format
(XMLSS).