Free trial
A free plan is available with no credit card required, and the Pro tier is entered through a start free trial link on the pricing section.
Learn moreFormulas HQ
Turn plain English into working spreadsheet formulas, scripts and analysis.
Beginner
What is Formulas HQ?
Formulas HQ is an AI spreadsheet generator tool that turns plain English into working spreadsheet formulas, scripts and analysis. Formulas HQ generates Excel and Google Sheets formulas, VBA, Apps Script, Python and regex from plain English descriptions, each with an explanation.
Formulas HQ is a web toolkit that converts plain English descriptions into working spreadsheet formulas, with a structured explanation attached to every result. A user types something like "sum all values in column B where column A equals Marketing" and receives the finished formula plus a summary, step-by-step logic, worked examples and warnings about edge cases. Output covers both Excel 2021 and Google Sheets, and each result carries a status badge (Ready to use, Review suggested, or Action required) so a user can judge at a glance how much checking the formula needs before it goes into a live workbook. The formula generator is the headline tool, but the catalogue is broader. VBA and Google Apps Script generation sits alongside a Python generator with twenty library options spanning pandas and NumPy to PyTorch, plus regex building and Salesforce formula fields, validation rules and workflow criteria. Two newer modules push beyond code: Data Wizard takes CSV uploads through a three-step upload, transform and analyze flow with natural language to SQL and chart rendering, while Campaign Intel ingests up to seven Salesforce object types to produce official versus inferred campaign attribution with data quality checks and AI recommendations. Both run processing in the browser rather than on a server. The product suits accountants, financial analysts, Salesforce administrators, operations staff and small business owners who work in spreadsheets regularly but do not keep function syntax in their heads. It is less a replacement for Excel than a replacement for the help documentation and forum searching that usually surrounds a stuck formula. The free tier is deliberately narrow at five generations per month, which is enough to test accuracy on real problems but not enough for daily use, so most regular users will land on Pro. Elsewhere the site publishes how-to guides on Excel, Sheets and Salesforce tasks with difficulty levels and time estimates, and offers embeddable formula and regex widgets. The interface is available in English, Spanish, French, Turkish and Hindi.
How do you use Formulas HQ?
1Create a free account
Sign up at the Formulas HQ app with no credit card required. The free plan gives you 5 generations per month across the core formula and script tools.2Describe the calculation in plain English
Open the formula tool and type what you need in ordinary language, for example summing column B where column A equals Marketing. No function syntax is needed at this stage.3Read the generated formula and its explanation
Each result includes the formula itself, a summary, step-by-step logic, examples and any warnings. Check the status badge before pasting anything into a live workbook.4Copy the result into your spreadsheet
Paste the formula into Excel 2021 or Google Sheets and confirm it returns the expected values on a small sample before applying it to the full range.5Try the adjacent tools
The same prompt style works for VBA macros, Apps Script, Python, regex and Salesforce formulas. Data Wizard adds CSV upload, transform and analyze steps for larger datasets.6Use the how-to guides for background
The blog carries step-by-step Excel, Sheets and Salesforce walkthroughs with difficulty levels and time estimates, useful when a formula needs context rather than just syntax.
Pros and cons
Pros
- Every generated formula ships with a summary, step-by-step explanation, examples and warnings, which doubles as a learning aidAI
- Covers Excel 2021, Google Sheets, VBA, Apps Script, Python, regex and Salesforce formulas inside one subscriptionAI
- Data Wizard and Campaign Intel process files locally in the browser, so raw data is not uploaded to a serverAI
- Status badges (Ready to use, Review suggested, Action required) give an honest signal of how much verification a result needsAI
- Interface is available in five languages, including Spanish, French, Turkish and HindiAI
Cons
- The free plan allows only 5 generations per month, which is too few to judge reliability on real workloadsAI
- No native Excel or Sheets add-in is described, so results have to be copied across manuallyAI
- The catalog is wide but shallow in places: Python help tops out at code generation and explanation with no execution environmentAI
- Content Analyzer, the tool behind the $21.24 tier, is a different job from formula work and inflates the top plan for spreadsheet usersAI
- Only 3 reviews are shown on the homepage, which is thin social proof for a claimed 99,000+ user baseAI
How much does Formulas HQ cost?
Pricing
Free at $0 with 5 generations per month. Pro is $4.33 per month billed yearly and adds unlimited generations, AI Chat with file upload, Data Wizard, Python generation, Campaign Intel and priority support. Analyzer is $21.24 per month billed yearly and adds scaled content analysis. Yearly billing saves 33%. No credit card required to start.
Learn moreSupport
Priority support is listed as a Pro feature. Non-profit and education discounts are available, but no separate help centre or documentation portal is linked from the homepage.
Integrations
Works with Excel 2021 and Google Sheets, and accepts CSV and XLSX uploads for chat and Data Wizard analysis. Salesforce users can import report exports across up to seven object types for campaign attribution.
Features
Eight tools under one account: Excel and Google Sheets formula generation with explanations, VBA and Apps Script generation, Python code generation across 20+ libraries, regex building, Salesforce formulas and validation rules, Data Wizard for local CSV analysis, AI Chat with CSV/XLSX uploads, and Campaign Intel for Salesforce attribution. Generation history is searchable, and the site also publishes how-to guides and embeddable formula and regex widgets.
Frequently asked questions about Formulas HQ
How much does Formulas HQ cost?
Free at $0 with 5 generations per month. Pro is $4.33 per month billed yearly and adds unlimited generations, AI Chat with file upload, Data Wizard, Python generation, Campaign Intel and priority support. Analyzer is $21.24 per month billed yearly and adds scaled content analysis. Yearly billing saves 33%. No credit card required to start.Does Formulas HQ offer a free trial?
A free plan is available with no credit card required, and the Pro tier is entered through a start free trial link on the pricing section.How do you use Formulas HQ?
The walkthrough on this page covers 6 steps: 1. Create a free account 2. Describe the calculation in plain English 3. Read the generated formula and its explanation 4. Copy the result into your spreadsheet 5. Try the adjacent tools 6. Use the how-to guides for background.What platforms does Formulas HQ support?
Formulas HQ is available on Web App.What does Formulas HQ integrate with?
Works with Excel 2021 and Google Sheets, and accepts CSV and XLSX uploads for chat and Data Wizard analysis. Salesforce users can import report exports across up to seven object types for campaign attribution.What are the limitations of Formulas HQ?
The free plan allows only 5 generations per month, which is too few to judge reliability on real workloads. No native Excel or Sheets add-in is described, so results have to be copied across manually. The catalog is wide but shallow in places: Python help tops out at code generation and explanation with no execution environment.
Status
StatusActive
Views0
Outbound clicks0
Added10/21/2026
Platforms
Web App
Pricing
FreeFreemiumSubscription
