.xls
XLS file: what it is and how to open it
An XLS file is an Excel workbook in the binary format that was Excel’s default from Excel 97 to Excel 2003. Drop one here to read the text and numbers in its sheets.
Drop your XLS file here
Opens on this device. Nothing is uploaded. Any other file works too.
What is an XLS file?
XLS was Microsoft Excel’s default format from Excel 97 in 1997 until Excel 2007 switched to .xlsx. A workbook holds sheets of values and formulas with their formatting, charts and comments. You still meet it in older archives and in exports from websites and business software.
It is a Microsoft format, not an international standard, but Microsoft has published its full specification since 2007, now kept up to date as [MS-XLS]. That is why LibreOffice, Google Sheets, Numbers and many data tools read it. Current Excel still opens and saves it, in Compatibility Mode.
The old format has hard limits: 65,536 rows and 256 columns per sheet, against 1,048,576 rows and 16,384 columns in .xlsx. Unlike .xlsx, the same .xls extension can also carry macros.
What is inside
An XLS file is a Compound File: a small file system inside one file, the same container old .doc and .ppt files use. Its main stream, named Workbook, is a sequence of binary records. A globals part comes first, with the sheet list, fonts, number formats and a shared table of the text used in cells; then each sheet follows with its cells, row by row.
A formula is stored as compiled tokens together with its last calculated value, so a viewer can show results without recalculating. BIFF8, the version Excel 97 introduced, stores text as Unicode. Macros live in a separate storage, and a password to open encrypts the workbook with RC4 or an older, weaker XOR method.
budget.xlsa Compound File (D0 CF 11 E0 …)├─ Workbookthe workbook, as binary records│ ├─ globalssheet list, fonts, formats, shared text│ ├─ Sheet1cells row by row; formulas with last value│ └─ Sheet2├─ SummaryInformationtitle, author and dates└─ _VBA_PROJECT_CUR/macros, if the workbook has anyHow to open an XLS file
Windows
- Microsoft ExcelPaid, through Microsoft 365 or a one-time Office purchase. Opens .xls in Compatibility Mode; File, Info, Convert turns it into an .xlsx.
- LibreOffice CalcFree and open source. Opens, edits and saves .xls.
- Universal File Opener for WindowsOursOpens the workbook read-only in a grid: sort or filter the view and print. Pro saves a values-only .xlsx copy.
Mac
- NumbersFree from Apple. Opens and edits .xls workbooks; drag the file onto the Numbers icon, since double-clicking opens Excel when it is installed.
- LibreOffice CalcFree and open source, the same app as on Windows.
iPhone and iPad
- FilesBuilt in. Tap the file for a read-only preview.
- Collabora OfficeFree, based on LibreOffice. Opens and edits .xls workbooks.
Android
- Google SheetsFree. Opens .xls for editing in Office Compatibility Mode, or converts it to a Google Sheet.
- Collabora OfficeFree, based on LibreOffice. Opens and edits .xls workbooks.
- Universal File OpenerOursReads every worksheet offline in a grid with sheet tabs, search and zoom. The file stays read-only; Pro saves a values-only .xlsx copy.
In a browser
- Excel for the web or Google SheetsFree with an account, after uploading the file. Excel for the web turns it into an .xlsx; Google Sheets cannot open password-protected .xls files.
- Universal File OpenerOursReads retained sheet text in Details, not a cell grid. Nothing is uploaded. Saved formula results are not recalculated.
Won’t open?
The browser shows text instead of cells, or a total is stale
This browser reader has no XLS or ODS grid and does not recalculate their formulas. Use our Android or Windows app for a grid, or Excel or LibreOffice Calc to recalculate and save fresh results.
Windows asks which app to use
Windows has no built-in spreadsheet app. Drop the file on this page, install LibreOffice, or upload it to Excel for the web, which converts it to .xlsx.
Excel says the file format and extension don’t match
The file can be a web page or text table saved under an .xls name, or a renamed .xlsx. If you trust the source, choose Yes, then use File, Save As to save it as an Excel Workbook (.xlsx).
Rows past 65,536 are lost
In the old format Excel cannot save data beyond 65,536 rows by 256 columns, and its Compatibility Checker warns about it. Convert first: File, Info, Convert saves an .xlsx that holds 1,048,576 rows.
Excel blocks the macros
An .xls file can carry macros, and Excel blocks them in files from the internet with a Security Risk bar. Only if you trust the sender, right-click the file, choose Properties and select Unblock.
It asks for a password
The workbook is encrypted. Enter the password in desktop Excel; Google Sheets cannot open password-protected .xls files. A forgotten password cannot be recovered, so ask the sender.
Convert an XLS file
- To XLSXIn Excel, File, Info, Convert. In Google Sheets, open the file and choose File, Download, Microsoft Excel (.xlsx).
- To CSVIn Excel, File, Save As, CSV (Comma delimited). Only the active sheet is saved, so repeat for each sheet.
XLS files in our apps
Read XLS workbooks offline in a read-only grid with sheet tabs, search and zoom, free. Formulas show their saved results. Pro creates a values-only XLSX copy; password-protected and Excel 95 files do not open.
All Android tools and limits for XLS files
- Read cells with sheet tabs, search and zoom. The footer shows row and column counts.
- Read supported merged ranges and hidden sheet, row and column settings.
- "Save Excel copy (values only)..." writes the displayed value of every cell on every worksheet into a new .xlsx, preserving hidden sheet, row and column state. It needs Pro.
- Chart, dialog and macro sheets are omitted. The app reports when non-worksheet tabs are excluded.
- Search, copy, count words and inspect file metadata for free.
Legacy XLS limitations
- The XLS grid is read-only. Cell editing and the Formulas / Values toggle are unavailable.
- Formula cells show their last saved results; they do not recalculate.
- The preview focuses on worksheet values. Some formatting and workbook objects may be missing.
- The values-only copy drops formulas, formatting, macros, charts and other workbook objects. It does not preserve the original workbook structure.
- Open caps: 16 MiB input, 128 worksheets, 100,000 cells, 150,000 records, 75,000 shared strings, 16,384 merged ranges.
- Password-protected files, Excel 5.0/95 workbooks, damaged files and unsupported structures cannot be opened. Save a compatible XLSX copy in the source application when possible.
Walkthrough: Edit Excel spreadsheets on Android