The first thing most people do when switching from Excel to Google Sheets is copy-paste their workbook and expect everything to just run. That’s usually the wrong move — especially if your file uses array formulas, custom number formats, or conditional formatting with relative references. I watched a finance team at Acme Corp waste two mornings debugging why their dashboard showed #REF! errors after sharing an Excel file as Sheets. The root cause? They assumed Sheets was Excel with a blue logo.
Quick Answer
No — Google Sheets does not work like Excel in critical ways: formula syntax differs (especially for ARRAYFORMULA, INDIRECT, and FILTER), cell referencing behavior changes across tabs, date handling is less forgiving, and keyboard shortcuts (like Alt+= for AutoSum) simply don’t exist. But the good news? Most daily tasks—sorting, basic formulas, charts—work nearly identically. It’s the edge cases that bite.
All the Methods
| Method | Steps | Best For | Limitations |
|---|---|---|---|
| Copy-Paste Excel → Sheets | Open Excel file > Ctrl+C > Paste into blank Sheets tab | Quick one-off data transfers (e.g., weekly sales list) | Breaks named ranges, dynamic arrays, pivot cache, and XLOOKUP with arrays |
| Import via File > Import | File > Import > Upload .xlsx > Choose "Replace spreadsheet" or "Insert new sheet" | Preserving basic formatting, merged cells, and sheet structure | Drops VBA, macros, and complex conditional formatting rules |
| Rebuild natively in Sheets | Use Sheets equivalents: FILTER instead of dynamic arrays, QUERY instead of complex nested IFs, IMPORTRANGE for cross-spreadsheet links | Teams relying on real-time editing, version history, or add-ons like DocuSign | Requires relearning some logic; no native equivalent for GETPIVOTDATA or Power Query |
| Excel Online + Sheets Sync | Save Excel file to OneDrive > Share link > Open in browser > Use Sheets Add-on "Excel to Sheets Converter" (by Sheetgo) | Hybrid teams using both tools (e.g., finance uses Excel desktop, marketing uses Sheets) | Adds latency; sync fails on files > 10MB or with password protection |
Method 1 Deep Dive
Let’s say you have this Excel table in A1:D7:
| Name | Dept | Salary | Hire Date |
|---|---|---|---|
| Sarah Chen | Marketing | $72,500 | 2022-04-11 |
| James Ruiz | Engineering | $118,200 | 2021-09-03 |
| Aisha Patel | HR | $64,900 | 2023-01-18 |
| Diego Torres | Finance | $89,600 | 2020-11-30 |
| Maya Johnson | Marketing | $68,300 | 2022-08-07 |
In Excel, you’d type =XLOOKUP("Marketing",B2:B6,A2:A6) in F2 to pull Sarah’s name. Paste that exact formula into Sheets? It returns #NAME?. Why? Because Sheets doesn’t support XLOOKUP — use =FILTER(A2:A6,B2:B6="Marketing") instead. And yes, that spills automatically (no Ctrl+Shift+Enter needed). Bonus tip: Sheets treats dates as serial numbers starting from December 30, 1899 — same as Excel — so =TODAY()-A2 works fine. But if your Excel file used custom date formats like "dd-mmm-yyyy", Sheets may convert them to plain text. Fix: Select column D > Format > Number > Date.
Method 2 Deep Dive
Here’s where things get weird: conditional formatting. In Excel, if you apply “Highlight cells greater than $80,000” to B2:B6, and then insert a row at B4, Excel auto-shifts the rule to cover B2:B7. Sheets? It doesn’t. The rule stays locked on B2:B6 — and new rows won’t be formatted unless you manually extend it. The fix isn’t intuitive: click the paint roller icon > Edit rules > Change “Apply to range” from B2:B6 to B2:B100. Even better: use a formula-based rule like =B2>80000 applied to B2:B100. That way, new rows inherit the logic. Also — and this trips up everyone — Sheets’ INDIRECT() can’t reference closed workbooks. So if your Excel file had =INDIRECT("[Budget2024.xlsx]Q1!C5"), it breaks completely. Replace it with =IMPORTRANGE("https://docs.google.com/spreadsheets/d/abcd123...", "Q1!C5"), but only after granting permission.
Keyboard shortcut note: In Excel, Alt+= auto-sums above. In Sheets? There’s no Alt+=. Instead, press Ctrl+Shift+T to open the Explore panel, then type “sum B2:B6” — Sheets will generate the formula and insert it. Not muscle memory yet, but faster than typing it out.
Cheat Sheet
| Task | Excel Shortcut / Formula | Sheets Equivalent | Notes |
|---|---|---|---|
| AutoSum | Alt += | Ctrl+Shift+T → type “sum” | No native keyboard shortcut exists |
| Dynamic Array Spill | =SORT(UNIQUE(A2:A10)) | =SORT(UNIQUE(A2:A10)) | Works identically — no ARRAYFORMULA wrapper needed |
| Cross-Sheet Lookup | =VLOOKUP(A2,'Q1 Data'!A:D,4,FALSE) | =VLOOKUP(A2,'Q1 Data'!A:D,4,FALSE) | Same syntax — but sheet names with spaces need single quotes |
| Today’s Date + 30 Days | =TODAY()+30 | =TODAY()+30 | Identical — but ensure cell format is set to Date |
| Filter & Show Top 3 | Data > Filter > Dropdown > Top 10 > change to 3 | Data > Create a filter > Click dropdown > Sort by Salary Z→A > Hide rows 4–6 | Sheets has no built-in “Top N” filter — sort + hide is fastest workaround |
