Pi for Excel
Open-source, multi-model AI sidebar add-in for Microsoft Excel. Powered by Pi.
Pi for Excel is an AI agent that lives inside Excel. It reads your workbook, makes changes, and does research — using any model you choose. Bring your own API key or OAuth login for Anthropic, OpenAI, Google Gemini, or GitHub Copilot.
Features
Core spreadsheet tools — 16 built-in tools that the AI can call to interact with your workbook:
Tool What it does get_workbook_overview Structural blueprint — sheets, headers, named ranges, tables, charts, pivots read_range Read cells in compact (markdown), CSV, or detailed (with formatting) mode write_cells Write values/formulas with overwrite protection and auto-verification fill_formula AutoFill a formula across a range (relative refs adjust automatically) search_workbook Find text, values, or formula references across all sheets modify_structure Insert/delete rows/columns, add/rename/delete/hide sheets format_cells Apply formatting — fonts, colors, number formats, borders, named styles conditional_format Add or clear conditional formatting rules trace_dependencies Trace formula lineage (precedents upstream or dependents downstream) explain_formula Plain-language formula explanation with cited cell references view_settings Gridlines, headings, freeze panes, tab color, sheet visibility comments Read, add, update, reply, resolve/reopen cell comments workbook_history List/restore automatic in-between-saves backups for workbook mutations instructions Persistent user-level and workbook-level guidance for the AI conventions Configurable formatting defaults (currency, negatives, zeros, decimal places) skills Bundled Agent Skills for task-specific workflows
Multi-model support — use any supported provider; switch models mid-conversation:
Anthropic (Claude) — API key or OAuth
(Claude) — API key or OAuth OpenAI / OpenAI Codex — API key
/ — API key Google Gemini — API key
... continue reading