Microsoft Office Tutorials and References
In Depth Information
This section describes file types that Excel can open directly, using the File ⇒ Open command. Figure 16-1
shows the list of file filter options you can specify from this dialog box.
Figure 16-1: Filtering by file extension in the Open dialog box.
Spreadsheet file formats
In addition to the current file formats (XLSX, XLSM, XLSB, XLTX, XLTM, and XLAM), Excel 2013 can
open workbook files from all previous versions of Excel:
• XLS: Binary files created by Excel 4, Excel 95, Excel 97, Excel 2000, Excel 2002, and Excel 2003
• XLM: Binary files that contain Excel 4 macros (no data)
• XLT: Binary files for an Excel template
• XLA: Binary files for an Excel add-in
Excel can also open one file format created by other spreadsheet products:
• ODS: OpenDocument spreadsheet.
These files are produced by a variety of “open source” software, including Google Drive, OpenOffice,
LibreOffice, StarOffice, and several others.
Note that Excel does not support Lotus 1-2-3 files, Quattro Pro files, or Microsoft Works files.
Database file formats
Excel 2013 can open the following database file formats:
• Access files: These files have various extensions, including MDB and ACCDB.
• dBase files: Produced by dBase III and dBase IV. Excel does not support dBase II files.