File formats supported in Excel for Windows

You can save an Excel 2013 or Excel 2016 file in another file format by clicking File > Save As. The file formats that are available in the Save As box vary, depending on what type of sheet is active (a worksheet, chart sheet, or other type of sheet). Whenever you save a file in another file format, some of its formatting, data, and features might not be transferred.

To open a file that was created in another file format, either in an earlier version of Excel or in another program, click File > Open.

File formats that are supported in Excel 2013 and Excel 2016

Extension

Name of file format

Description

.csv

CSV (Comma delimited)

Saves a workbook as a comma-delimited text file for use on another Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.

.csv

CSV (Macintosh)

Saves a workbook as a comma-delimited text file for use on the Macintosh operating system, and makes sure that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.

.csv

CSV (MS-DOS)

Saves a workbook as a comma-delimited text file for use on the MS-DOS operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.

.dbf

DBF 3, DBF 4

dBase III and IV. You can open these files formats in Excel, but you cannot save an Excel file to dBase format.

DIF

DIF (Data Interchange Format)

Data Interchange Format. Saves only the active sheet.

.htm, .html

Web Page

Hypertext Markup Language (HTML).

Note    When you copy text from another program, Excel pastes the text in HTML format, regardless of the format of the original text.

.mht, .mhtml

Single File Web Page

Single File Web Page (MHT or MHTML). This file format integrates inline graphics, applets, linked documents, and other supporting items referenced in the document.

.ods

OpenDocument Spreadsheet

OpenDocument Spreadsheet. You can save Excel files so they can be opened in spreadsheet applications that use the OpenDocument Spreadsheet format, such as Google Docs and OpenOffice.org Calc. You can also open spreadsheets in the .ods format in Excel. Formatting might be lost when saving and opening .ods files.

.pdf

PDF

Portable Document Format (PDF). This file format preserves document formatting and enables file sharing. When the PDF format file is viewed online or printed, it retains the format that you intended. Data in the file cannot be easily changed. The PDF format is also useful for documents that will be reproduced by using commercial printing methods.

.prn

Formatted Text (Space delimited)

Lotus space-delimited format. Saves only the active sheet.

.slk

SYLK (Symbolic Link Format)

Symbolic Link Format. Saves only the active sheet.

.txt

Text (Tab delimited)

Saves a workbook as a tab-delimited text file for use on another Microsoft Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.

.txt

Text (Macintosh)

Saves a workbook as a tab-delimited text file for use on the Macintosh operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.

.txt

Text (MS-DOS)

Saves a workbook as a tab-delimited text file for use on the MS-DOS operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.

.txt

Unicode Text

Saves a workbook as Unicode text, a character encoding standard that was developed by the Unicode Consortium.

.xla

Excel 97–2003 Add-In

The Excel 97-2003 Add-In, a supplemental program that is designed to run additional code. Supports the use of VBA projects.

.xlam

Excel Add-In

The XML-based and macro-enabled Add-In format for Excel 2010 and Excel 2007. An Add-In is a supplemental program that is designed to run additional code. Supports the use of VBA projects and Excel 4.0 macro sheets (.xlm).

.xls

Excel 97–Excel 2003 Workbook

The Excel 97 - Excel 2003 Binary file format (BIFF8).

.xls

Microsoft Excel 5.0/95 Workbook

The Excel 5.0/95 Binary file format (BIFF5).

.xlsb

Excel Binary Workbook

The binary file format (BIFF12) for Excel 2010 and Excel 2007.

.xlsm

Excel Macro-Enabled Workbook

The XML-based and macro-enabled file format for Excel 2016, Excel 2013, Excel 2010, and Excel 2007. Stores VBA macro code or Excel 4.0 macro sheets (.xlm).

.xlsx

Excel Workbook

The default XML-based file format for Excel 2010 and Excel 2007. Cannot store Microsoft Visual Basic for Applications (VBA) macro code or Microsoft Office Excel 4.0 macro sheets (.xlm).

.xlsx

Strict Open XML Spreadsheet

An ISO strict version of the Excel Workbook file format (.xlsx).

.xlt

Excel 97 - Excel 2003 Template

The Excel 97 - Excel 2003 Binary file format (BIFF8) for an Excel template.

.xltm

Excel Macro-Enabled Template

The macro-enabled file format for an Excel template for Excel 2016, Excel 2013, Excel 2010, and Office Excel 2007. Stores VBA macro code or Excel 4.0 macro sheets (.xlm).

.xltx

Excel Template

The default file format for an Excel template for Excel 2013, Excel 2010, and Office Excel 2007. Can't store VBA macro code or Excel 4.0 macro sheets (.xlm).

.xlw

Excel 4.0 Workbook

An Excel 4.0 file format that saves only worksheets, chart sheets, and macro sheets. Users can open a workbook in this file format in Excel 2013. But, users can't save an Excel file to this file format.

.xml

XML Spreadsheet 2003

XML Spreadsheet 2003 file format.

.xml

XML Data

XML Data format.

.xps

XPS Document

XML Paper Specification, a file format that preserves document formatting and enables file sharing. When the XPS file is viewed online or printed, it maintains exactly the format that users intended, and the data in the file cannot be easily changed.

Notes: The following file formats aren't supported:

  • Excel Chart (Excel 2.0, 3.0, and 2.x file formats) (.xlc)

  • Lotus 1-2-3 file formats (all versions) (.wk1, .wk2, .wk3, .wk4, .wks)

  • Microsoft Works (all versions) (.wks)

  • DBASE II file format (.dbf)

  • Quattro Pro for MS-DOS file format (.wq1)

  • Quattro Pro 5.0 and 7.0 for Windows (.wb1, .wb3)

Opening or viewing unsupported file formats

If the file format you want to use is not supported, try the following:

  • Search the Internet for a company that makes file format converters for file formats that are not supported.

  • Save to a file format that another program supports and then export from that program into a file format that Excel supports.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×