What Most People Miss About Apple Numbers and Excel Compatibility
By Lisa Anderson
Yes, Apple Numbers files can open in Excel — but only if you export them first. But the moment you double-click a .numbers file on Windows, you’ll get an error, not a spreadsheet.
The Setup
You’re helping Sarah Chen at Acme Corp migrate her Q1 sales tracker from her MacBook to the finance team’s shared Excel workbook. She built it in Numbers, and now needs to merge it with their master file — which lives in Excel on a Windows server. No cloud sync. No IT support this week. Just you, her laptop, and a deadline.
Here’s what her Numbers sheet looks like (exported as CSV for reference — but *not* yet opened in Excel):
Rep Name
Region
Q1 Sales
Close Date
Status
Sarah Chen
APAC
$45,200
2024-03-15
Won
Diego Morales
LATAM
$31,850
2024-03-12
Won
Priya Kapoor
EMEA
$67,900
2024-03-18
Pending Review
James Wu
APAC
$22,100
2024-03-05
Lost
Amina Diallo
EMEA
$53,400
2024-03-20
Won
Rajiv Mehta
APAC
$18,650
2024-03-10
Pending Review
Lena Schmidt
EMEA
$41,200
2024-03-14
Won
Takumi Sato
APAC
$29,750
2024-03-08
Lost
The Challenge
You need to get that data into Excel — not just open it, but preserve numbers, dates, and structure so it matches the finance team’s template (which expects dates in MM/DD/YYYY, currency in $#,##0.00, and status values limited to 'Won', 'Lost', or 'Pending'.)
The trap? Dragging a .numbers file straight into Excel fails silently. You’ll see blank cells, scrambled dates like "45372", and currency turned into plain text. Why? Because Numbers uses its own binary format (.numbers), and Excel doesn’t read it natively — unlike .xlsx or even .csv.
Also: Numbers formulas like =SUMIFS(Region, "APAC", Q1 Sales) won’t survive export. And merged cells? They become blank rows in Excel unless handled manually.
Walking Through It
Step 1: In Numbers, go to File → Export To → Excel…. Don’t pick CSV. CSV loses formatting, date types, and column widths. Pick .xlsx — even if you’re on macOS.
Step 2: In the export dialog, check “Use Excel-compatible formulas”. This converts Numbers-specific functions (like LOOKUP with array syntax) into Excel equivalents. Uncheck “Preserve number formatting” — it lies. Instead, reapply formatting in Excel.
Step 3: Save the file. Now open it in Excel. You’ll likely see dates as serial numbers (e.g., 45372 instead of 3/15/2024) in column D. That’s because Numbers exports dates as Excel serials — but doesn’t flag the column as Date type.
So select D2:D9 → press Ctrl+1 (or Cmd+1 on Mac Excel) → choose Date → Type: 3/14/2012 → OK.
Before:
Rep Name
Close Date
Sarah Chen
45372
Diego Morales
45369
After formatting:
Rep Name
Close Date
Sarah Chen
3/15/2024
Diego Morales
3/12/2024
Step 4: Fix currency. Select C2:C9 → Ctrl+Shift+4 (the keyboard shortcut for Currency format). Then right-click → Format Cells → Number → Currency → Decimal places: 2.
Step 5: Clean statuses. Finance only accepts 'Won', 'Lost', 'Pending'. But Numbers exported 'Pending Review' — which will break their pivot table filters. So use =SUBSTITUTE(C2,"Pending Review","Pending") in a new column, then paste values over the original.
The Result
Here’s how the final Excel-ready version looks — matching the finance team’s exact expectations:
Rep Name
Region
Q1 Sales
Close Date
Status
Sarah Chen
APAC
$45,200.00
3/15/2024
Won
Diego Morales
LATAM
$31,850.00
3/12/2024
Won
Priya Kapoor
EMEA
$67,900.00
3/18/2024
Pending
James Wu
APAC
$22,100.00
3/5/2024
Lost
Amina Diallo
EMEA
$53,400.00
3/20/2024
Won
Rajiv Mehta
APAC
$18,650.00
3/10/2024
Pending
Lena Schmidt
EMEA
$41,200.00
3/14/2024
Won
Takumi Sato
APAC
$29,750.00
3/8/2024
Lost
What Could Go Wrong
Mistake #1: Using ‘Save As’ instead of ‘Export To’ in Numbers
Numbers has both options — but ‘Save As’ saves a .numbers file, even if you name it .xlsx. Excel sees it as corrupted binary. You’ll get “file format not supported” — no warning, no recovery.
Mistake #2: Skipping the ‘Use Excel-compatible formulas’ checkbox
Without it, a formula like =COUNTIF(Region::"APAC") becomes =#REF! in Excel. You won’t notice until your totals vanish — and debugging requires comparing cell by cell across two apps.
Mistake #3: Assuming merged cells survive intact
If Sarah merged A1:B1 for a title in Numbers, Excel imports it as two cells — with content only in A1 and B1 blank. The rest of the row shifts left. You’ll spot it when column headers don’t align with data (e.g., ‘Region’ appears under ‘Q1 Sales’).
Here’s your quick-reference cheat sheet before sending anything to the finance team:
Action
Where
Shortcut / Tip
Export to Excel
Numbers → File → Export To → Excel…
✅ Always check “Use Excel-compatible formulas”
Fix serial dates
Excel → Select column → Format Cells
Ctrl+1 → Date → Choose “3/14/2012”
Apply currency
Excel → Select values
Ctrl+Shift+4 (fastest way — beats ribbon clicking)
