Trusted by 99,000+ users
Generate Excel formulas
in plain English.
Stop wrestling with VLOOKUP. Describe what you need in plain English — formulas, scripts, regex, campaign attribution, data analysis — and Formulas HQ writes it, explains it, and teaches you along the way.
No credit card required · Free plan available
Your prompt
Sum all values in column B where column A equals 'Marketing'
Formula
=SUMIFS(B:B, A:A, "Marketing")See it in action.
Watch how FormulasHQ turns plain English into formulas, code, and answers — in about a minute.
Trusted by 99,000+ accountants, analysts, Salesforce admins, and business owners worldwide.
One AI toolkit. Every formula, script, and analysis.
From Excel formulas to Salesforce campaign attribution — describe what you need in plain English and let AI handle the rest.
Excel & Google Sheets Formulas
Describe your calculation in plain English. Get the exact formula with a step-by-step explanation, examples, and warnings — ready to paste into your spreadsheet.
- •Generate or explain formulas for Excel 2021 and Google Sheets
- •Structured output: formula, summary, steps, examples, warnings
- •Status badges: "Ready to use" / "Review suggested" / "Action required"
Sum all values in column B where column A equals 'Marketing'
=SUMIFS(B:B, A:A, "Marketing")This formula uses SUMIFS to add values in column B, filtered by…
Salesforce Campaign Attribution
Upload your Salesforce report exports and get full campaign attribution analysis — official vs. inferred attribution, data quality checks, and AI-powered strategic recommendations.
- •Upload up to 7 Salesforce object types
- •Official & inferred attribution with gap analysis
- •AI-generated campaign insights and recommendations
- •All analysis runs in-browser — data never leaves your machine
Data Wizard
Upload CSV files, transform your data with filters, joins, and pivots, then ask questions in plain English. SQL-powered analysis runs entirely in your browser.
- •Three-step flow: Upload → Transform → Analyze
- •Natural language to SQL generation
- •AI-powered insights with chart rendering
- •All processing happens locally via DuckDB
AI Chat with Data Analysis
Multi-turn AI conversations with file upload support. Attach CSV or Excel files and get AI-powered analysis, visualizations, and follow-up recommendations.
- •Persistent conversation history with search
- •Upload CSV/XLSX files for grounded analysis
- •AI-generated charts, tables, and visualizations
- •Suggested follow-up analysis actions
VBA & Apps Script Generator
Generate production-ready VBA macros and Google Apps Script from plain English descriptions. No programming knowledge required.
- •Generate or explain VBA code and Google Apps Script
- •Proper syntax with error handling included
- •Step-by-step explanations for learning
Python Code Generator
Generate, debug, and explain Python code with support for 20+ libraries including pandas, NumPy, scikit-learn, matplotlib, PyTorch, and TensorFlow.
- •Generate, debug, or explain Python code
- •20 library options from data science to web dev
- •PEP 8 compliant output with error handling
Regular Expressions
Generate and understand regex patterns instantly. Describe your pattern in English, get a working expression with a full breakdown.
- •Generate or explain regex patterns
- •Supports named capture groups, lookaheads
- •Perfect for data validation and text extraction
Website Content Analyzer
Enter a URL, crawl the sitemap, and run AI-powered content analysis at scale. Get scoring, trends, entity extraction, and exportable reports.
- •Automatic sitemap discovery and page crawling
- •AI extraction: summaries, themes, scores
- •Export to CSV, XLSX, or JSON
How-To Guides
Step-by-step guides for Excel, Sheets, and Salesforce tasks with difficulty level and time estimates.
Salesforce Formulas
Generate Salesforce formula fields, validation rules, and workflow criteria.
Multi-Language
Use all tools in English, Spanish, French, Turkish, and Hindi.
Generation History
Searchable history of every formula, script, and analysis you've generated.
Embeddable Widgets
Free formula and regex generators you can embed on your own website.
Three steps. Any formula.
Describe
Tell us what you need in plain English. No syntax knowledge required.
Generate
AI creates your formula, script, or analysis with a full explanation.
Use
Copy the result, learn from the explanation, and get back to work.
Try it yourself.
Simple, transparent pricing.
Start free. Upgrade when you're ready.
Free
- 5 generations per month
- Excel & Google Sheets formulas
- VBA & Apps Script
- Regex generation
- Salesforce formulas
- How-To guides
- Generation history
Pro
Most popularbilled yearly
- Unlimited generations across all tools
- Everything in Free, plus:
- AI Chat with file upload
- Data Wizard (CSV analysis)
- Python code generation
- Campaign Intel (Salesforce attribution)
- Priority support
Analyzer
billed yearly
- Everything in Pro, plus:
- Content Analyzer (10 sites / 200 pages)
- Scaled content analysis with AI scoring
- Sitemap crawling and entity extraction
- Export to CSV, XLSX, JSON
- Email notifications on completion
No credit card required to start. Non-profit and education discounts available.
What our users say.
Jonathan Hua
Formulas HQ helped me generate formulas for my specific problem. It's like the Help feature in Excel but better. The formula How-to section is the most useful. This helps my productivity by allowing me to solve my Excel issues quickly. I do recommend Formulas HQ to others who are trying to organize and summarize data.
Hernane Bini
O Fórmulas HQ me ajuda na elaboração e revisão das planilhas de controle de produção e entrega de materiais, com ele complementei as planilhas com fórmulas que deram excelentes resultados através da otimização das atividades executadas por ela. Já encaminhei o link de recomendação para vários amigos e recomendo muito.
Frequently asked questions.
From the blog
See all articles →Although not used very often on this site you might find yourself in a situation where you want to use the Do Until Loop in Excel VBA. Code placed between Do Until and Loop will be repeated until the part after Do Until is true.
Read more →This example shows you how to count blank and nonblank cells in Excel.
Read more →Use the Quick Analysis tool in Excel to quickly analyze your data. Calculate totals quickly insert tables, apply conditional formatting, and more.
Read more →Ready to work smarter?
Join 99,000+ professionals who generate formulas in seconds instead of hours.
Free forever plan available. No credit card required.