Why can't I open my Excel file?

Having trouble opening a file? It’s probably because it has been saved in a file format that this version of Excel doesn’t support. Find your device and then 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 do not 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 do not 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 do not 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

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×