Pi for Excel introduces an open-source AI sidebar add-in that transforms Microsoft Excel into an interactive spreadsheet environment. This experimental tool brings AI-powered assistance directly to Excel, allowing users to leverage multiple AI models to read, modify, and research their workbooks with unprecedented ease. Users can bring their own API keys for Anthropic, OpenAI, Google Gemini, or GitHub Copilot.

The add-in supports 16 built-in tools that enable the AI to interact comprehensively with spreadsheet data, including reading ranges, writing formulas, tracing dependencies, and applying formatting. Automatic context injection provides the AI with relevant workbook information before each interaction, while session management allows multiple tabs per workbook with auto-save/restore functionality.

Pi for Excel addresses a major pain point in spreadsheet work by allowing natural language commands to drive complex operations. The experimental features like Python bridges and integrations with web search tools suggest this could fundamentally change how users interact with Excel, moving beyond traditional formula-based workflows to AI-assisted spreadsheet management.