XDA’s writer this week made a case the spreadsheet crowd will recognise: the Excel setting that flattened a week’s worth of cleanup work was Power Query’s Group By, not a Copilot button. The Copilot prompt is faster to demo, the Group By saved more hours. Eight Excel automation tools below cover the same ground, the ones that pay back in the first week and the ones that pay back over months.
We tested 8 of the best Excel automation apps for desktop in 2026. The brief: which ones automate cleanup, which ones build full workflows, and which ones handle a million-row table without melting the machine.
What to look for in an Excel automation tool
Six criteria sort the daily drivers from the side experiments:
- Built-in vs add-in vs external. Some live inside Excel, some run alongside it, some replace it.
- Repeatable vs one-shot. The best automations run again next month with one click.
- Data size. A tool that breaks above 100k rows is not actually automating much.
- Learning curve. The fastest payback is from tools that look like the current workflow.
- Cross-machine reuse. A macro file that works on one PC is half-automated.
- Free vs paid. Excel itself is paid, the automation around it does not have to be.
Quick comparison
| Tool | Best for | Platforms | Free plan | Starting price | Built-in to Excel |
|---|---|---|---|---|---|
| Power Query | Data cleanup | Windows, macOS | Yes | Free with Excel | Yes |
| Power Automate Desktop | Cross-app RPA | Windows | Yes | Free | No |
| Office Scripts | Cloud-side TypeScript | Excel for Web, Windows | With M365 | M365 plans | Yes (M365) |
| AutoHotkey | Keyboard-driven workflows | Windows | Yes | Free | No |
| Numerous.ai | AI in cells | Windows, macOS | Yes | $10/mo | Add-in |
| xlwings | Python-Excel bridge | Windows, macOS | Yes | Free (open source) | No |
| Macabacus | Finance modelling | Windows | Trial | $59/year | Add-in |
| Visual Basic for Applications | Legacy macros | Windows, macOS | Yes | Free with Excel | Yes |
The tools
1. Power Query, Best for repeatable data cleanup
Power Query is the data ingestion and transformation tool that ships inside Excel and Power BI, and it is the answer to most “I do this same cleanup every Monday” problems. The interface is a recorded sequence of M-language steps, the refresh button reruns them. Source data can be a CSV, a SQL table, a JSON API, or another workbook, the steps in between stay identical.
Where it falls short: M-language errors are unhelpful. A broken step often surfaces three steps later, which makes debugging a long pivot table painful.
Pricing: Free with Excel 2016 or later, including Microsoft 365 subscriptions and standalone licenses.
Platforms: Windows (Excel 2016+), macOS (Excel 2019+ with reduced feature parity).
Download: Built into Microsoft Excel, see Microsoft 365
Bottom line: First place to look if a recurring cleanup task feels like wasted hours.
2. Power Automate Desktop, Best for cross-app robot work
Power Automate Desktop is Microsoft’s RPA tool, free with Windows 11 and free with a Microsoft account on Windows 10. It records UI interactions across apps, including Excel and any browser-based system, then replays them on a schedule. The use case is the workflow that ends with an Excel paste from a system that has no API.
Where it falls short: UI-recording RPA is brittle by nature. A button move in the upstream app breaks the flow until someone re-records.
Pricing: Free for desktop flows on personal Microsoft accounts. Premium connectors and unattended runs require a Power Automate license starting at $15/user/month.
Platforms: Windows 10 and 11. No macOS client.
Download: Power Automate Desktop
Bottom line: The right tool for filling spreadsheets from systems that lock down their export.
3. Office Scripts, Best for cloud-side TypeScript automation
Office Scripts is the modern replacement for VBA inside Excel, TypeScript-based, cloud-stored, and shareable across a tenant. The Action Recorder mode generates a script from a recorded action, the Code Editor lets a developer extend it. Scripts run in Excel for Web and in the desktop client on Windows, and they trigger from Power Automate flows.
Where it falls short: Microsoft 365 commercial plans only. Personal Microsoft accounts and Excel standalone licenses do not see the feature.
Pricing: Included with Microsoft 365 Business Standard ($12.50/user/mo), Business Premium, and E3/E5.
Platforms: Excel for Web (any OS browser), Excel for Windows desktop.
Download: Built into Microsoft 365 commercial plans, see Office Scripts docs
Bottom line: The post-VBA path for any organisation on Microsoft 365 commercial.
4. AutoHotkey, Best for keyboard-driven workflows around Excel
AutoHotkey is the Windows scripting tool from the keyboard-shortcut piece next door, and it earns a place here for one reason: Excel’s keyboard surface is enormous, and AHK can wrap it. Hot-strings expand to formulas, hotkeys insert today’s date, or copy-as-values, or run a Power Query refresh. A 20-line script saves more keystrokes than any add-in.
Where it falls short: Windows only, and the script lives in a file that has to follow the user to a new machine.
Pricing: Free, open source.
Platforms: Windows 7 and later.
Download: AutoHotkey
Bottom line: The cheapest keystrokes-per-hour upgrade Windows users can install.
5. Numerous.ai, Best for AI inside cells
Numerous.ai is the most polished of the “Copilot-like AI add-in for Excel and Google Sheets” tools. Use it like a formula, =AI(“summarise this customer note”, A2), and it returns the LLM’s answer in the cell. Bulk operations work as a fill-down, which is where Copilot-style chat sidebars still struggle.
Where it falls short: every cell call is a billed API hit. Tasks that touch thousands of rows accumulate cost fast.
Pricing: Free starter with a monthly token cap. Pro $10/mo, Business $30/mo unlock larger limits and better models.
Platforms: Excel for Windows and macOS, plus Google Sheets.
Download: Numerous.ai
Bottom line: The best in-cell AI for batch text classification and rewriting.
6. xlwings, Best for Python in Excel
xlwings lets a Python script read and write an Excel workbook, and the workbook can call Python functions as if they were UDFs. The reverse direction is more interesting: build a Python pipeline that runs nightly and outputs a refreshed workbook, with charts and formatting intact. xlwings does both ends.
Where it falls short: requires a Python install on the machine that runs the workbook. Distribution to non-technical users is harder than a pure Excel solution.
Pricing: Free for the open-source PyPI package. xlwings PRO starts at $389/user/year for deployment tools.
Platforms: Windows, macOS, both with Python 3.9+.
Download: xlwings
Bottom line: The right tool for data scientists who need to ship to Excel users.
7. Macabacus, Best for finance modelling
Macabacus is the Excel add-in finance teams install on day one. The shortcut suite, formatting toolbar, audit tools, and chart linking solve the daily pain of investment banking and corporate-finance modelling, the kind of work where a single broken reference costs hours.
Where it falls short: Windows only. The mac install is documented as “not currently supported” and that has not changed since 2024.
Pricing: 30-day trial. Standard $59/year/user, Pro $179/year/user with formatting and pitch-book tools.
Platforms: Windows, Excel 2016+.
Download: Macabacus
Bottom line: The financial-modelling Excel add-in, no contest.
8. Visual Basic for Applications, Best for legacy macros
Visual Basic for Applications is the Excel automation language since 1993, and it still works. New automation should land in Office Scripts or Power Query, but the macro libraries already in use by accounting teams across the world are written in VBA, and VBA still ships in every desktop Excel install.
Where it falls short: Microsoft has positioned Office Scripts as the future. New VBA features are unlikely, security defaults block macros by default in modern Office.
Pricing: Free with any Excel desktop install, including standalone Excel 2024 and Microsoft 365.
Platforms: Windows, macOS (with reduced API).
Download: Built into Microsoft Excel, see VBA reference
Bottom line: Maintain it where it exists, do not write new code in it.
How to pick the right one
If you do recurring data cleanup: Power Query. Nothing else matches the payback.
If you need cross-app automation: Power Automate Desktop.
If you are on Microsoft 365 Business or Enterprise: Office Scripts for new automation.
If you want AI inside cells: Numerous.ai.
If you are a finance modeller: Macabacus.
If you are a Python user: xlwings.
Stay on VBA if the macros are working and the team trained on it. Migrating a working VBA library to Office Scripts is a project, not an upgrade.
FAQ
Is Power Query free? Yes, with any modern Excel install (2016 or later, Microsoft 365). It is not a separate purchase.
What is the best Excel automation for Mac? Power Query (built in, with feature gaps), VBA, and xlwings. Power Automate Desktop is Windows only.
Can Copilot in Excel replace these tools? For one-off prompts, sometimes. For repeatable workflows, no. Copilot is a chat interface, not a recordable script. Power Query, Office Scripts, and Power Automate are repeatable, Copilot is not.
What replaced VBA in Excel? Office Scripts (TypeScript, cloud-stored) for Microsoft 365 commercial users. Power Query handles the data side, Office Scripts handles the application logic, Power Automate handles cross-app workflows.
Is AutoHotkey safe for Excel automation? Yes, if you write or audit the script. AutoHotkey scripts are plaintext, and the runtime is open source. Avoid running unsigned scripts from unknown sources.
