Six Tools Compete to Replace Excel Macros, None Covers All
Global – October 27, 2026 -- No single tool replaces an Excel macro end to end: six options (Power Query, Office Scripts, Power Automate, Python, RPA and Alteryx One) each cover a different slice of the work, according to a new comparison of automation approaches.
Power Query and Office Scripts cover data preparation and workbook tasks
Power Query suits macros that mainly import files and cleanse data, and it can reshape and aggregate data before loading it. It handles button clicks, workbook events and precise output formatting poorly.
Office Scripts is the closest native Microsoft 365 option. It runs recorded or edited TypeScript in Excel for the web or the desktop app on Windows or Mac. It has no Excel-level events, and Microsoft documents that VBA offers broader desktop coverage.