Is Numbers just Apple’s Excel? Why does your colleague’s spreadsheet open with missing charts? Why did that VLOOKUP you pasted from Excel return #NAME? Why does your exported Numbers file show $0.00 instead of $42,850.75 in Excel?
Quick Answer
No—Numbers is not the same as Excel. They share surface-level similarities (rows, columns, basic formulas), but differ fundamentally in calculation engine behavior, formula syntax, file structure, macro support, and interoperability. You can open an Excel file in Numbers—but you’ll likely lose dynamic arrays, XLOOKUP, conditional formatting rules tied to cell references, and pivot table connections.
All the Methods
| Method | Steps | Best For | Limitations |
|---|---|---|---|
| Open Excel file in Numbers | File > Open > Select .xlsx > Click "Keep Original Formatting" | Quick review or light edits on Mac | No XLOOKUP, no dynamic arrays, broken named ranges, lost data validation |
| Export Numbers to Excel | File > Export To > Excel > Choose .xlsx > Check "Preserve formulas" | Sharing with Windows users or Excel-only teams | Dates shift by 4 years (1904 vs 1900 date system), array formulas collapse to static values |
| Use Excel Online with Numbers data | Save Numbers as .csv → Upload to OneDrive → Open in Excel Online | Cross-platform collaboration without native app install | No formulas retained, no formatting, no merged cells, time zones may distort timestamps |
| Rebuild in Excel using Numbers as reference | Copy/paste values only → Recreate formulas manually in Excel | Mission-critical reports, financial models, audit-ready workbooks | Time-intensive, requires formula fluency, no auto-conversion for SUMIFS or FILTER |
Method 1 Deep Dive
Let’s walk through opening an Excel file in Numbers—and what breaks along the way. Say you receive Q3_Sales_Report.xlsx from your finance team. It has:
- A1:A12: Sales rep names (Sarah Chen, Rajiv Patel, etc.)
- B1:B12: Revenue (e.g., $62,140.50 in B5)
- C1:C12: Formula:
=XLOOKUP(A5,$F$2:$F$20,$G$2:$G$20,"Not found") - F2:G20: Lookup table (Region codes and commission rates)
When you open it in Numbers (v14.2), here’s what happens:
- The XLOOKUP returns
#NAME?— Numbers doesn’t recognize it. You’ll need to replace it withVLOOKUPorLOOKUP, both of which require sorted data or exact match tweaks. - Any cell formatted as Accounting ($#,##0.00) reverts to General — so B5 shows
62140.5instead of$62,140.50. You’ll need to reapply formatting manually via Format > Cell > Currency. - Your conditional formatting rule in C1:C12 (highlighting “Not found” in red) disappears entirely — Numbers doesn’t import Excel’s CF rules.
Here’s the fix: In Numbers, select C1:C12 → Format > Add Rule → Text Contains → “Not found” → Fill Red. Then edit each formula: replace XLOOKUP with LOOKUP(A5,$F$2:$F$20,$G$2:$G$20). Note: this only works if F2:F20 is sorted — a detail most people miss until their commission calc is off by 12%. (Trust me, I learned this the hard way after signing off on a $14k overpayment.)
Method 2 Deep Dive
Now let’s export from Numbers to Excel — and watch how dates go sideways. Open Inventory_Tracker.numbers, which contains:
| A1 | B1 | C1 | D1 |
|---|---|---|---|
| Item ID | Description | Last Received | In Stock |
| INV-8821 | Wireless Headset Pro | 2024-03-15 | 42 |
| INV-8822 | USB-C Dock Station | 2024-04-02 | 17 |
| INV-8823 | Mechanical Keyboard (Brown Switch) | 2024-02-28 | 9 |
| INV-8824 | Laptop Sleeve (15") | 2024-05-11 | 33 |
You export it via File > Export To > Excel (.xlsx). Open the result in Excel — and check column C. That “2024-03-15” in C2? Now reads “2020-03-15”. Why? Because Numbers uses the 1904 date system (Mac default), while Excel uses 1900. The difference is exactly 1,462 days — or four years. So every date shifts backward.
The fix isn’t intuitive: In Excel, select C2:C6 → Right-click → Format Cells → Number tab → Date → Choose any format ending in “1904” (e.g., “14/03/2001 1904”). But that’s not enough — now your formulas referencing those dates will break unless you rebuild them. A better move: before exporting, convert dates to text in Numbers using =TEXT(C2,"yyyy-mm-dd"), then paste values only. Yes — it sacrifices date math, but preserves human readability across platforms.
Cheat Sheet
| Task | Numbers Action | Excel Equivalent | Shortcut |
|---|---|---|---|
| Open Excel file | File > Open → Select .xlsx | Double-click .xlsx or File > Open | Numbers: ⌘O | Excel: Ctrl+O (Win) / ⌘O (Mac) |
| Convert XLOOKUP → lookup | Replace with LOOKUP or VLOOKUP + SORT | XLOOKUP works natively | Alt+M+V (Excel: opens Insert Function dialog) |
| Fix date shift on export | =TEXT(C2,"yyyy-mm-dd") → Paste Values | Format Cells > Date > 1904 system | Alt+H+FM (Excel: Format Cells dialog) |
| Apply currency format | Format > Cell > Currency → Set symbol & decimals | Ctrl+Shift+$ | Numbers: ⌘+Shift+1 | Excel: Ctrl+Shift+$ |
| Rebuild SUMIFS logic | Use multiple IF + AND conditions or pivot tables | =SUMIFS(B2:B100,A2:A100,"Acme Corp",C2:C100,">1000") | Alt+M+U+S (Excel: SUMIFS wizard) |
