Best AI Excel Formula Generators in 2026

This page ranks AI Excel formula generators in 2026. The question is which tool to use when you need the formula: where that formula is written, and what you pay. A generator here turns a plain-language request into an Excel formula. Some write it in the open workbook. Others return text you copy into a cell. The six tools are ordered that way. Elyx is first because it is an agent inside Excel. You describe the result, and it applies the formula in the file, with the steps around it when the task needs them. It is not a formula-only box. There is no score. Where a vendor does not publish one price we can cite, the price line says so. This page does not invent a number. It is not the Elyx product page, which describes Elyx alone. It is not the ranking of every AI tool for Excel, which also covers cleanup, charts, and Google Sheets. It is not a tutorial for one function. The blog guide shows formula examples. The free generator on this site returns one formula to copy, with no account. The formula explainer does the opposite: you paste a formula you already have.

Elyx on its own, including a formula written in the cell, is on the Excel AI formula generator page. This page compares generators.

1. Elyx

   Elyx is an AI agent that works in the Excel file. You describe the result in plain language. Elyx applies it in the workbook, including the formula. The formula is not a chat answer you paste back. Elyx can also do the steps around that formula, such as cleanup, a pivot table, a chart, or formatting, when the task needs them. On this list it is an agent that writes formulas, not a formula-only website.

   Strengths

   • The formula is written in the open workbook.
   • One instruction can include the formula and the steps around it.
   • You stay in Excel. There is no separate tab to copy from.

   Limit. There is no permanent free plan. When the 7 days end, Elyx is blocked until you subscribe. Elyx does not run in Google Sheets. If you only want one formula to copy, with no account, use the free generator linked below. That is a different page.

   Price. 7-day trial, no card. Then Plus at €12/month or Pro at €29/month.

   Start the 7-day trialSee Plus and Pro

2. Microsoft Copilot

   Copilot in Excel can generate a formula from a description when your license includes it. It can also create charts and PivotTables, apply formatting, and change the sheet. For a formula, it works in the workbook, not as a website you paste from. It is Microsoft’s assistant, not a formula-only product.

   Strengths

   • The formula can be created in Excel when the license includes Copilot.
   • It can edit the workbook, not only suggest text to paste.
   • The same Copilot also sits in other Microsoft 365 apps.

   Limit. Copilot in Excel needs an eligible Microsoft 365 or Copilot license. What you can do depends on that plan, and on your organization’s settings for a work account.

   Price. Included with an eligible Microsoft 365 or Copilot license. The amount depends on the plan.

3. Ajelix

   Ajelix is an Excel add-in that generates and explains formulas and VBA from a sidebar in the workbook. You can install it in Excel, including from Microsoft AppSource. The result is a formula or a script, with an explanation, rather than a full workbook rebuilt from one instruction.

   Strengths

   • The generator sits in Excel, not in a separate browser tab.
   • It explains the formula or the script it returns.
   • A free offer is enough to try the generator.

   Limit. It is aimed at formulas and scripts. Heavy use of the generators requires a paid plan. It does not replace an agent that carries out the rest of the sheet.

   Price. Free offer and paid plans.

4. Formula Bot

   Formula Bot turns a plain-language description into an Excel formula. It can also look at a spreadsheet you provide, and it explains the formula it returns. You use it when you know the result and not the function name.

   Strengths

   • The job is the formula, not a general chat about the file.
   • The explanation helps you check the formula before you trust it.
   • It covers a single formula and a broader look at a file you provide.

   Limit. The free offer is capped. You copy the formula back into Excel. It does not replace an agent that already lives in the workbook.

   Price. Free offer and paid plans.

5. GPTExcel

   GPTExcel generates Excel formulas, and scripts such as VBA or SQL, from a text prompt in the browser. The scope stays on that formula or script. You do not install an add-in to use it.

   Strengths

   • You ask for a formula or a script, not for a whole report.
   • It runs in the browser, with no add-in to install.
   • A free offer exists alongside paid plans.

   Limit. You copy the formula or the script back into Excel. It does not edit the open workbook by itself.

   Price. Free offer and paid plans.

6. ChatGPT

   ChatGPT can return an Excel formula from a description. You can also upload a spreadsheet (.xlsx, .xls, or .csv) for analysis, and OpenAI offers ChatGPT in a sidebar inside Excel. On this page it counts only as a way to obtain a formula. A comparison of chatbots for workbook work is a different page, linked below.

   Strengths

   • Spreadsheet upload and data analysis are available on the free plan, with limits.
   • The Excel sidebar can answer questions about the open file and apply updates.
   • Paid plans raise the usage limits.

   Limit. Spreadsheet chats stay separate from your main ChatGPT history. OpenAI says VBA and macros may not be fully supported. Review every change before you rely on it.

   Price. Free offer and paid plans.

Where the formula lands

Questions

Other pages, other questions

• The best AI tools for Excel in 2026
• Best AI VBA code generators in 2026
• ChatGPT, Gemini and Claude alternatives for Excel in 2026
• Excel add-ins in 2026, beyond formula generators
• Guide to AI Excel formula generators, with formula examples
• Free Excel formula generator: one formula to copy, no account
• Excel formula explainer: paste a formula you already have
• Elyx, the AI for Excel