FormulasHQ

FormulasHQ lets users describe a calculation or task in plain English and returns the formula, script, or analysis along with an explanation. Supported outputs on the page include Excel and Google Sheets formulas (with structured output of formula, summary, steps, examples, and warnings), VBA and Google Apps Script, Python code, regular expressions, and Salesforce formula fields, validation rules, and workflow criteria. The page also describes data tools such as Salesforce campaign attribution analysis, a Data Wizard for CSV files using in-browser SQL via DuckDB, AI chat with CSV/XLSX file analysis, and a Website Content Analyzer that crawls sitemaps. The site states it is trusted by 99,000+ users, offers a free plan with 5 generations per month, and lists Pro and Analyzer paid tiers.

Key features

• Generate Excel and Google Sheets formulas from plain English with explanations
• Structured formula output including summary, steps, examples, and warnings
• VBA and Google Apps Script generation with error handling and step-by-step explanations
• Python code generation, debugging, and explanation with 20+ library options
• Regular expression generation and explanation
• Salesforce formula field, validation rule, and workflow criteria generation
• Salesforce campaign attribution analysis from uploaded report exports
• Data Wizard for uploading CSV files, transforming data, and asking questions in plain English
• AI chat with CSV/XLSX file upload and generated charts and tables
• Website Content Analyzer with sitemap crawling and exportable reports
• How-To Guides for Excel, Sheets, and Salesforce tasks
• Multi-language support in English, Spanish, French, Turkish, and Hindi
• Searchable generation history
• Embeddable free formula and regex generator widgets

Best suited for

• Excel and Google Sheets users who need formulas without syntax knowledge
• Accountants, analysts, and business owners working with spreadsheets
• Salesforce admins creating formula fields and validation rules
• Marketers analyzing Salesforce campaign attribution data
• Users learning VBA, Apps Script, Python, or regex

Pricing

Free plan at $0.00/month with 5 generations per month; Pro at $4.33/month billed yearly (unlimited generations); Analyzer at $21.24/month billed yearly. Monthly billing options are also referenced. Non-profit and education discounts are mentioned.