Question: Is there a tool that can automatically generate Excel formulas from written instructions?

FormulaGenerator is an AI tool that can generate Excel formulas, VBA automations and SQL queries from text prompts. It can also spot and fix errors in formulas and code, explain how it generated formulas, and generate VBA code and SQL queries. FormulaGenerator is available as a web app and a Google Sheets extension, and a free tier offers 10 requests per month. A Premium Membership costs $4.99 per month.

Another option is Formula Bot, which uses AI to convert text prompts into a variety of formats, including Excel formulas and SQL queries. It also includes a Text to Excel Converter and a Data Analyzer that lets you ask natural language questions to analyze data. Formula Bot has a variety of pricing options, including a free plan, so you can use it and adapt it to your needs.

If you prefer a Chrome extension, AI Excel Bot is a powerful tool that uses GPT-3 to convert English text prompts into complex Excel formulas. It works with both Excel and Google Sheets, and offers several pricing options, including a free plan with limited use. The tool is designed to free up your time and effort by automating spreadsheet work.

Last, Sheeter offers a query-based interface to generate Excel formulas. It supports a broad range of formulas and works with both Excel and Google Sheets. With customizable plans and a 14-day money-back guarantee, Sheeter is a flexible option for boosting productivity and saving time.