AI in Microsoft Excel

AI in Excel — formulas, analysis, automation

Microsoft Excel with Krater

Use GPT-5, Claude Opus, and 350+ AI models with Microsoft Excel. Generate formulas, clean data, build analyses, and automate spreadsheets from $20/mo. A Copilot for Excel alternative.

Krater pricing · AI model directory · Gmail integration

Microsoft 365 Copilot limitations

  • Requires Microsoft 365 Business + Copilot add-on ($30/user/mo)
  • OpenAI models only — no Claude, Gemini, or open-source
  • Locked to Microsoft tenant
  • No image, video, or cross-app generation

Krater

  • 350+ AI models (GPT-5, Claude Opus 4, Gemini 3 Pro, Grok, DeepSeek)
  • Image, video, voice, and document tools included
  • Cross-app workflows, connect 300+ other apps
  • Per-account pricing, not per-seat
  • Plans from $20/month

Actions

Generate any Excel formula

Describe what you need; Krater writes the exact formula.

Explain a complex formula

Paste a nested formula and get a plain-English breakdown.

Clean and dedupe a sheet

Standardize columns, remove duplicates, fix typos at scale.

Pivot insights from raw data

Ask a question; Krater writes the analysis and the chart.

Fill columns with AI

Sentiment, classification, summarization — row by row.

Convert text to structured rows

Paste an email or PDF; get a clean Excel table back.

Translate spreadsheets

Localize an entire workbook in one step.

Build a dashboard from a brief

Describe the dashboard; get the cells, formulas, and charts.

Starter prompts

Write me a formula

Give me an Excel formula that <task>. My data is in <range>. Show the formula and explain it.

Explain this formula

Explain this Excel formula in plain English:

Clean this column

My column <X> in Excel has messy text. Suggest a formula to standardize it and remove duplicates.

Categorize these rows

Add a new column to my Excel sheet that classifies each row in <range> as <category list>.

Build a pivot summary

Build a pivot table summary of my Excel sheet showing <metric> by <dimension>.

Analyze sentiment

Add a sentiment column (positive / neutral / negative) to my Excel sheet for the comments in <column>.

Translate this workbook

Translate my Excel workbook from English to Spanish. Preserve formulas.

Spot anomalies

Look at the data in <range> and flag the rows that look like outliers, with a reason for each.

Frequently asked questions

Is Krater a Microsoft Copilot alternative?

Yes. Microsoft 365 Copilot is $30/user/month on top of a Business plan. Krater is $20/month total, gives you 350+ models including GPT-5 and Claude Opus 4, and works with any Microsoft account.

Can Krater write Excel formulas?

Yes. Describe the result you want and Krater writes the formula, validates it on your data, and explains how it works.

Which Excel plans does this work with?

Microsoft 365 Personal, Family, Business, and Enterprise — anywhere the Microsoft Graph API is exposed. Copilot requires Business; Krater does not.

How do I use AI in Excel with Krater?

Connect your Microsoft account, point Krater at the workbook or range, and prompt. Krater can read cells, write formulas, fill columns, and run analyses.

Is my Excel data safe?

Yes. Krater never trains on your data. Cell content is sent only for the specific request and not retained for training.

Can Krater build pivot tables and charts?

Yes. Krater can describe and assemble pivot summaries and charts, and write the underlying formulas you can drop into Excel directly.

How do I connect Excel to Krater?

Open Krater, go to /additions, search Microsoft Excel, click Connect, and sign in with your Microsoft account. Takes about 30 seconds.