F
Productivity
Generate Excel and Google Sheets formulas in plain English
Excel AISpreadsheet FormulasData Analysis
FormulasHQ is an AI toolkit that turns plain-English descriptions into Excel/Google Sheets formulas, VBA and Apps Script code, regex patterns, Salesforce formulas, and Python code — each with a step-by-step explanation. It also includes a Data Wizard for CSV analysis, AI chat with file upload, and a Salesforce Campaign Attribution analyzer, all aimed at accountants, analysts, and business owners who don't want to hand-write formulas or code.
- Best for
- Accountants, analysts, Salesforce admins, and business owners who need correct spreadsheet formulas, scripts, or data analysis without memorizing syntax.
- Pricing
- Free forever plan with 5 generations/month, no credit card required. Pro is $4.33/mo (billed yearly) for unlimited generations, and Analyzer is $21.24/mo (billed yearly) for large-scale content analysis. Use code NHAN at checkout for a discount on paid plans.
Core features
- • Excel & Google Sheets formula generation and explanation
- • VBA and Google Apps Script code generator
- • Python code generator with 20+ library support (pandas, NumPy, scikit-learn, PyTorch, etc.)
- • Regex pattern generator with breakdowns
- • Salesforce formula fields, validation rules, and workflow criteria generator
- • Salesforce Campaign Attribution analysis from report exports
- • Data Wizard: CSV upload, transform, and natural-language-to-SQL analysis
- • AI chat with CSV/Excel file upload for grounded data analysis
- • Website Content Analyzer with sitemap crawling and AI scoring
Use cases
- 1. Writing a complex Excel/Sheets formula from a plain-English description
- 2. Generating VBA macros or Google Apps Script without learning the syntax
- 3. Analyzing a CSV file and asking questions about it in plain English
- 4. Building Salesforce campaign attribution reports and validation rules
- 5. Generating and understanding regex patterns for data validation
How to use
Describe what you need in plain English — a formula, script, regex pattern, or data question — and FormulasHQ generates it along with a step-by-step explanation. For data analysis, upload a CSV or Salesforce export to the Data Wizard or Campaign Intel tool and ask questions in plain language to get AI-powered insights. When upgrading to a paid plan, enter code NHAN at checkout for a discount.
Pricing plans
Free
$0/mo
- • 5 generations per month
- • Excel & Google Sheets formulas
- • VBA & Apps Script, regex generation
- • Salesforce formulas, How-To guides
- • Generation history
Pro
$4.33/mo (billed yearly)
- • Unlimited generations across all tools
- • AI Chat with file upload
- • Data Wizard (CSV analysis)
- • Python code generation
- • Campaign Intel (Salesforce attribution)
- • Priority support
Analyzer
$21.24/mo (billed yearly)
- • Everything in Pro
- • Content Analyzer (10 sites / 200 pages)
- • Scaled content analysis with AI scoring
- • Sitemap crawling and entity extraction
- • Export to CSV, XLSX, JSON
FAQ
Is there a free plan?
Yes — FormulasHQ has a free forever plan with 5 generations per month across its tools, no credit card required.
What tools are included?
Excel/Sheets formulas, VBA & Apps Script, Python code, regex, Salesforce formulas, Salesforce Campaign Attribution, Data Wizard (CSV analysis), and AI chat with file upload.
Can I analyze my own data files?
Yes — the Data Wizard lets you upload CSV files and transform/analyze them with natural language, and AI Chat supports uploading CSV/Excel files for grounded analysis.
Is there a discount code for FormulasHQ?
Yes — use code NHAN at checkout for a discount on the Pro or Analyzer plans.
Where it holds up
- Covers 8 tools in one place: Excel/Sheets formulas, VBA/Apps Script, Python, regex, Salesforce formulas, and data analysis
- Every generated formula or script comes with a plain-English explanation and step-by-step breakdown
- Data Wizard and Content Analyzer run processing locally/in-browser, so data doesn't need to leave your machine
- Genuinely free forever plan with 5 generations/month, no credit card required
- Salesforce Campaign Attribution tool gives official vs. inferred attribution with AI recommendations
Where it falls short
- Free plan is capped at just 5 generations per month
- Advanced features (AI chat, Data Wizard, Python, Campaign Intel) require the Pro plan
- Website Content Analyzer is a separate, pricier tier on top of Pro
