Apple Numbers vs Microsoft Excel

The short answer: Numbers is a layout tool that can calculate. Excel is a calculation tool that can lay things out. Almost every difference below follows from that one distinction, and it is usually enough to decide.

Choose Numbers if your spreadsheets are read by people — invoices, budgets, one-page reports, anything you would be happy to print. Choose Excel if your spreadsheets are read by other spreadsheets — models, pivot analysis, anything that will be handed to a colleague on Windows.

The difference that actually matters: canvas versus grid

Most comparisons start with feature counts. Start here instead, because it is the difference you will feel within ten minutes.

Excel gives you one grid per sheet. The grid is the document. Every cell has an address, everything lines up with everything else, and a formula anywhere can reach anything.

Numbers gives you a blank canvas. Tables are objects you place on it, like images or text boxes, and you can put several independent tables on one sheet, each with its own headers and its own size. A quarterly summary and its three supporting tables can sit side by side without a single merged cell.

This is why Numbers documents look better with no effort, and why they become awkward as models grow. Once you have twelve tables scattered across four canvases, “where does this number come from?” is a harder question than it would be in a single grid.

Where Numbers genuinely wins

• It is free, on every Mac, iPad, and iPhone, with no subscription and no upsell. Nothing below changes that.
• Documents look finished by default. The templates are genuinely good, and typography, spacing, and chart styling are handled for you.
• Multiple tables per sheet, which for invoices and reports is the correct model and something Excel simulates badly with merged cells.
• It is pleasant on iPad and iPhone. Numbers was designed for touch, not adapted to it. If you edit on an iPad, this is not a small thing.
• Charts look better out of the box. Excel’s are more configurable; Numbers’ need less work to be presentable.

Where Excel genuinely wins

• Function library. Excel has roughly 400–500 built-in functions depending on version; Numbers has around 250. For most people the gap never comes up — until it does, and then it is a wall.
• Pivot tables. Numbers has had them since version 12.1 in 2022, so the common claim that it lacks them is out of date — but Excel’s are substantially more capable, and the gap widens fast with calculated fields and slicers.
• Power Query, Power Pivot, and Solver. Numbers has no equivalent to any of them. If you clean and merge data from several sources regularly, this alone decides it.
• Macros. Excel has Visual Basic for Applications (VBA). Numbers has AppleScript and Shortcuts on Mac, which are useful but are not the same thing and cannot travel inside a file.
• Editing chart data ranges. In Excel a chart’s source range is a value you can edit directly. In Numbers you adjust it by dragging the highlighted region on the table — fine for a small chart, tedious when a range grows every month, and a long-standing complaint with no clean workaround.
• It runs everywhere. Windows, Mac, web, iPad, Android. Numbers runs on Apple hardware and at iCloud.com in a browser.
• It is what everyone else uses. Which brings us to the real problem.

Large data sets, advanced functions, and complex calculations

This is the widest gap between the two, and the one most comparisons skip. Excel’s calculation and data analysis capabilities are simply deeper, and the distance shows up the moment a job stops being arithmetic and starts being analysis.

Grid size. An Excel worksheet holds 1,048,576 rows by 16,384 columns. That ceiling is high enough that most people never meet it. Numbers does not publish a comparable figure prominently, and its practical limit arrives long before any documented one does — tables slow down while they are still well inside what Excel treats as routine. If your working files run to hundreds of thousands of rows, this decision is already made for you.

Data import and transformations. Excel has Power Query, which connects to CSV and JSON files, web pages, SQL databases, and other workbooks, then records your cleaning steps — split columns, change types, remove duplicates, unpivot — as a script that re-runs whenever the source updates. It is the single most valuable thing in Excel that most people have never opened. It is most complete on Windows; the Mac build has historically lagged, so check your version before relying on it. Numbers has no equivalent at all. Importing means opening a file.

Dataset relationships. Excel’s data model (Power Pivot) lets you relate several tables by a key and pivot across them without flattening everything into one sheet first — the spreadsheet equivalent of a join. It is Windows-only. Numbers has nothing comparable; related data has to be merged by hand or with lookups.

Scenario modeling. Excel ships Goal Seek, Scenario Manager, one- and two-variable Data Tables, and Solver for constrained optimisation. If you need to ask “what discount rate makes this NPV zero” or “what mix maximises margin under these limits,” Excel answers directly. Numbers has none of these, and the workaround is manual iteration.

Volatile functions. Both have them: NOW, TODAY, RAND, RANDBETWEEN, OFFSET, and INDIRECT recalculate on every single edit anywhere in the file, not just when their own inputs change. A few are harmless. A column of them in a large model is the most common reason a spreadsheet becomes slow to type in, and the most common thing people misdiagnose as “the app is bad.” If a file has become sluggish in either program, search for those six names first.

Data manipulation options. Beyond Power Query, Excel offers Flash Fill, Text to Columns, Remove Duplicates, and structured tables with calculated columns. Numbers has sorting, filtering, and categories — its one genuinely elegant idea here, grouping rows by a column’s values with automatic subtotals, and pleasant to use for exactly the size of job it suits.

Functions and formulas. Excel has roughly 450–500 advanced functions depending on version; Numbers around 250. The count matters less than the shape of what’s missing — Numbers covers everyday statistics, text, and date work perfectly well, and thins out precisely where complex analyses live: financial, engineering, and database-style functions. Dynamic arrays, which let one formula spill results across a range, are also an Excel feature with no Numbers equivalent.

Charts, conditional formatting, and dashboards

Both cover the standard set well — a column chart, a line chart, a pie chart, bar, scatter, and area are a click away in either. For a chart that goes in a report, Numbers usually produces a better-looking result with less fiddling, and its interactive graphs — where a slider steps through periods — are genuinely nice and have no direct Excel equivalent.

Excel wins on breadth and on anything analytical. Waterfall, treemap, sunburst, radar and doughnut charts, box plot, histogram, 3D charts including surface plots, and in-cell sparklines are all built in, and its Quick Analysis tool proposes suitable plotting and charting features for whatever range you have selected. More importantly, PivotCharts and slicers let a chart be driven by a pivot table, which is what “dashboard” actually means in practice: several visuals responding to one set of filters. Excel also ships ready-made dashboard and report templates built on that machinery. Numbers has no pivot-driven charting and no slicers, so a Numbers dashboard is a static layout that someone updates by hand.

Both offer conditional formatting. Excel’s is deeper — colour scales, data bars, icon sets, and formula-driven rules across a range. Numbers keeps it to straightforward conditional highlighting, which covers “turn it red if it’s negative” and stops well short of Excel’s rule engine.

Interface, learning curve, and speed

Excel’s ribbon interface puts a great deal on screen, and its ribbons group every command into labelled tabs. It is genuinely discoverable — almost everything is visible somewhere — and genuinely overwhelming for the first month. Its compensation is that the layout has barely moved in fifteen years, and its keyboard shortcuts are close to an industry standard: the muscle memory transfers between jobs, versions, and to a large extent to other spreadsheets.

Numbers uses a contextual inspector on the right that shows options for whatever you have selected. Far less on screen, far less to learn, and a much gentler first hour. Tab navigation along the bottom edge works much the same in both, so moving between sheets is one habit that transfers intact. The cost of the simpler interface appears later: when you want something specific, you have to know which selection reveals it, and the answer is not always guessable.

Templates. Both ship a template library. Numbers’ are better designed and aimed at documents — invoices, budgets, event planners. Excel’s are more numerous and aimed at tasks.

Speed is where the experience diverges most. Excel stays responsive well into six-figure row counts. Numbers is smooth for typical documents and turns into a laggy interface with large tables — scrolling, sorting, and typing all suffer before you reach anything Excel would consider large. If you have felt a spreadsheet stutter and concluded that spreadsheets are simply slow, it is worth knowing that this is a real and reproducible difference, not an impression.

How each one fits with your other tools

Excel sits inside Microsoft 365. The other Microsoft 365 applications are where its advantage compounds: data moves cleanly into Word and PowerPoint, files live in OneDrive or SharePoint, Teams handles sharing options, and Power Automate can trigger workflows when a file changes. Its AI capabilities arrive through the Copilot add-on, paid separately, which answers questions about a sheet in plain language. It also speaks ODBC, so it can query SQL databases directly, and it can import and export data in almost every format an office is likely to produce.

Numbers sits inside the Apple ecosystem. It shares a design language and a clipboard with Pages and Keynote, syncs through iCloud across Mac, iPad, and iPhone, opens from the Files app, and can be driven by Shortcuts and AppleScript on the Mac. It has no AI assistant, no add-in store, and no third-party connector ecosystem. Its import and export data options are essentially .xlsx, .csv, and PDF.

Cross-device compatibility favours Excel plainly: Windows, Mac, web, iPad, iPhone, Android. Numbers runs on Apple hardware, plus iCloud.com in a browser for everyone else.

One honest caveat applies to both: neither has built-in data integrations in the way cloud-first spreadsheet products advertise them. There are no native connectors to data warehouses, analytics platforms, or advertising accounts in either program. Excel can reach SQL databases and data warehouses such as BigQuery through Power Query or ODBC, but that is a setup task rather than a menu item; Numbers cannot reach them at all. If pulling live data from a warehouse or an ad platform is the job, both are the wrong shape of tool and a dedicated BI or cloud spreadsheet product will serve you better than either.

File compatibility is the actual pain point

Numbers opens .xlsx files and exports to .xlsx. That sentence hides a lot of trouble.

Round-tripping a file — Excel to Numbers and back — is where things break. Formatting drifts. Conditional formatting rules can be dropped. Formulas using functions Numbers doesn’t implement come back as static values or errors, and a formula silently replaced by its last-computed value is the worst failure mode a spreadsheet has, because nothing looks wrong.

CSV is its own small minefield. Exports that look fine in a text editor can be rejected by tax software, payroll portals, and school information systems, which tend to expect one exact dialect and refuse everything else. Numbers also follows your locale when reading and writing CSV, so in much of Europe the delimiter is a semicolon rather than a comma — which makes Numbers a genuinely handy tool for opening a semicolon-delimited file and re-emitting it comma-delimited, and a genuinely confusing one when you did not expect the switch.

A practical rule: if a file will be edited by more than one person and any of them uses Excel, author it in Excel. Use Numbers for documents that begin and end with you.

Collaboration

Both do real-time collaboration, and both do it well within their own ecosystem — Numbers through iCloud, Excel through OneDrive and Microsoft 365.

The difference is who you can invite. Numbers collaboration works through iCloud.com in a browser, so a Windows colleague can join, but they will be using a web app that is less capable than the native one. Excel’s co-authoring assumes a Microsoft account and works the same way for everyone. For a mixed team, Excel is less friction; for an all-Apple team, Numbers is genuinely fine.

What long-term users of both actually say

Ask people who have used both for years and the same few themes come back, with remarkable consistency.

Almost nobody argues Numbers is more capable. Even committed Mac users who prefer it describe it as easier and nicer rather than more powerful, and reach for Excel when a task gets heavy. The disagreement is never about which has more features; it is about whether the extra features are ones you need.

The people happiest with Numbers are working alone. Personal budgets, small business invoicing, tracking something for themselves. Satisfaction is high and complaints are rare, because none of the compatibility problems ever arise.

The people unhappiest with Numbers got there through work. The recurring story is a document that looked perfect, was sent to a colleague, and came back broken — or was rejected outright because the recipient expected a “real” Excel file. That experience converts people quickly, and it is about interchange rather than capability.

Excel’s complaints are the mirror image: the cost, the ribbon’s density, and that it feels heavy for simple jobs. Very few people complain that it cannot do something.

On learning materials, both are well served. Apple publishes a getting started tutorial and short introduction videos for Numbers, and its visual design makes most features findable by poking at them. Microsoft’s training library is enormous, and Excel’s popularity means any question you have has been answered in a forum already — which in practice matters more than official documentation. The deciding factor is less the material than the user’s level of understanding at the outset: Numbers is easy to use from the first hour, while Excel repays a steeper investment.

One thing people agree is easy to share: neither, entirely. Numbers files are awkward to send outside Apple hardware, and Excel files assume the recipient has Excel. Exporting to .xlsx or PDF is the common ground, and it is what most people settle on.

The most common end state is both. A large number of Mac users keep Numbers for their own documents and Excel for anything shared, which is a perfectly sensible answer that comparison articles rarely offer, this one included until now. If you can have both, having both is genuinely the low-risk choice.

What they cost

Numbers is free. It comes with the device, there is no paid tier, and no feature is held back.

Excel is not. There are three routes: a Microsoft 365 subscription, which bundles the other Office apps; a perpetual licence bought as a one-time deal for that version only; or the Excel online tool, which is web-only and free with a Microsoft account. Businesses above a certain size negotiate an enterprise custom price rather than paying list. Prices change often enough that it is worth checking Microsoft’s current pricing rather than trusting any article’s number, including this one.

Numbers, by contrast, is the closest thing to a free forever plan in this category — free for Mac, iPhone, and iPad users, with the full preset templates library included and nothing withheld.

When your Microsoft 365 subscription expires

This deserves its own answer, because it is the moment most people go looking for a comparison in the first place.

Your files remain yours. .xlsx is a documented format, your files stay on your disk, and nothing is deleted or held hostage. What changes is that Excel itself drops to read-only — you can open and print, but not edit and save. The question is only what you edit them with next. There are four honest exits:

1. Excel for the web, free. Genuinely free with a Microsoft account, and genuinely reduced — no Power Query, limited pivot capability, and everything lives in OneDrive. For light editing of existing files it is often enough, and it costs nothing to find out.
2. Buy Office outright. A perpetual licence is a real product: one payment, no subscription, yours for that version, with no feature updates afterwards. Worth knowing that the very cheap “lifetime Office licence” offers on deal sites are a grey market of uncertain provenance — often volume or OEM keys resold outside their terms, which can stop activating without warning. That trade-off is yours to make, but it should be made knowingly.
3. Numbers, if you are on Apple hardware and the sections above suit you.
4. A free alternative — which is where most people land, and which deserves a fair hearing rather than a footnote.

The free alternative most people try first: LibreOffice

If you are leaving a subscription, LibreOffice Calc is almost certainly the first name you will hear, and it deserves an honest paragraph rather than being skipped.

What it gets right: it is free, genuinely cross-platform across Windows, Mac, and Linux, and far closer to Excel than Numbers is in structure and in habit. It is one grid per sheet, the menus are laid out roughly where an Excel user expects, and it has pivot tables, macro support, and a function library deep enough that most people never reach the bottom. If your muscle memory is Excel’s, the transfer costs less here than anywhere else.

What it gets wrong: the Mac experience is the weak point, and has been for years. Users consistently report stalls and interface jank on macOS, Apple Silicon included, and the interface itself has changed little in structure since its StarOffice ancestry — it works, but it does not feel like a Mac application, and no amount of theming fixes that. On Windows and Linux this matters far less.

The honest summary: if you want Excel’s model without Excel’s bill and you can live with how it looks and feels, LibreOffice is the answer and you can stop reading here. If the Mac experience is exactly what you were trying to escape, keep going.

A third option worth knowing about

This comparison is published by the makers of another spreadsheet, so treat this section with the scepticism it deserves and take the sections above on their own merits.

VisiGrid is a native, keyboard-driven spreadsheet with 123 built-in functions that opens .xlsx, .xls, .xlsb, and .ods files and exports back to .xlsx. It is open source, and the desktop app runs its formula engine natively on your own machine — no account, no telemetry, no cloud round-trip. If what appeals about Numbers is that it is fast and yours, and what appeals about Excel is that it takes formulas seriously, that is the gap it aims at.

It is also the wrong choice for a lot of people, and worth saying plainly:

• No pivot tables. If pivot analysis is why you opened this page, use Excel or LibreOffice.
• No charts in the desktop app yet. Numbers wins this outright.
• No real-time collaboration. Both Numbers and Excel beat it here.
• No add-in ecosystem and no VBA — it uses sandboxed Lua scripting instead, which is better for reproducibility and worse for compatibility with whatever macro your colleague wrote in 2014.
• Maturity. macOS and Linux are in beta; Windows is in alpha. Numbers, Excel, and LibreOffice are all decades old and it shows.

Test the file that matters, before you decide anything

Whichever of these you are weighing, the advice that survives contact with reality is the same: do not switch on a feature list — switch on your own files. The spreadsheet that decides this is the one you actually depend on, and the only useful question is whether it survives the move intact.

You can do that with VisiGrid in one gesture and without committing to anything: drag your .xlsx onto app.visigrid.app/try. It opens in your browser, there is no account and no sign-up, and the file stays in your browser — nothing is uploaded anywhere unless you deliberately create an account to save it. If your formulas come through and the numbers match, that tells you more than this entire page. If they don’t, you have lost ninety seconds and learned something worth knowing before you moved anything important.

Do the same test with Numbers and with LibreOffice. Whichever one opens your real work without surprises is your answer, regardless of what any comparison says.