xAI Brings Grok to Microsoft Excel: Ask Questions, Write Formulas, Run Scenarios in Plain English

xAI Brings Grok to Microsoft Excel: Ask Questions, Write Formulas, Run Scenarios in Plain English

On July 20, 2026, xAI launched Grok for Excel — a Microsoft Excel add-in that brings Grok's conversational AI directly into the world's most widely used spreadsheet application.

The premise is simple: instead of writing formulas, you describe what you want in plain English. Grok writes the formula, explains it, and applies it. But the product goes significantly further than formula autocomplete — it can query your data, model financial scenarios, generate charts, and clean messy datasets using natural language instructions.

What Grok for Excel Does

Natural Language Formula Writing

The core feature is formula generation. Instead of remembering whether to use VLOOKUP or XLOOKUP, or how to nest an IF inside an IFERROR, you describe the outcome:

"Find the revenue for each customer from the Sales tab and add it next to their name in column D"

Grok writes the correct formula, shows a plain-English explanation of what it does, and optionally explains why it chose the specific approach. If the formula produces an error, it diagnoses the issue and suggests a fix.

This works for everything from basic SUM and AVERAGE to complex array formulas, dynamic arrays, LAMBDA functions, and Power Query M expressions.

Data Querying

Rather than building pivot tables manually, you can ask Grok to analyze your data directly:

"Which product category had the highest average margin last quarter?"

"Show me all customers who ordered more than 3 times but spent less than $500 total"

Grok reads the active sheet (or sheets you specify), runs the analysis, and returns the answer in the task pane — with a button to create a new sheet showing the filtered or aggregated data.

Scenario Modeling

For financial modeling and forecasting, Grok can generate scenario tables from a description:

"Model what happens to net profit if COGS increases by 5%, 10%, and 15%, and revenue grows by 2% or stays flat"

Grok builds a scenario comparison table, applies appropriate formulas, and formats it with conditional highlighting. What previously required a skilled analyst to build in an hour takes under 30 seconds.

Data Cleaning

Messy real-world data is one of Excel's biggest pain points. Grok can:

• Standardize date formats across inconsistent columns
• Remove duplicate rows based on specified key fields
• Split combined name fields (e.g., "John Smith" → First Name / Last Name)
• Normalize categorical values ("NY", "New York", "new york" → "New York")
• Flag or remove outliers based on statistical thresholds

Each cleaning action is previewed before applying, with an undo option.

How to Install It

1. Open Microsoft Excel (desktop or web)
2. Go to Insert → Add-ins → Get Add-ins
3. Search for "Grok" and install the xAI Grok add-in
4. Sign in with your xAI account (or create one — free tier available)
5. The Grok task pane appears on the right side of your workbook

The add-in works in Excel for Windows, Excel for Mac, and Excel Online. It does not currently support the Excel mobile app.

Pricing

The add-in uses the same Grok API that powers xAI's other products. Pro users get access to Grok's most capable model; Free users get a lighter version optimized for formula tasks.

How It Compares to Microsoft Copilot in Excel

Microsoft already ships its own AI in Excel via Microsoft 365 Copilot, which has similar formula and data analysis capabilities. The differences:

For users who already pay for Microsoft 365 Business or Enterprise, Copilot is effectively free and deeply integrated. For everyone else — particularly individuals and small businesses on lower M365 tiers — Grok for Excel is a substantially cheaper way to get AI in their spreadsheets.

Notably, GPT-5.6 became available in Microsoft 365 Copilot on July 9, 2026, meaning Copilot users are now running on OpenAI's latest model. Grok's advantage will need to come from unique features and pricing rather than model capability.

Who Should Use This

Individual analysts and freelancers who do not have access to Microsoft 365 Copilot but work heavily in Excel will get the most value from Grok for Excel. At $10/month it is significantly cheaper than the Microsoft alternative.

Finance teams in smaller companies that cannot justify enterprise M365 seats for every analyst can add AI capabilities to Excel without changing their existing software stack.

Teachers and students using Excel for coursework and data analysis can use the free tier for formula help and basic querying.

Power users who want scenario modeling — financial modelers, business analysts, and startup founders building projections — will find the scenario table generation genuinely useful.

The Takeaway

Grok for Excel is a well-executed, focused product. It does not try to be everything — it picks the highest-friction parts of Excel work (formula writing, data querying, scenario modeling, cleaning) and makes them accessible through natural language.

xAI is making a clear play for the "AI in productivity tools" market that Microsoft and Google are both aggressively building toward. With a lower price point and no dependency on a broader software subscription, Grok for Excel is worth installing for anyone who spends meaningful time in spreadsheets.