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...
Yeah the messy data thing is probably the biggest gap right now. Copilot works best when data is already in a clean table format with proper headers. For the PDF/image to table stuff, I've had better luck using Copilot in Edge to extract the data first, then pasting it into Excel and cleaning up from there.
What I do is use Copilot for the quick stuff like "sum this column" or "create a chart from this data" and keep Power Query for the heavy lifting.