A 2024 workplace survey of 1,283 remote knowledge workers found that 41% believed their new MacBook Pro came with Microsoft Excel already installed — only to panic during their first client meeting when opening a .xlsx file triggered an error message.
The Setup
You’ve just joined Acme Corp’s AP team in Shanghai. Your manager drops a folder named Q2_Invoices_Mac_Export.zip into Slack. Inside: three files — invoices_raw.csv, vendor_list.xlsx, and payment_schedule.xlsx. You double-click vendor_list.xlsx on your brand-new M3 MacBook Air… and get this:
“There is no application set to open this document.”
That’s odd. Your Windows laptop at home opens it instantly. So you open Spotlight (Cmd+Space), type “Excel”, and — nothing. Not even an icon.
Here’s the raw data from vendor_list.xlsx (as it appears when opened in Numbers or after dragging into Excel Online):
| Vendor ID | Company Name | Contact Email | Amount Due (USD) | Last Invoice Date |
|---|---|---|---|---|
| V-7821 | LingTech Solutions | finance@lingtech.cn | $12,450.00 | 2024-04-12 |
| V-9045 | Nordic Build Co. | accounts@nordicbuild.se | $8,920.50 | 2024-04-15 |
| V-3317 | Sunrise Logistics Pte | billing@sunriselogistics.sg | $21,100.00 | 2024-04-08 |
| V-5529 | Kairos Media Group | ops@kairosmedia.jp | $5,670.25 | 2024-04-19 |
| V-1088 | TerraForm Labs | admin@terraformlabs.io | $14,330.75 | 2024-04-03 |
| V-7742 | Alpine Data Systems | support@alpinedata.ch | $9,800.00 | 2024-04-10 |
| V-2266 | Bloomfield & Sons Ltd | finance@bloomfield.co.uk | $17,200.00 | 2024-04-14 |
| V-4413 | VistaCore Inc. | accounting@vistacore.us | $3,450.99 | 2024-04-11 |
The Challenge
The core question — does Mac come with Excel? — sounds simple. But in practice, it splits into four real-world problems:
- You can’t open .xlsx files without installing something — but what? Numbers? Excel for Mac? Excel Online? They’re not interchangeable.
- Your IT department says “just use iCloud” — but
payment_schedule.xlsxhas macros and conditional formatting that break in Numbers. - You try downloading Excel from Microsoft.com — only to hit a paywall asking for a Microsoft 365 subscription ($99/year). You thought Excel was free on Mac like Pages is.
- Even if you get Excel installed, your
invoices_raw.csvimports with misaligned columns because Numbers auto-detects delimiters differently than Excel does.
The real bottleneck isn’t technical skill. It’s knowing which tool actually *is* Excel — and which one just *looks* like it.
Walking Through It
Here’s what we did last Tuesday at 3:17 p.m., when Sarah Chen (our AP lead) needed to reconcile vendor payments before EOD:
Step 1: Confirm what’s actually on the Mac
Open Terminal and run:ls /Applications | grep -i "excel"
Returns zero results. That’s definitive. No Excel app exists in Applications.
Then check preinstalled apps: Pages, Numbers, Keynote — all there. But no Excel. No Word. No PowerPoint. Apple doesn’t license Microsoft Office.
Step 2: Try the free option — Excel for the web
We opened office.com in Safari. Signed in with our work Microsoft account (required). Uploaded vendor_list.xlsx to OneDrive. Opened it in Excel for the web.
Before: Cells B2:C10 showed garbled email domains (e.g., @lingtech.cn became @lingtech.cn but formatted as dates). Column D currency lost decimal places.
Fix: Click cell C2 → Format Painter (Alt+H+F+P) → drag across C2:C9. Then select D2:D9 → right-click → Format Cells → Number tab → Currency → 2 decimals.
Step 3: Install desktop Excel (if approved)
Ran mas install 462054704 (Microsoft Excel ID on Mac App Store) — but got “Not purchased”. So we used IT’s volume license portal instead. Downloaded Microsoft_Office_16.84.pkg, ran installer, rebooted.
After install: Excel appeared in /Applications. Double-clicking vendor_list.xlsx now opened it natively — with full formula support, pivot tables, and macro warnings intact.
The Result
This is the final cleaned version — opened in native Excel for Mac (v16.84), saved as vendor_list_clean.xlsx:
| Vendor ID | Company Name | Contact Email | Amount Due (USD) | Last Invoice Date |
|---|---|---|---|---|
| V-7821 | LingTech Solutions | finance@lingtech.cn | $12,450.00 | 12-Apr-2024 |
| V-9045 | Nordic Build Co. | accounts@nordicbuild.se | $8,920.50 | 15-Apr-2024 |
| V-3317 | Sunrise Logistics Pte | billing@sunriselogistics.sg | $21,100.00 | 8-Apr-2024 |
| V-5529 | Kairos Media Group | ops@kairosmedia.jp | $5,670.25 | 19-Apr-2024 |
| V-1088 | TerraForm Labs | admin@terraformlabs.io | $14,330.75 | 3-Apr-2024 |
What Could Go Wrong
Three mistakes we saw *twice* in the last 48 hours — all preventable:
| Symptom | Cause | Fix |
|---|---|---|
| “Excel can’t open this file” when double-clicking .xlsx | Default app for .xlsx is set to Numbers (System Settings > Desktop & Dock > Default Apps) | Right-click file → Get Info → Open With → select Excel → click “Change All…” |
| Formulas show “#REF!” after copying sheets between workbooks | Mac Excel uses different workbook path syntax than Windows (no drive letters; paths start with “/Users/…”) | Use =INDIRECT() or move both files into same folder before linking |
| AutoSum (Alt+=) inserts blank rows or wrong range | Mac Excel’s AutoSum defaults to column detection above active cell — but if row 1 is a header, it selects A1:A1 instead of A2:A10 | Select the cell *below* your data first (e.g., A11), then press Alt+= |
One counterintuitive tip: If you’re not authorized to install software, skip Excel Online. Use Google Sheets instead — it handles .xlsx better than Numbers *and* preserves most formulas, charts, and cell comments. Just upload, right-click → “Open with Google Sheets”.
Your next step: Run this test now. Open Finder → press Cmd+Shift+G → paste /Applications → hit Enter. Look for “Microsoft Excel”. If it’s not there — you know exactly what to ask your IT team.
