Report automation
Using the raw data tab, build a weekly report tab with: totals by {{dimension}}, week-over-week change, and a chart. Use formulas (no pasted values), document each formula in a notes column, and check totals match the raw data.
Business
Best agent for spreadsheets & reporting
Cleaning data, building formulas, pivot tables and recurring reports.
Full ranking
Task index, 0 to 100. Bars are scaled to the field, so small gaps look small.
- 1
- 2
- 3
- 4Microsoft Copilot in ExcelMicrosoft · Platform−10.086
Native Excel integration.
Key takeaways
- 1Agents that edit real spreadsheets are now mainstream in Excel and Sheets.
- 2Opus 5.5 and Astra lead on correct, auditable formulas.
- 3Keep raw data separate from calculations.
Recommended setup
The AI built into your spreadsheet tool, backed by a frontier model, with a changes log.