When opening a Microsoft Excel document (.xlsx, .xls, or .xlsm) in Google Drive or desktop Excel, you may see a prominent “Compatibility Mode” banner or an .XLSX format badge next to the document title. This signal warns you that the file is operating under constrained formatting rules to maintain interoperability across different spreadsheet engines or older file specifications.
Quick Answer
Excel files open in Compatibility Mode because they are either formatted in legacy Excel 97–2003 binary (
.xls) format, or they are modern.xlsxfiles running inside Google Sheets’ “Office Editing” mode. To unlock all features, convert legacy files to modern.xlsxor save the spreadsheet as a native Google Sheet viaFile > Save as Google Sheets.
What Compatibility Mode Means
Compatibility Mode behaves differently depending on whether you are viewing the file inside Google Workspace or Microsoft Excel:
1. Inside Google Sheets (Office Editing Mode)
When you double-click an .xlsx file in Google Drive, Google Sheets opens the document using Office Editing for Docs, Sheets, and Slides.
- The Indicator: A blue
.XLSXbadge appears beside the spreadsheet name at the top left. - The Constraint: Google Sheets edits the native Microsoft XML file directly without converting it to Google’s internal format.
- The Trade-Off: Because the file remains an Excel document, certain native Google Sheets capabilities—such as Apps Script automations, named version tracking, dynamic array extensions, and specific collaboration add-ons—are temporarily disabled or limited.
2. Inside Microsoft Excel (Legacy .xls Mode)
If an Excel file opens in Compatibility Mode on desktop software:
- The Cause: The file was saved in the legacy Excel 97–2003 Workbook (
.xls) binary format rather than modern Office Open XML (.xlsx). - The Constraints: The spreadsheet is locked to historic boundaries:
- Maximum capacity of 65,536 rows and 256 columns (compared to 1,048,576 rows in modern
.xlsx). - Advanced formulas (such as
XLOOKUP,UNIQUE, andLET) are blocked or wrapped in compatibility tags. - Modern charting, conditional formatting rules, and modern encryption cannot be applied.
- Maximum capacity of 65,536 rows and 256 columns (compared to 1,048,576 rows in modern
How Compatibility Mode Affects Formulas and Features
Editing files in this mode creates functional limitations that can disrupt complex business models:
| Feature / System | In Compatibility / Office Editing Mode | After Full Conversion |
|---|---|---|
| Macros & Automation | VBA macros cannot execute in Google Sheets; Apps Script cannot run on .xlsx directly. | Convert to Google Sheets to write Apps Script; run VBA natively in desktop Excel. |
| Grid Capacity | .xls files cap at 65,536 rows. | Modern .xlsx supports 1M rows; Google Sheets supports up to 10M cells. |
| Collaboration | Basic simultaneous editing works in Sheets, but advanced revision tagging is restricted. | Complete version histories, cell edit tracking, and named milestones unlock. |
| External Links | Formulas referencing other Excel files ([Workbook.xlsx]Sheet1!A1) break in web views. | Native Google IMPORTRANGE can be deployed across documents. |
For issues involving large-scale spreadsheets approaching system thresholds, see Why Google Sheets says “Workbook too large to open” and Troubleshooting “Too many cells” (Excel to Sheets).
Step-by-Step: How to Exit Compatibility Mode
Depending on your workflow needs, choose one of the following remediation paths:
Method A: Convert to Native Google Sheets (Recommended for Cloud Workflows)
If your team primarily collaborates using web browsers and relies on Google Workspace features:
- Open the
.xlsxfile inside Google Sheets. - Click the File menu at the top left.
- Select Save as Google Sheets.
- A brand-new native Google Sheet is created. The blue
.XLSXbadge disappears, and all Google Workspace features (including Apps Script and detailed revision history) become fully accessible. - The original
.xlsxfile remains untouched in your Drive as a backup.
To troubleshoot macro conversions during this transition, review Resolving Script errors (Excel VBA to Apps Script).
Method B: Upgrade Legacy .xls to Modern .xlsx (Recommended for Excel Users)
If you require Microsoft Excel compatibility but need to clear the legacy 65k row limit and formatting blocks:
- Open the file in Microsoft Excel.
- Click File > Info.
- Locate the Compatibility Mode section and click the Convert button.
- Click OK when prompted to update the file format. Excel upgrades the workbook from the
.xlsbinary format to modern.xlsx. - Save the file and upload the updated version back to Google Drive.
When Should You Keep Files in Compatibility Mode?
Do not convert every file automatically. Retaining an .xlsx file in Office Editing mode is advisable when:
- You are collaborating with external clients or auditors who require a pristine
.xlsxdocument with zero chance of layout shifts. - The workbook contains complex desktop Excel pivot structures, proprietary add-ins, or legacy formatting that could distort if imported into native Google Sheets format.
- To review conversion differences and formatting behavior, consult Fix: “Incompatible file type” for Google Drive Preview and The Complete List of Supported Drive Conversion Formats.