📊 An AI agent that lives inside Excel, reads your workbook, makes changes, and does research.
Pi for Excel is an open-source add-in for Microsoft Excel that brings AI directly to your spreadsheets. Bring your own API keys or OAuth login.
Supported models:
- Anthropic (Claude) — API key or OAuth
- OpenAI / OpenAI Codex — API key
- Google Gemini — API key
- GitHub Copilot — OAuth
16 tools the AI can use:
| Tool | What it does |
|---|---|
read_range | Read cells in markdown, CSV, or detailed mode |
write_cells | Write values/formulas with overwrite protection |
fill_formula | AutoFill formulas across ranges |
explain_formula | Explains formulas in plain language |
trace_dependencies | Traces formula lineage |
conditional_format | Applies/clears conditional formatting rules |
workbook_history | Restores automatic workbook backups |
What can you ask it?
- “Calculate the average sales by region in column D”
- “Explain what this XLOOKUP formula does”
- “Format this table with alternating row colors”
- “Find all negative values in the spreadsheet”
💡 Explanation in a nutshell#
Pi for Excel is a bridge between LLMs and the structured format of a spreadsheet. The AI receives a “blueprint” of your workbook (sheets, headers, named ranges) and can use specific tools to read and modify cells — without directly accessing your data, since everything is processed locally with your own API key.
More information at the link 👇
Also published on LinkedIn.
