XLS vs XLSX
A detailed comparison of Excel Spreadsheet (Legacy) and Excel Spreadsheet — file size, quality, compatibility, and which format to choose for your workflow.
Short answer: use XLSX. It's been the Excel default since 2007, handles 16× more rows and 64× more columns, files are ~50% smaller, and macros are sandboxed. Use XLS only when you're forced to by legacy software (old ERPs, accounting tools from before 2010). Below: the technical specs, use cases, and migration notes.
XLS vs XLSX at a glance
| Dimension | XLS | XLSX |
|---|---|---|
| Released | 1987 (Excel 2.0) | 2007 (Excel 2007) |
| File format | BIFF (binary) | OOXML (zipped XML) |
| Max rows | 65,536 | 1,048,576 |
| Max columns | 256 | 16,384 |
| File size | Larger (uncompressed) | ~50% smaller (zipped) |
| Macros | VBA only | VBA (.xlsm) or none (.xlsx) |
| Conditional formats | Up to 3 | Unlimited |
| Recommended for | Legacy compatibility | Everything modern |
When should you use XLS vs XLSX?
XLS Use when…
Pick XLS only when forced. Legacy enterprise software (older SAP, JD Edwards, internal accounting tools predating 2010) sometimes refuses XLSX. The format itself is binary BIFF (Binary Interchange File Format), which makes it opaque — you can't peek inside, can't diff, and it's more vulnerable to macro-based malware because the structure is harder to scan. The hard caps hurt: max 65,536 rows and 256 columns means modern data quickly exceeds the format. If your environment supports it at all, choose XLSX.
XLSX Use when…
Pick XLSX for everything modern. It's been the default since Excel 2007, supports up to 1,048,576 rows × 16,384 columns, and the underlying OOXML format is just zipped XML — you can rename to .zip and inspect the structure. Files are typically 30-50% smaller than equivalent XLS because of the zip compression. Macros live in a separate .xlsm extension, making it easier to audit untrusted files. Every modern tool — Excel, Google Sheets, LibreOffice, Numbers, Python's openpyxl — opens XLSX natively.
Best format by use case
Modern offices
XLSX is the default since Excel 2007 and supported everywhere
Winner: XLSXLegacy systems
Old ERPs and accounting software may only read XLS
Winner: XLSBig datasets (>65k rows)
XLS hard-caps at 65,536 rows; XLSX handles 1M+
Winner: XLSXSecurity audits
XLSX is XML — auditable, diff-able, easier to scan for malicious macros
Winner: XLSXCloud storage
XLSX files are 30-50% smaller, faster to sync
Winner: XLSXProgrammatic generation
OOXML libraries (openpyxl, ExcelJS) are simpler than legacy BIFF
Winner: XLSXExcel Spreadsheet (Legacy)
Spreadsheets & DataXLS is the legacy binary format for Microsoft Excel 97-2003 spreadsheets. While superseded by XLSX, it remains common in archived data and older business systems.
About XLS filesExcel Spreadsheet
Spreadsheets & DataXLSX is the modern Microsoft Excel format based on Open XML. It is the industry standard for spreadsheets, supporting formulas, charts, pivot tables, and conditional formatting.
About XLSX filesStrengths Comparison
XLS Strengths
- Universal legacy — every Excel since 1997 opens .xls natively.
- Binary format is compact and loads quickly.
- Full support for formulas, charts, pivots, and VBA macros.
- Deep integration with every accounting and ERP system of the 1990s-2000s.
XLSX Strengths
- Much smaller than legacy .xls files thanks to ZIP + XML.
- Human-readable structure — easy to extract data programmatically.
- Supports macros (as .xlsm variant), charts, pivot tables, conditional formatting.
- Universal support: Excel, LibreOffice, Google Sheets, Numbers, pandas.
- ISO/IEC 29500 standardized.
Limitations
XLS Limitations
- Row/column limits are ~64× smaller than modern XLSX.
- Macro-enabled variants are a notorious malware vector.
- Binary corruption often means total data loss.
- Cannot represent modern Excel features (dynamic arrays, LAMBDA, structured references).
- Microsoft stopped evolving the format in 2007.
XLSX Limitations
- Macros in .xlsm are a common malware vector — disabled by default in Office.
- 1M-row limit is a cultural problem — people put too much data in Excel.
- Subtle formula differences between Excel, LibreOffice, and Sheets.
- Large files with many formulas recalculate slowly.
Technical Specifications
| Specification | XLS | XLSX |
|---|---|---|
| MIME type | application/vnd.ms-excel | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet |
| Max rows | 65 536 (Excel 97-2003) | 1,048,576 |
| Max columns | 256 (A to IV) | 16,384 |
| Container | OLE Compound File | ZIP (Office Open XML) |
| Successor | .xlsx (2007) | — |
| Released in | — | Microsoft Office 2007 |
| Variants | — | .xlsx, .xlsm (macros), .xlsb (binary) |
Typical File Sizes
XLS
- Simple budget (1 sheet) 30-60 KB
- Multi-sheet financial model 500 KB - 5 MB
- Data export with 65 000 rows 5-20 MB
XLSX
- Small budget spreadsheet 20–80 KB
- Financial model with charts 1–10 MB
- Large dataset (100k rows) 10–50 MB
- Enterprise model (1M+ rows) 100–500 MB
Technical deep dive: XLS vs XLSX
The technical leap from BIFF to OOXML. XLS uses Microsoft's Binary Interchange File Format (BIFF), a closed binary format that hasn't received meaningful spec updates since the early 2000s. Reading or writing XLS programmatically requires reverse-engineered libraries (libxls, xlrd) that struggle with edge cases. Worse, BIFF embeds VBA macros directly in the file — and because the format is opaque, malicious macros are harder to detect.
XLSX uses Office Open XML (OOXML), an ISO-standardized format (ISO/IEC 29500) that's just a ZIP archive containing XML files. Rename report.xlsx to report.zip, unzip it, and you'll see folders like xl/worksheets/sheet1.xml containing your data as plain XML. This makes XLSX easy to generate from any language (Python's openpyxl, Node's ExcelJS, Ruby's Spreadsheet, even bash with zip + sed in a pinch) and easy to audit.
The capacity gap is huge. XLS caps out at 65,536 rows × 256 columns — a single year of daily transactions for a busy SaaS company will exceed this. XLSX handles 1,048,576 rows × 16,384 columns, ~16× more rows and 64× more columns. For modern data analytics this matters: dumps from databases, log analyses, large CSVs converted to Excel — all need XLSX.
Macros and security. XLS files always have macros enabled (or disabled), no separation. XLSX splits this: .xlsx is macro-free by default (safe to share), .xlsm is explicitly macro-enabled (a security warning appears). This separation is one of the strongest reasons to migrate: a malicious XLS attachment can ship malware silently, but an unexpected .xlsm raises immediate suspicion.
Migration is one-click. In Excel: File → Save As → choose .xlsx. In Google Sheets: File → Download → Microsoft Excel (.xlsx). For batch conversion of legacy XLS folders, use XLS → XLSX online. Almost no XLS files actually need to stay XLS; the format is a 35-year-old relic kept alive by a handful of unmaintained enterprise tools.
Ready to convert?
Convert between XLS and XLSX online, free, and without installing anything. Encrypted upload, automatic deletion after 60 minutes.
Frequently Asked Questions
XLSX is the default file format created by Excel 2007 and later. \"Excel\" refers to the program; \"XLSX\" is the format. They go hand in hand.
Excel 2003 and older cannot open XLSX natively, but Microsoft offers a free Compatibility Pack that adds support. Excel 2007+ opens both XLS and XLSX.
Yes — XLSX is macro-free by default. Macros require the explicit `.xlsm` extension, which triggers security warnings in Excel.
1,048,576 rows × 16,384 columns. XLS caps at 65,536 rows × 256 columns, which modern datasets quickly exceed.
Open in Excel, File → Save As → choose XLSX. Or use our [free XLS to XLSX converter](/convert/xls-to-xlsx) for batches without installing Excel.
Generally no. The reverse (XLSX to XLS) can lose data if you exceed XLS row/column limits or use features like new chart types added after 2007.
XLS is the legacy Microsoft Excel binary format used from 1987 to 2007, storing worksheets, formulas, charts, and VBA macros. Excel 97 switched XLS to the OLE Compound File container. It was replaced as default by XLSX in Office 2007 but survives in legacy financial systems and older government databases.
XLS files open in every Excel version since 1997, Google Sheets (free), LibreOffice Calc (free), Apple Numbers, and most online viewers. The maximum worksheet size in XLS is 65 536 rows × 256 columns — modern XLSX raises those limits dramatically.