Excel AI Agent 2026: A Year Later — Still the Best Free AI Add-In for Spreadsheets
It's been just over a year since we launched the Shayntech Excel AI Agent — a free, open-source Excel add-in that lets you control spreadsheets with plain English. What started as a side project to help our own team automate tedious reporting tasks has grown into one of the most popular free AI tools for Excel users worldwide.
In that year, the AI landscape has changed dramatically. Microsoft doubled down on Copilot with aggressive pricing. Google integrated Gemini into Sheets. ChatGPT plugins came and went. Through it all, the Excel AI Agent has remained 100% free, open source, and privacy-first.
So where are we now? What's changed, what's improved, and — most importantly — is the Excel AI Agent still the best free option in 2026? Let's take a look.
What's New in the 2026 Release
The Excel AI Agent hasn't been sitting still. Here are the biggest updates shipped over the past year:
| Feature | What Changed |
|---|---|
| DeepSeek & Claude 4 Support | Added DeepSeek V3/R1 and Claude 4 Sonnet as optional AI backends — better accuracy on complex formulas |
| Batch Processing Engine | Process 10,000+ rows of data in a single command — cleaning, transforming, enriching at scale |
| Natural Language Charting v2 | Completely rewritten chart engine supporting combo charts, waterfall, and custom color palettes |
| Template System | Save and reuse AI-generated workflows as templates — one-click reports and dashboards |
| Macro Generation | Describe a VBA macro in English and the agent writes, tests, and inserts it into your workbook |
| Ollama Offline Mode | Full local execution with Llama 4, Mistral, or Qwen — zero data leaves your machine |
Each of these updates was driven by community requests from our open-source users. The template system, in particular, has been a game-changer for teams that run the same reports every week — now it's a one-click operation.
VBA Macro Generation: From English to Production Code
One of the most requested features — and a true highlight of the 2026 update — is the ability togenerate VBA macros from natural language descriptions. Here's how it works:
"Create a macro that loops through column A, finds all cells containing 'Overdue', and highlights the entire row in red."
The AI generates the complete VBA code, explains what each section does, and inserts it into a module when you confirm. You don't need to know Range.Find from Range.AutoFilter — just describe the outcome you want.
' Generated by Excel AI Agent from: "Find overdue items, highlight row red"
Sub HighlightOverdueItems()
Dim cell As Range
Dim ws As Worksheet
Set ws = ActiveSheet
For Each cell In ws.Range("A1:A" & ws.Cells(ws.Rows.Count, 1).End(xlUp).Row)
If InStr(1, cell.Value, "Overdue", vbTextCompare) > 0 Then
cell.EntireRow.Interior.Color = RGB(255, 200, 200)
End If
Next cell
End Sub
This feature alone has saved our users countless hours. What used to require a trip to Stack Overflow and 20 minutes of debugging is now a 10-second conversation.
Excel AI Agent vs. Microsoft Copilot in 2026
Microsoft Copilot for Excel has improved over the past year — it's fair to ask how the free alternative stacks up. Let's compare head-to-head across the features that matter most:
| Feature | Shayntech Excel AI Agent | Microsoft Copilot (2026) |
|---|---|---|
| Price | Free (BYOK) | $30/user/month (M365 Copilot) |
| AI Model Choice | 10+ providers (OpenAI, Claude, Gemini, DeepSeek, Ollama...) | GPT-4o only (Microsoft-managed) |
| VBA Macro Generation | ✅ Full macro generation from natural language | ❌ Not available |
| Batch Processing (10K+ rows) | ✅ Yes, with progress tracking | ⚠️ Limited to visible selection |
| Chart Creation | ✅ Combo, waterfall, custom palettes | ✅ Basic charts only |
| Works Offline | ✅ Via local Ollama models | ❌ Requires internet |
| Open Source | ✅ Full code on GitHub | ❌ Proprietary |
| Data Privacy | ✅ Data stays on your machine (or goes to your chosen provider) | ⚠️ Processed via Microsoft Cloud |
The biggest differentiator remains choice and control. With the Excel AI Agent, you pick your AI provider, you control your data, and you never pay a subscription fee. Copilot is improving, but it's still a walled garden at $30/seat/month.
Real-World Workflows: What Users Are Building
Over the past year, we've seen some remarkable workflows built on top of the Excel AI Agent. Here are three that stand out:
Workflow 1: Automated Financial Reporting (Fully Templated)
A financial services firm in Dubai uses the Excel AI Agent to automate their weekly portfolio reports. They built a template that:
- Pulls raw data from their CRM export
- Cleans and standardizes currency formats across 12 columns
- Calculates P&L, ROI, and Sharpe ratios using AI-generated formulas
- Creates a dashboard with five linked charts
- Generates a summary table for management review
What used to take a senior analyst 4 hours every Monday is now a 30-second template execution.
Workflow 2: Inventory Reconciliation with Batch Processing
A retail company processes inventory reconciliations across 50+ stores. They use the batch processing engine to:
- Compare stock levels against expected quantities
- Flag discrepancies greater than 5%
- Generate a consolidated exception report with conditional formatting
- Email the report to store managers automatically via the built-in VBA macro
Processing 50,000+ rows across all stores takes under 2 minutes.
Workflow 3: Academic Research Data Cleaning
A PhD researcher uses the Excel AI Agent (with Ollama running Llama 4 locally) to clean survey response data — all offline, fully private. Natural language commands handle removing duplicates, standardizing text responses, flagging outliers, and generating descriptive statistics tables.
The key insight: the Excel AI Agent isn't just for business users. Anyone who works with data in spreadsheets — researchers, educators, students, freelancers — benefits from not needing to write a single formula.
Architecture: How It Works Under the Hood
One question we hear frequently: "How does the add-in communicate with the AI without sending my data to Shayntech's servers?" The answer lies in the architecture:
| Layer | Component | Description |
|---|---|---|
| 1 | Excel Add-In (VSTO) | Runs inside Excel, reads/writes cells, manages the chat panel UI |
| 2 | Python Backend (Local) | Lightweight Python bridge that handles API calls, formula parsing, and chart commands |
| 3 | AI Provider API | Your API key → your chosen model. Shayntech never sees your data |
| 4 | Ollama (Optional) | Entirely local inference — zero network traffic |
This four-layer architecture ensures that your spreadsheet data follows a direct path to the AI model you've chosen — with no intermediary storing or inspecting it. For the privacy-conscious, the Ollama path means everything stays on your local machine.
Getting Started in Under 5 Minutes
One thing hasn't changed since launch: the setup is still refreshingly simple.
- Visit the product page at shayntech.com/products/excel-ai
- Download the installer for your Excel version (Microsoft 365, Office 2021, Office 2019)
- Get an API key from any supported provider — OpenAI, Claude, Gemini, DeepSeek, or set up Ollama for local use
- Enter the key in the add-in settings (one-time setup)
- Type your command in the chat panel — the AI handles the rest
No account registration. No credit card. No subscription. The add-in is ready to use the moment you enter your API key.
Quick Start: Download the Excel AI Agent → Get your API key →
Type "Create a monthly sales dashboard" → Watch the AI build your report in seconds.
The Bottom Line: Still Free, Still the Best
A year in, the Excel AI Agent is more capable, more reliable, and more ambitious than ever. We've added VBA macro generation, batch processing, a chart engine overhaul, DeepSeek support, and a template system — all while staying completely free and open source.
Microsoft Copilot has made progress, but it remains a premium-priced, single-model, closed-source product. For users who value choice, privacy, and zero subscription costs, the Excel AI Agent is still the clear winner.
Ready to automate your spreadsheets for free? Download the Excel AI Agent today at shayntech.com/products/excel-ai and join thousands of professionals who've made the switch.
Shayntech Engineering
May 22, 2026