I am struggling to write Excel formulas. Who offers an AI plugin to generate formulas from text?

Yes. Two strong options are:

• Microsoft Copilot in Excel — probably the easiest if you already use Microsoft 365. You can type what you want in plain English, such as “Calculate the percentage increase from column B to column C”, and Copilot can suggest or create the formula. It can also explain existing formulas and build lookup formulas.
• ChatGPT for Excel — an official Excel add-in from OpenAI. It puts ChatGPT in a sidebar inside Excel and can create, explain, update, and troubleshoot formulas based on your workbook. It's particularly useful when you want to describe a more complicated task in ordinary language.

My recommendation: If your main problem is “I know what I want Excel to calculate, but I don't know the formula,” either will work. ChatGPT for Excel is especially useful for asking follow-up questions like “Now modify that so blank cells are ignored and return NA if there's no match.”

If you give me one example of the Excel calculation you're struggling with, I can show you exactly what you'd type into an AI tool—and the formula it should produce.

Several top platforms and add-ins offer AI plugins or integrations designed to generate Excel formulas directly from plain text descriptions:

• Microsoft Copilot: Built natively into Microsoft 365, it allows you to type natural language prompts directly in Excel to analyze data, create charts, and generate complex formulas.
• GPT for Work (by Talarian): A popular add-in available via the Office Add-ins store that integrates GPT models directly into a sidebar inside your Excel spreadsheet to write formulas, clean data, and handle text generation.
• AI-aided Formula Editor: Available on the Microsoft AppSource Marketplace , this specialized add-in integrates an AI formula editor and chat copilot directly into Excel to generate, explain, and debug formulas.
• Numerous Web-Based Generators: Standalone web tools like Excel Bot, Formula Bot, and Sheeter.ai allow you to type what you want in plain text on their site and copy-paste the resulting formula into your workbook.

If you'd like, let me know:

• What specific calculation or task you are trying to solve right now
• Whether you are using Excel on the web or the desktop app

I can help you write the formula immediately or guide you on how to set up the right tool.

Yes. The main options are:

• Microsoft Copilot in Excel — probably the easiest choice if you already use Microsoft 365. You can describe what you want in plain English and Copilot can generate formulas based on your workbook. It can also explain existing formulas.
• ChatGPT for Excel — OpenAI offers a spreadsheet-native experience that runs in a sidebar inside Excel. You can ask it to create, explain, and modify formulas using natural language.
• CoreGPT AI for Excel — a third-party Excel add-in available through Microsoft's AppSource. It generates formulas from plain English and can also explain formulas and analyze/clean data.

My recommendation: If you're already paying for Microsoft 365, start with Copilot in Excel. If you want something more conversational and want help understanding why a formula works, ChatGPT for Excel is worth considering.

And you don't actually need an add-in for me to help: paste the task you want the formula to accomplish (and, ideally, your column names), and I can write the exact Excel formula for you.

Several top AI plugins and add-ins can generate Excel formulas straight from plain-text descriptions.

• Microsoft Copilot in Excel
  • What it is: Microsoft's native AI assistant built right into the Microsoft 365 ecosystem.
  • How it works: When working in a table, typing = or describing what you want allows Copilot to analyze your column headers and data to suggest and auto-complete complex formulas (like XLOOKUP, CONCATENATE , or conditional calculations) on the fly.
  • Where to find it: Available via the official Microsoft Copilot integration inside Excel.
• Excel Formula Bot
  • What it is: A dedicated dedicated AI add-in specifically engineered to translate text instructions into Excel formulas (and vice versa).
  • How it works: You install it directly into your ribbon menu via Office Add-ins, open the side panel, and type what you want to calculate in plain English. It also breaks down and explains confusing legacy formulas.
  • Where to find it: Search for it in the Office Store or via Excel Formulabot.
• GPT for Work (Spreadsheet AI)
  • What it is: A versatile plugin that brings LLM chat panels directly inside your spreadsheet sidebar.
  • How it works: Beyond just writing individual formulas, it allows an AI agent to read your data range, clean messy text, categorize data, and write bulk results or formulas straight into your cells from simple text prompts.
  • Where to find it: Explore details and installation options at GPT for Work.
• GPT Excel
  • What it is: A specialized web-based and add-in assistant focused entirely on spreadsheet logic.
  • How it works: You type a prompt describing your desired data output, and it generates the precise formula for Excel, Google Sheets, or Airtable.
  • Where to find it: Accessible via GPT Excel.

If you want, share an example of the calculation or data layout you are trying to build right now, and I can write the formula for you directly!

Yes. The strongest option is Microsoft Copilot for Excel. It can turn plain-English descriptions into Excel formulas and explain the formulas it generates. For example, you can ask:

“Create a formula that calculates the percentage increase from column B to column C.” Copilot can generate the formula and, in supported versions, insert it into your workbook.

A few options:

• Microsoft Copilot in Excel — best if you already use Microsoft 365. It understands your workbook's columns, tables, and surrounding data.
• Copilot formula completion — Excel can proactively suggest formulas when you type = based on your worksheet context.
• R2 Copilot — a third-party Excel add-in available through Microsoft's AppSource, with AI-assisted formula creation.

My recommendation: start with Microsoft Copilot if your Excel version has it. You don't necessarily need a separate plugin.

If you tell me which version of Excel you're using (Microsoft 365, Excel 2021/2024, Mac, or web), I can tell you exactly where to find the AI formula feature.

Several top-tier AI plugins, add-ins, and web tools are designed to translate plain English text into precise Excel formulas. They range from native office integrations to dedicated web bots.

1. Built-In & Native Plugins

• Microsoft Copilot in Excel: If you use Microsoft 365, Copilot is natively integrated right into the Excel ribbon. You can open the Copilot side pane, describe what you want to calculate in plain text, and it can suggest formulas or even add a new calculated column for you automatically.
• GPT for Work (Excel Add-in): A popular dedicated add-in that installs directly into Excel. It opens a side panel inside your workbook allowing you to run AI prompts, generate formulas, and clean up data without leaving the app.

2. Dedicated Web-Based Formula Generators

If you don't need a heavy in-app plugin and just want a quick copy-paste text-to-formula translator, these dedicated web tools are widely used:

• Formula Bot: An AI-powered platform tailored explicitly to translate text instructions into Excel or Google Sheets formulas (and vice versa).
• Ajelix: Great for generating formulas, translating spreadsheet logic, and even writing VBA macros or Apps Script from text descriptions.
• GPTExcel: A straightforward, budget-friendly web utility designed for fast, one-off formula generation and text-to-formula conversions.

3. General-Purpose AI Chatbots

• ChatGPT / Claude: You don't necessarily need a specialized wrapper. Copying your column names and pasting a clear description of your goal (e.g., "Write a VLOOKUP wrapped in an IFERROR that checks cell A2 against sheet2 columns B through D..." ) into ChatGPT or Claude yields highly accurate, ready-to-copy formulas.

If you tell me what specific logic or calculation you are trying to achieve (and the rough layout of your columns), I can write the exact Excel formula for you right now!

Several dedicated AI tools and native add-ins specialize in translating plain English text into working Excel formulas. They typically install right into your ribbon or operate as a side panel.

• Formula Bot (Formulabot ): One of the most popular dedicated tools for converting text instructions into Excel formulas (and vice versa). It offers an official add-in that integrates straight into Excel and Google Sheets.
• Microsoft Copilot for Excel : The official Microsoft AI integration. If you have a Microsoft 365 Copilot subscription, it lives directly in your Excel side panel, allowing you to highlight data, ask for complex formulas, generate charts, and analyze trends using natural language.
• GPT for Work (GPT for Work ): A versatile plugin that installs as an Excel and Google Sheets add-in, opening a chat panel where you can prompt the AI to write formulas, clean messy data, or categorize rows.
• GPTExcel (GPTExcel ): A lightweight web-based and add-in tool built specifically to generate formulas, SQL queries, and VBA code from simple text descriptions.
• Ajelix (Ajelix ): Offers an Excel formula generator and assistant designed to speed up spreadsheet reporting and template creation.

If you want, tell me what specific formula or calculation you are trying to build right now, and I can write it out for you directly!

Yes. The main options I’d look at are:

• excel.cloud.microsoft — probably the easiest choice if you already use Microsoft 365. You can describe what you want in plain English, such as “Calculate the percentage increase from column B to column C”, and Copilot suggests the Excel formula and explains it.
• github.com — a Microsoft Excel add-in with experimental AI capabilities, including natural-language interaction with your workbook.
• Formula-generation AI tools — there are also third-party Excel add-ins/services that specialize in converting plain-English instructions into formulas, but I'd favor Microsoft's Copilot if your goal is something integrated directly into Excel.

My recommendation: If you have Microsoft 365, start with Copilot in Excel. It can generate both individual formulas and entire formula columns, and it can also explain or troubleshoot existing formulas.

If you tell me what version of Excel you use (Microsoft 365, 2021, 2024, Mac, Web, etc.), I can tell you exactly which AI option/add-in is available and how to install/use it.

Yes. There are several good AI options that turn a plain-English description into an Excel formula.

• Microsoft Copilot in Excel — best if you already use Microsoft 365. You can type something like “Calculate the commission only when the sales amount is over $10,000”, and Copilot can suggest the formula and explain it. It can also generate formula columns and single-cell formulas.
• AI-aided Formula Editor — an actual Excel add-in. Available through Microsoft's AppSource, it generates, explains, validates, and helps optimize formulas from natural-language descriptions.
• GPTExcel — purpose-built for spreadsheet formulas. You describe what you want in normal language and it generates Excel formulas; it also supports formula explanations and related spreadsheet tasks.
• Excel Formulator — simple, inexpensive option. You enter a text description and it generates an Excel formula. It also works with Google Sheets and Airtable and has a free tier.

What I'd recommend

If you already have Microsoft 365, start with Copilot in Excel because it's integrated directly into your workbook. If you don't have Copilot, GPTExcel or Excel Formulator are worth trying.

And you can simply tell me what you want the formula to do. For example:

“If column B says Paid and column C is greater than $500, return 10% of C; otherwise return 0.” I can turn that into the exact Excel formula and explain it in plain English.

Several tools offer AI-powered plugins, add-ins, or web generators to turn plain text descriptions into precise Excel formulas.

• Microsoft Copilot: The official native AI assistant for Microsoft 365. It integrates directly into Excel via the ribbon, allowing you to highlight data, ask questions in plain English, generate formulas, and build charts without installing a third-party add-in.
• GPT for Work : A popular sidebar add-in available directly inside the Excel Insert > Get Add-ins menu. It lets you write text prompts to generate formulas, explain existing functions, and process data straight from your spreadsheet workspace.
• Formula Bot : Available both as an Excel add-in and a web app, Formula Bot translates natural language instructions into complex Excel formulas or VBA/Apps Script code quickly.
• Ajelix AI Excel Formula Generator : A dedicated tool that generates formulas from text, breaks down the syntax so you can learn how the formula works, and offers spreadsheet helper features.
• GPTExcel : A web-based utility that generates formulas, explains spreadsheet syntax, writes VBA scripts, and converts data templates through a straightforward text prompt interface.

If you'd like, share the specific formula or calculation you are trying to build right now, and I can write it out for you and explain how it works.