Forum Discussion
Limitations of Microsoft 365 Copilot for Excel workflows?
I've been exploring Microsoft 365 Copilot for Excel workflows recently. It works well for simple queries, but I still find it limited when dealing with: - messy data cleaning - converting image...
For these types of more complex scenarios, I find Claude for Excel (Excel Add-in) from Anthropic is a much better option that Copilot. Claude for Excel can handle extremely complex and messy datasets across multiple files. Of course, it would be an additional cost but worth having a look at if this is something you are specifically looking at.
Edit in Copilot (AKA. Agent Mode) for Excel using the Claude models (Claude Opus 4.5 or 4.6) will give you a much better result than relying on the GPT-5.x models. Note that you would need to enable Anthropic sub-processor in order to get the Claude models available in Excel.