Data Cleaning on Mac: What Works and What Does Not

What Excel for Mac Can Do

Excel for Mac covers a good deal of routine data work. It imports and refreshes data, shapes it in a query editor, supports PivotTables, slicers and charts, and runs VBA. If your cleaning needs are limited to importing files, reshaping columns and refreshing on a schedule, Excel for Mac handles that.

Microsoft has been extending Power Query to macOS steadily. Microsoft records that refresh for text, CSV, XLSX, JSON and XML files arrived in 2019, that VBA gained the ability to create and edit queries in October 2019, and that SharePoint and OData sources were added in January 2021. The full query editor became available in 2022. In 2025 Excel for the web gained the ability to refresh queries from authenticated data sources.

Microsoft's own support documentation sets out the current position plainly: Excel for Mac has many of the same basic analysis features as Windows, and offers some support for Power Query . That is the vendor describing its own product as partial.

Where Excel for Mac Falls Short

Three limitations account for most of the friction Mac users report.

• The Data Model is not available. Microsoft lists refresh for queries loaded to the Data Model as not yet supported in its Power Query data sources documentation .
• You cannot choose where a query loads. The Load To dialog is not present on Mac, so queries load into worksheet tables by default. Intermediate tables cannot be suppressed or sent to the Data Model instead.
• Authoring in the query editor is not available. Microsoft confirms this in its Mac Power Query guide , and notes that VBA can perform Power Query authoring instead.

These are not oversights awaiting a fix. Excel for Mac and Excel for Windows are built on different codebases against different operating systems, and the Data Model depends on an in-memory engine that Microsoft has said is not present in the Mac version.

Power Query on Mac: Licence and Version Requirements

The single most common source of confusion is the licence rather than the operating system. Microsoft states in its overview of Power Query in Excel that there is no Power Query support in Excel 2016 or Excel 2019 for Mac.

That means a Mac user holding a standalone or per-user Office licence has no Power Query whatsoever, regardless of how recent the installation is. The feature requires a Microsoft 365 subscription, and Microsoft states it is generally available from version 16.69 (23010700) onwards. A user on an older build who cannot see the Get Data command is usually on a non-subscription licence rather than an unsupported Mac.

This distinction matters when you search for a missing feature. "Not on Mac" and "not on my licence" have different causes and different remedies, and conflating them leads to the wrong one.

Why Power Pivot Is Not Coming to Mac

Power Pivot is the clearest example of a permanent platform boundary. Responding to users on Microsoft's own support forums, the Excel team has said it is unlikely Power Pivot will arrive on Mac because it relies on features of the operating system that do not exist on macOS.

That answer was given on technical grounds, not a delivery schedule. Waiting for a future Excel release does not resolve this if your workflow depends on the Data Model, which is also why a purely local Mac solution is not always available. The same reasoning applies to the Data Model restrictions described above.

Numbers and the Browser Route

Apple Numbers is the spreadsheet most Mac users reach for first, and it has no equivalent of Power Query or Power Pivot. It offers tables, charts, forms and basic sorting, with no query layer and no data model. It handles presentation and straightforward tabular work, but it is not built for record linkage or large-scale standardisation.

The route that avoids the whole category is the one many Mac users already take for collaboration. Google Sheets runs in Safari and Chrome on macOS, has a native desktop app and is available on iPad. Moving a file to Sheets moves the cleaning problem to a cloud execution environment where the limits are not tied to the desktop Excel grid or to the local machine.

For a one-off job, exporting to CSV and using a browser tool is often less work than configuring a virtual machine. Bootcamp and virtualisation software do work, but they carry a licence cost and an administration overhead that most one-off cleaning jobs do not justify.

How a Workspace Add-on Differs

Most of the constraints above share one cause: they are properties of a desktop application installed on your machine. A Google Workspace add-on does not share them, because it executes in Google Sheets rather than inside Excel.

• No installer and no runtime. Installation is a click in the Google Workspace Marketplace. There is no COM add-in to register and no operating system component to deploy.
• No administrator rights for an individual install. You install it for your own account. This matters in managed environments where installing desktop software is blocked.
• Central deployment for organisations. A Workspace administrator can install the add-on domain-wide or for selected groups from the Admin console , so it can be rolled out to a Mac, Windows or Linux fleet identically.
• The same code path on every platform. There is no separate Mac build to fall behind, because there is no local build at all.

This is an architectural point rather than a competitive one. The relevant comparison is between software that runs inside a desktop spreadsheet and software that runs inside a browser-hosted one.

Starting Without Installing Anything

To establish whether fuzzy matching suits your data before committing to a tool, the free tools on this site run in the browser. There is no installer, no account and no operating system requirement, and files are processed on your own device without being uploaded.

• The Fuzzy Matching Tool scores two lists against each other and reports a similarity value for every pair.
• The CSV Editor inspects a file, reports on its condition, then filters, sorts and deduplicates it.
• The CSV Diff compares two files on a key column and reports added, removed and changed rows.

If the results justify a full workflow, the Standard Data Cleaning tools cover fuzzy matching, deduplication, profiling, enrichment and conditional formatting. The spreadsheet formulas cover in-cell lookups and similarity scores.

Frequently Asked Questions