Having trouble opening a file? It’s probably because it's been saved in a file format that this version of Excel doesn’t support. Check the table to see if that’s the case.
File type |
Open and edit |
Open as read-only |
---|---|---|
Excel workbooks (.xlsx) |
Yes |
Yes |
Excel workbooks (.xls) |
No |
Yes |
Excel templates (.xltx) |
No |
No |
Non-XML binary workbooks (.xlsb) |
Yes |
Yes |
Comma-delimited (.csv) |
No |
Yes |
Macro-enabled workbooks (.xlsm) |
Yes VBA functions won't run. |
Yes |
OpenDocument spreadsheet (.ods) |
No |
Yes |
Excel templates (.xlt) |
No |
Yes |
Macro-enabled templates (.xltm) |
No |
No |
Macro-enabled add-ins (.xla and .xlam) |
No |
No |
Extensible markup language (.xml) |
No |
No |
Data interchange format (.dif) |
No |
No |
Hypertext markup language (.htm, .html) |
No |
No |
Web pages (.mht) |
No |
No |
Printable files (.prn) |
No |
No |
Symbolic link files (.slk and .sylk) |
No |
No |
Plain text file (.txt) |
No |
No |
Binary interchange file formats (Biff2, Biff3, Biff 4, Biff 5) |
No |
No |
File type |
Open and edit |
Open as Read-Only |
---|---|---|
Excel workbooks (.xlsx) |
Yes |
Yes |
Excel workbooks (.xls) |
No |
Yes |
Excel templates (.xltx) |
No |
Yes |
Non-XML binary workbooks (.xlsb) |
No |
Yes |
Comma-delimited (.csv) |
No |
Yes |
Macro-enabled workbooks (.xlsm) |
Yes VBA functions won't run. |
Yes |
OpenDocument spreadsheet (.ods) |
No |
Yes |
Excel templates (.xlt) |
No |
Yes |
Macro-enabled templates (.xltm) |
No |
No |
Macro-enabled add-ins (.xla and .xlam) |
No |
No |
Extensible markup language (.xml) |
No |
No |
Data interchange format (.dif) |
No |
No |
Hypertext markup language (.htm, .html) |
No |
No |
Web pages (.mht) |
No |
No |
Printable files (.prn) |
No |
No |
Symbolic link files (.slk and .sylk) |
No |
No |
Plain text file (.txt) |
No |
No |
Binary interchange file formats (Biff2, Biff3, Biff 4, Biff 5) |
No |
No |
File type |
Open and edit |
Open as read-only |
---|---|---|
Excel workbooks (.xlsx) |
Yes |
Yes |
Excel workbooks (.xls) |
No |
Yes |
Non-XML binary workbooks (.xlsb) |
No |
Yes |
Comma-delimited (.csv) |
No |
Yes |
Macro-enabled workbooks (.xlsm) |
Yes VBA functions won't run. |
Yes |
OpenDocument spreadsheet (.ods) |
No |
Yes |
Excel templates (.xlt) |
No |
Yes |
Macro-enabled templates (.xltm) |
No |
No |
Macro-enabled add-ins (.xla and .xlam) |
No |
No |
Extensible markup language (.xml) |
No |
No |
Data interchange format (.dif) |
No |
No |
Hypertext markup language (.htm, .html) |
No |
No |
Web pages (.mht) |
No |
No |
Printable files (.prn) |
No |
No |
Symbolic link files (.slk and .sylk) |
No |
No |
Plain text file (.txt) |
No |
No |
Binary interchange file formats (Biff2, Biff3, Biff 4, Biff 5) |
No |
No |