Question: I need a platform that can generate Excel formulas and Regex expressions from natural language prompts.

ManyExcel is an AI tool that can help you work more efficiently in Excel and Google Sheets. It features an AI Formula Generator that turns plain text into complex formulas with explanations, an AI Regex Generator that creates regular expressions, and an AI Script Generator for automating tasks. The tool also includes a Data Analysis Tool for extracting insights and generating interactive charts. It offers a free plan with limited use and a Pro plan for $5/month.

Another excellent option is Formula Bot. This platform uses AI to translate text into various outputs, including Excel formulas, SQL queries, VBA scripts, and Google Apps Scripts. It offers a range of tools like an Excel Formula Generator, SQL Query Generator, and a Data Analyzer that allows you to ask natural language questions to analyze data. Formula Bot also automates spreadsheet tasks and supports various data sources, making it a versatile choice for data analysis.

For those interested in automating SQL queries, TEXT2SQL is a powerful tool that converts plain English into SQL queries. It supports multiple SQL dialects and can also generate Excel formulas and Regex expressions. The service offers a 7-day free trial and various pricing plans, including a monthly plan for $7 and an annual plan for $29.

Lastly, FormulaGenerator uses fine-tuned GPT models to generate Excel formulas, VBA automations, and SQL queries. It offers a web app and a Google Sheets extension, with a free tier and a Premium Membership available for $4.99/month. This tool is particularly useful for those who need to correct errors in formulas and code, as well as create custom AI applications for their specific needs.