The first thing most people do when they open sheets.google.com is type =VLOOKUP() — then stare at #N/A for 12 minutes. That’s not a bug. It’s because they’re treating Google Sheets like Excel, assuming the names are interchangeable. They’re not.
The Problem
You copy an Excel file named Sales_Q3_2024.xlsx into Google Drive, double-click it, and expect everything to work. It doesn’t. Formulas break. Conditional formatting vanishes. Pivot tables won’t refresh. And nobody tells you why — because the product isn’t called 'Google Excel' at all.
| File Name | Original Tool | What Happens in Sheets | Cell Reference |
|---|---|---|---|
| Sales_Q3_2024.xlsx | Microsoft Excel (Desktop) | =TEXTJOIN(", ",TRUE,A2:A5) returns #NAME? | B2 |
| Inventory_Report_v2.xlsx | Excel Online | =FILTER(A2:C100,B2:B100>1000) shows #ERROR! — FILTER doesn’t exist in older Excel versions, but Sheets has it built-in | D2 |
| HR_Budget_Template.xlsx | Excel for Mac (v16.82) | Conditional formatting rules using =ISBLANK($C2) stop applying after row 27 — Sheets applies them differently | C2:C100 |
| Vendor_Payments.xlsx | Excel (Windows, Office LTSC) | =XLOOKUP() returns #NAME? — Sheets uses =XLOOKUP() but only if you're on the latest version; older Sheets instances use =VLOOKUP() or =INDEX(MATCH()) | E5 |
| Forecast_Model.xlsx | Excel with Power Query | All Power Query steps disappear — Sheets has no native Power Query equivalent | Sheet2!A1 |
The Solution
Step 1: Stop saying 'Google Excel.' Say 'Google Sheets.' Every time. Out loud. It’s not branding pedantry — it’s precision. Misnaming it trains your brain to expect Excel behavior.
Step 2: When opening an .xlsx file in Sheets, don’t just click through. Use File > Open > Upload, then immediately run this check:
- Check formula compatibility: Press
Ctrl+H(orCmd+Hon Mac), search for=XLOOKUP(,=TEXTJOIN(,=FILTER(. If found, verify Sheets supports them in your org’s domain (some enterprise deployments disable newer functions). - Validate cell references: In Sheet1, select A1:E100 → press
Ctrl+`(backtick) to toggle formula view. Look for absolute references like$B$2— these behave the same. But watch forB2#(Excel dynamic arrays). Sheets ignores the#— it’ll return only the first value.
Step 3: Replace incompatible formulas manually — don’t rely on auto-conversion. For example:
- Excel’s
=TEXTJOIN(", ",TRUE,A2:A5)→ Sheets uses the exact same syntax. ✅ Works. - Excel’s
=IFS(A2>100,"High",A2>50,"Medium","Low")→ Same in Sheets. ✅ - Excel’s
=UNIQUE(A2:A100)→ Also identical. ✅ - But Excel’s
=LET(x,A2:A100,y,SUM(x),y)→ Sheets doesn’t support LET. Replace with helper column or ARRAYFORMULA.
| Step | Action | Result | Shortcut |
|---|---|---|---|
| 1 | Open Sheets, go to File > Import > Upload (.xlsx) | File appears as new tab, NOT renamed to .gsheet | None |
| 2 | Press Ctrl+Shift+F to open Find & Replace, enter =XLOOKUP |
Highlights all XLOOKUP instances — confirm they resolve (no #NAME?) | Ctrl+Shift+F |
| 3 | Select B2:B20 → type =ARRAYFORMULA(IF(A2:A20="Acme Corp",C2:C20*1.05,"")) |
Applies markup to Acme rows only — no drag-fill needed | Enter |
| 4 | Click Data > Protected sheets and ranges → lock D2:D20 | Prevents accidental overwrite of calculated revenue column | Alt+D, P |
Going Further
Google Sheets has features Excel lacks — and vice versa. Know which to reach for:
- IMPORTRANGE() pulls live data from other Sheets files — no Excel equivalent without Power Query + SharePoint.
- GOOGLEFINANCE("GOOGL") pulls stock prices — Excel needs Data Types or add-ins.
- QUERY() lets you write SQL-like statements:
=QUERY(A1:C100,"SELECT A, SUM(C) WHERE B CONTAINS 'Q3' GROUP BY A"). Excel requires PivotTables or Power Pivot. - Sheets’
REGEXEXTRACT()handles pattern matching Excel can’t do natively — e.g.,=REGEXEXTRACT(A2,"[A-Z]{2}\d{4}")pulls “AB1234” from “Order AB1234 shipped.”
Surprising tip: Sheets recalculates every cell on every edit — even if unrelated. Excel uses dependency trees. So if your sheet has 50,000 rows with volatile functions like NOW(), INDIRECT(), or IMPORT*, performance tanks fast. Fix: Replace =NOW() with a static timestamp (Ctrl+; + Ctrl+Shift+;) unless you truly need live time.
When NOT to Use This
Don’t convert Excel files to Sheets if:
- Your workbook uses VBA macros — Sheets has Apps Script, but it’s JavaScript-based and not drop-in compatible.
- You rely on Excel-specific features: Slicers, Timeline filters, Power View, or advanced Solver models.
- Your data exceeds 10 million cells (Sheets’ hard limit) — a single Excel file can hold more, though it’ll crawl.
- You’re collaborating with finance teams using Excel’s auditing tools (Trace Precedents, Evaluate Formula) — Sheets has no equivalent visual tracer.
If your audit trail requires signed Excel workbooks with digital signatures, Sheets can’t replicate that. Period.
Keyboard Shortcuts
| Action | Windows Shortcut | Mac Shortcut | Notes |
|---|---|---|---|
| Toggle formula view | Ctrl + ` | Cmd + ` | See actual formulas instead of results |
| Open Find & Replace | Ctrl + H | Cmd + H | Essential for spotting Excel-only functions |
| Insert current date | Ctrl + ; | Cmd + ; | Static — unlike =TODAY() |
| Open protected ranges | Alt + D, P | Option + D, P | Faster than menu navigation |
| Edit cell with full formula bar | F2 | Ctrl + U | Critical for long ARRAYFORMULA edits |
