The first thing most people do when they buy Microsoft 365 Basic is open their Start menu and search for 'Excel'. They click the icon, expect the full desktop app — and get a blank browser tab or an error. That’s because Excel desktop isn’t included. Not even close. And if you’ve already tried opening a file with XLOOKUP, Power Query, or even just conditional formatting across 10,000 rows, you’ve probably hit that wall without knowing why.
Quick Answer
No — Microsoft 365 Basic includes Excel for the web and Excel for mobile (iOS/Android), but not the full Windows or Mac desktop application. You can create, edit, and share spreadsheets in your browser or on your phone, but advanced features like Solver, VBA, PivotTable calculated fields, and even some newer functions (e.g., TOCOL, TEXTSPLIT) are either missing or severely limited.
All the Methods
| Method | Steps | Best For | Limitations |
|---|---|---|---|
| Excel for the web (via OneDrive) | Sign in to office.com → Click Excel → Create new or open from OneDrive | Light editing, collaboration, quick reports | No macros, no add-ins, no data model, max 100k cells per sheet |
| Excel mobile app (iOS/Android) | Download 'Microsoft Excel' from App Store/Play Store → Sign in with M365 Basic account | On-the-go edits, scanning receipts, annotating charts | No ribbon customization, no formula auditing tools, no ability to freeze panes vertically |
| Desktop Excel via 'Try for free' trial | Go to office.com → Click 'Install Office' → Select 'Try free for 1 month' → Enter payment info (cancellable) | Testing compatibility before upgrading | Requires credit card; auto-renews unless cancelled before Day 30 |
| Upgrade to Microsoft 365 Personal or Family | Go to account.microsoft.com/services → Manage subscription → Change plan → Select Personal ($69.99/yr) or Family ($99.99/yr) | Users who need desktop apps regularly | +30% cost increase; no partial upgrades — full plan switch required |
Method 1 Deep Dive
Let’s say you’re Sarah Chen at Acme Corp, tracking Q1 vendor payments in Excel for the web. You upload vendor-payments-Q1-2024.xlsx from your local drive to OneDrive. Open it at office.com, click Excel, then select the file.
You’ll see the familiar interface — but look closely at the Formula bar. Try typing =XLOOKUP(A2,A10:A50,B10:B50,"Not found") in cell C2. It works — great. Now try =TEXTSPLIT(B2,", "). You’ll get #NAME?. Why? Because TEXTSPLIT launched in late 2023 and is only available in desktop Excel (v2310+) and Excel for Microsoft 365 — not Excel for the web under Basic.
What makes this elegant is how seamlessly it handles real-time co-authoring. If your colleague Rajiv adds a comment in cell D5 while you’re editing E8, his comment appears instantly — no refresh needed. But here’s the counterintuitive part: copy-pasting 5,000 rows from a CSV into Excel for the web will succeed, but sorting them by date may silently drop entries after row 4,217. The limit isn’t documented upfront — it’s enforced server-side during sort operations.
Try this test: In A1:A5000, paste dates like 2024-01-15, 2024-02-03, etc. Then select A1:A5000 and press Alt + A + S + S (the Excel for web shortcut for Sort Smallest to Largest). Watch what happens at row ~4217 — values disappear. That’s your ceiling.
Method 2 Deep Dive
Now open the Excel mobile app on your iPhone. Sign in with your Microsoft 365 Basic account. Tap the + New button → choose Blank workbook.
You’ll land in a touch-optimized grid. Let’s build a quick expense tracker. Type “Vendor” in A1, “Amount” in B1, “Date” in C1. Enter these rows:
| A | B | C |
|---|---|---|
| TechNova Ltd | $1,240.00 | 2024-03-15 |
| Global Logistics | $892.50 | 2024-03-18 |
| DataPulse Inc | $3,120.75 | 2024-03-22 |
| Nexus Print Co | $456.30 | 2024-03-25 |
Tap cell B5 → type =SUM(B2:B4). It calculates correctly: $5,709.55. But now tap the ... menu → Format Cells → try changing number format to Accounting. It fails silently — no error, no change. Mobile Excel formats only support Currency and General. No Accounting, no Custom, no scientific notation.
The beauty of this approach is offline capability: download the file once, and you can enter new rows or update amounts without Wi-Fi. But don’t assume autosave means safety — changes made offline sync only when you reopen the app *and* have connectivity. Miss that window? Your last 3 edits vanish.
Cheat Sheet
| Task | Excel for Web (Basic) | Excel Mobile (Basic) | Desktop Excel (Not Included) |
|---|---|---|---|
| Open existing .xlsx | ✓ Yes (OneDrive required) | ✓ Yes (OneDrive or local) | ✗ Not installed — requires upgrade |
| Use XLOOKUP / FILTER | ✓ Yes (full syntax) | ✓ Yes | ✓ Yes |
| Run VBA macros | ✗ No | ✗ No | ✓ Yes |
| Freeze panes | ✓ Horizontal only | ✗ Not supported | ✓ Both directions |
| Keyboard shortcut: Sort | Alt+A+S+S | None — use touch menu | Alt+A+S+S |
| Max rows in sort operation | 4,217 | Unlimited (but slow >10k) | 1,048,576 |
