Does Google Docs open Excel files? Does it run Excel formulas? Does it let you use VLOOKUP or pivot tables? No, no, and no — but the confusion is understandable.
Quick Answer
Google Docs itself does not have Excel functionality. Docs is a word processor. What people actually mean is Google Sheets — Google’s free, web-based spreadsheet app. It’s not Excel, but it reads, edits, and saves .xlsx files, supports many (but not all) Excel functions, and syncs with Drive. If you opened an Excel file in Docs by mistake, you got a PDF-like preview — not a live sheet.
All the Methods
| Method | Steps | Best For | Limitations |
|---|---|---|---|
| Upload .xlsx to Drive → Open in Sheets | Upload file to Google Drive → Right-click → “Open with” → Google Sheets | One-time editing of Excel files without installing Excel | Macros, Power Query, and 12+ Excel-specific functions (e.g., TEXTJOIN in older Sheets versions) won’t work |
| Copy-paste from Excel into Sheets | Select range in Excel (e.g., A1:D10) → Ctrl+C → Click cell in Sheets → Ctrl+V | Moving small datasets or formatted headers | Conditional formatting, merged cells, and custom number formats often break |
| Export Sheets as .xlsx | File → Download → Microsoft Excel (.xlsx) | Sharing with Excel-only users or submitting to systems that require native .xlsx | Array formulas using @ notation convert to static values; dynamic arrays don’t survive export |
| Use Sheets Add-ons like Power Tools | Extensions → Add-ons → Get add-ons → Install Power Tools → Run “Convert Formulas” | Translating complex Excel logic (e.g., INDEX-MATCH + DATEVALUE combos) | Add-ons require permissions; some functions (e.g., INDIRECT with external refs) still fail |
| Link Excel to Sheets via CSV pipeline | Save Excel as CSV → Upload to Drive → Open in Sheets → Data → Import range | Teams updating master lists weekly (e.g., inventory, contacts) | No formulas, no formatting, no dates past 1900–2100 unless manually parsed |
Method 1 Deep Dive
Upload your Excel file to Drive, then open it directly in Sheets. This is the fastest path for most users — but it’s also where surprises happen.
Try it with this sample file: Q3_Sales_Report.xlsx. It contains 7 columns (A1:G1 = Region, Rep, Product, Units, Price, Date, Revenue) and 9 rows of data. Sarah Chen sold 12 units of ‘CloudSync Pro’ on 2024-08-22 at $299 each — that’s $3,588 in G2.
When uploaded and opened in Sheets, G2 shows =D2*E2 — correct. But if column E (Price) was formatted as Accounting in Excel, Sheets renders it as plain number: 299.00 instead of $299.00. You’ll need to reapply formatting: select E2:E10 → Format → Number → Currency → USD.
Here’s the counterintuitive part: Excel’s XLOOKUP won’t convert to Sheets’ XLOOKUP automatically. Sheets only added XLOOKUP in late 2023 — and only for accounts with Google Workspace Enterprise Plus. If you see #NAME? in F5 after upload, replace =XLOOKUP(A5,A2:A10,H2:H10) with =INDEX(H2:H10,MATCH(A5,A2:A10,0)). That works everywhere.
Pro tip: Use Alt+Shift+1 to toggle the Sheets formula bar on/off — helps spot broken references faster.
Method 2 Deep Dive
Copy-paste is risky — but when done right, it’s faster than uploading. Especially for one-off reports.
Open Excel. Select A1:G10 from the same Q3_Sales_Report. Press Ctrl+C. Switch to Sheets. Click cell A1. Press Ctrl+V.
You’ll get raw values — no formulas. But here’s what most miss: if you press Ctrl+Alt+V (Paste Special) instead of Ctrl+V, Sheets gives you options. Choose “Paste values only” or “Paste format only”. There’s no “Paste formulas” option — because Sheets can’t interpret Excel’s formula syntax mid-paste.
So do this instead: In Excel, select the formula cells (e.g., G2:G10). Press F2 to edit, then Ctrl+C to copy the formula text (not result). In Sheets, click G2 → type = → paste → Enter. Repeat for each formula column.
Sample result after clean paste:
| Region | Rep | Product | Units | Price | Date | Revenue |
|---|---|---|---|---|---|---|
| North | Sarah Chen | CloudSync Pro | 12 | 299 | 2024-08-22 | 3588 |
| South | Diego Ruiz | DataVault Mini | 8 | 149 | 2024-08-23 | 1192 |
| East | Maya Patel | CloudSync Pro | 15 | 299 | 2024-08-24 | 4485 |
| West | James Wu | DataVault Mini | 22 | 149 | 2024-08-25 | 3278 |
| North | Sarah Chen | DataVault Mini | 5 | 149 | 2024-08-26 | 745 |
Note: Date column (F2:F6) imported as text. Fix with =DATEVALUE(F2) in H2, then drag down. Then format H2:H6 as Date.
Cheat Sheet
| Task | What to Do | Shortcut |
|---|---|---|
| Open Excel file in Sheets | Upload to Drive → Right-click → Open with → Google Sheets | — |
| Paste without formatting | Ctrl+Alt+V → “Values only” | Ctrl+Alt+V |
| Toggle formula bar | Show/hide top formula input line | Alt+Shift+1 |
| Convert text dates to real dates | In blank column: =DATEVALUE(A2), then drag down → Copy → Paste as values → Format as Date | Ctrl+Shift+V (paste values) |
| Find Excel function equivalents | Use Sheets’ Function Explorer (fx icon) or search “Excel [function] Sheets equivalent” in Help | Alt+Shift+F |
| Export final version as .xlsx | File → Download → Microsoft Excel (.xlsx) | — |
