XLS vs XLSX, and how to open either one
XLS and XLSX are both Excel workbook formats, but XLS is an older binary format with stricter limits, while XLSX is the modern ZIP-based format used by current spreadsheet software. You can open either one without Microsoft Excel by using LibreOffice Calc or Google Sheets, although complex formulas, macros, charts and formatting should be checked after opening; see the broader guide to spreadsheet formats for other workbook types you may encounter.
XLS stores a binary workbook, while XLSX uses a package of parts
The extension is not just a different label for the same file. XLS and XLSX organize workbook data differently, and that difference affects capacity, compatibility, repair and the features that can be stored safely.
An XLS file is a legacy binary workbook
XLS was the standard Excel workbook format before Excel 2007. The common Excel 97–2003 version uses the Binary Interchange File Format known as BIFF8, which records worksheets, values, formulas, formatting and other workbook information in a proprietary binary structure.
Because the workbook is encoded as a binary file, you cannot inspect its contents as ordinary text. Spreadsheet applications must understand the relevant BIFF records before they can reconstruct the sheets and display the workbook correctly.
XLS remains useful when a workbook must work with an old computer, an earlier version of Excel or a business system that specifically requires the legacy format. However, choosing XLS for compatibility also imposes older worksheet limits. An XLS worksheet supports up to 65,536 rows and 256 columns. If a modern workbook contains data outside that range, saving it as XLS can discard the extra cells and turn formulas that refer to them into #REF! errors.
An XLS workbook may also contain legacy macros and other active content. That does not mean every XLS file is dangerous, but it does mean you should be cautious with an unexpected workbook received by email or downloaded from an unfamiliar source.
An XLSX file separates workbook content into packaged parts
XLSX became the standard workbook format with Excel 2007 and is the normal choice for a workbook that does not need embedded VBA macros. It belongs to the Office Open XML family.
An XLSX file is a ZIP package containing multiple related parts. These parts can describe worksheets, workbook settings, styles, shared text, relationships, charts and other content. Many parts use XML, while certain embedded items may use binary data. The package structure allows an application to identify and process individual workbook components instead of treating the entire document as one continuous binary stream.
The modern format also supports a much larger worksheet grid: up to 1,048,576 rows and 16,384 columns. This does not guarantee that every application can handle a workbook of that size, because available memory, upload limits and the software’s own restrictions still apply.
The practical differences can be summarized as follows:
| Attribute | XLS | XLSX |
|---|---|---|
| Main era | Excel 97–2003 | Excel 2007 and later |
| Internal structure | Binary BIFF workbook | ZIP package containing XML and related parts |
| Maximum worksheet size | 65,536 rows by 256 columns | 1,048,576 rows by 16,384 columns |
| VBA macro storage | Can contain macros | Cannot store VBA macro code |
| Typical use | Older software or required legacy workflows | Current general-purpose spreadsheets |
| Modern feature support | Restricted by the older format | Supports the modern workbook feature set |
| Best default for a new workbook | Usually no | Usually yes, unless macros require XLSM |
The newer structure also does not guarantee a smaller file in every case. Workbook size depends on its data, formulas, images, formatting and other stored objects. XLSX commonly compresses ordinary worksheet content efficiently, but a media-heavy or unusually complex XLSX file may still be large.
Check the extension, workbook features and opening result
Start by confirming the file’s visible extension. On systems that hide known extensions, a filename such as budget.xls may appear as only budget, making it difficult to distinguish the legacy format from budget.xlsx. File properties or the file information panel should show the complete name and identified type.
Use the extension to choose a compatible application, but do not assume it proves what is actually inside the file. A file can have the wrong extension because someone renamed it, an export process assigned an inaccurate name, a download failed or the file became corrupted.
Changing .xls to .xlsx in the filename does not convert the workbook. It only changes the name presented to the operating system. A real conversion requires an application that can read the original format and write the content into the destination format.
If the file opens, check more than the first visible sheet. A workbook can appear normal at first while containing damaged or unsupported features elsewhere. Review these areas before editing or resaving it:
- Worksheet count. Confirm that every expected sheet is present, including hidden sheets if they are relevant to the workbook.
- Formulas and calculated values. Look for #REF!, #NAME?, #VALUE! and other errors that may indicate unsupported functions or broken references.
- Dates, percentages and currencies. Another application may interpret a date or regional number format differently.
- Charts and PivotTables. Check their source ranges, labels, filters and displayed values rather than judging only their appearance.
- Merged cells and print layout. Page breaks, scaling, margins, repeated headings and print areas may change between applications.
- External links and data connections. A workbook may rely on another local file, a network path, a query or a service that is unavailable on your device.
- Macros and controls. Browser-based editors generally do not reproduce Excel VBA automation, and XLSX cannot preserve VBA code.
- Protection. A password, protected sheet or restricted range may prevent editing even when the workbook itself opens successfully.
- Workbook size. A cloud editor or mobile device may reject a workbook that a desktop application can open.
If an XLS workbook contains more data than the older format can support, the missing information cannot be restored merely by saving it as XLSX. Conversion increases the capacity of the destination format, but it does not recreate data that was already discarded during an earlier save.
Likewise, if a workbook was exported from another program, its extension may be valid even though some Excel-specific behavior is absent. The source application may have replaced formulas with values, simplified charts or omitted unsupported objects during export.
The type of workbook also affects what you should do next:
| What you find | Appropriate action |
|---|---|
| Ordinary XLS workbook with no macros | Open it in a compatible spreadsheet application and consider saving a verified copy as XLSX |
| XLS workbook containing required macros | Keep the original and use macro-capable software; if converting to a modern format, use XLSM rather than XLSX |
| XLSX workbook with ordinary formulas and formatting | Open it directly in a modern desktop or browser-based spreadsheet application |
| Extension does not match the reported format | Do not keep renaming it; obtain a fresh copy or ask the sender which program created it |
| Workbook opens but formulas or charts change | Keep the original untouched and use an application with better support for those features |
| You only need a fixed copy for viewing or printing | Verify the workbook first, then export or convert the final version to PDF |
Open, convert or share the workbook without Excel
You do not need Microsoft Excel merely to view a normal XLS or XLSX workbook. The best method depends on whether you want to inspect the file privately on your computer, edit it collaboratively in a browser or create a fixed copy that no longer behaves like a spreadsheet.
Open XLS or XLSX in LibreOffice Calc
LibreOffice Calc is a desktop spreadsheet application available for Windows, macOS and Linux. It can open both .xls and .xlsx files locally, which makes it a useful option when you do not want to upload the workbook to a cloud service.
- Install LibreOffice from its official website.
- Open LibreOffice Calc.
- Select File, then Open.
- Choose the XLS or XLSX workbook.
- Review the sheets, formulas, charts and formatting before making changes.
- Use Save As if you want to create a converted copy.
If Calc asks whether to keep the Microsoft format or use the OpenDocument Spreadsheet format, choose according to how the file will be used. Keep or save an Excel-compatible format when the workbook must return to someone using Excel. Use ODS when the workbook will remain in LibreOffice and exact Excel compatibility is not required.
Do not dismiss format warnings automatically. LibreOffice may identify features that cannot be represented exactly in the selected destination format. Saving a separate copy lets you compare the result with the original before replacing or distributing anything.
For a simple workbook containing values, common formulas and basic formatting, the result may be nearly identical. A workbook that depends on specialized Excel functions, VBA macros, external data connections, unusual charts or form controls needs more careful testing.
Open XLS or XLSX in Google Sheets
Google Sheets can open and edit Excel workbooks through Google Drive. This is convenient when you need browser access, comments or real-time collaboration and the workbook does not contain features that must run specifically in desktop Excel.
- Open Google Drive and sign in.
- Select New, then File upload.
- Upload the XLS or XLSX file.
- Double-click the uploaded workbook.
- Choose Open with Google Sheets if it does not open in the editor automatically.
- Check formulas, formatting, charts and sheet structure before relying on the result.
Google Sheets can either work with the uploaded Excel file or create a separate Google Sheets version, depending on the action you choose. Converting the file to the native Google Sheets format does not have to alter the original upload, so retain that original while you test the converted copy.
Browser-based editing is useful for straightforward tables, calculations and collaboration, but it is not a full replacement for every Excel feature. Excel-specific functions may be translated, produce a different result or be unavailable. VBA macros do not run as Google Sheets automation, and data connections or embedded controls may not survive the move.
Avoid uploading a confidential workbook to any online service unless you are authorized to store its data there. Financial records, customer lists, employee information and other sensitive content may be subject to organizational security or privacy rules.
Convert the workbook only after checking its contents
When the workbook opens correctly, you can save it in a format that fits its next use. For continued spreadsheet editing, XLSX is usually the best general-purpose choice. Use XLS only when a known legacy application requires it, and use XLSM when modern Excel macro code must be preserved.
A safe XLS-to-XLSX conversion follows this sequence:
- Make a backup of the original XLS file.
- Open the working copy in a compatible spreadsheet application.
- Check whether it contains macros, external links or unsupported features.
- Select Save As or the application’s download command.
- Choose XLSX only if no required VBA macro code needs to be retained.
- Give the converted file a new name rather than overwriting the source.
- Close and reopen the new file.
- Compare important totals, formulas, charts, print areas and worksheet counts with the original.
If you must save a modern XLSX workbook as XLS, first confirm that it stays within the older format’s 65,536-row and 256-column limits. Also check compatibility warnings for features that may be simplified or removed. A successful save does not prove that every modern feature survived.
If the recipient only needs to read, approve or print the finished spreadsheet, PDF may be more suitable than either workbook format. A PDF fixes the page appearance and does not require spreadsheet software, but it also removes normal workbook editing, recalculation, filtering and formula inspection. Keep the original XLS or XLSX file as the editable source, verify its print area and scaling, and create the PDF as a separate delivery copy.
Source: XLS format structure from Excel Binary File Format (.xls) Structure and XLSX package structure from Structure Overview for the XLSX format, Microsoft Learn; workbook formats, macro support and compatibility limits from File formats that are supported in Excel, Worksheet compatibility issues, and A file is in a different format than its extension indicates in Excel, Microsoft Support; non-Excel opening guidance from Using Microsoft Office and LibreOffice and Use both Excel and Sheets: Best practices, LibreOffice Help and Google Docs Editors Help. Page last checked 2 October 2026.