Data & Spreadsheets
FormulasHQ
Generate Excel, Google Sheets, VBA, Python, and regex from plain English
FormulasHQ is an AI toolkit that turns plain-English descriptions into Excel/Google Sheets formulas, VBA and Apps Script macros, Python code, regular expressions, and Salesforce formulas — each with a full explanation, examples, and warnings rather than just the raw output. It also includes a Data Wizard for uploading and querying CSV files with natural language (via in-browser SQL/DuckDB), an AI chat that analyzes uploaded CSV/Excel files, a Salesforce Campaign Attribution tool for analyzing exported reports, and a Website Content Analyzer that crawls a sitemap for AI-scored content analysis.
- Best for
- Accountants, analysts, Salesforce admins, and business owners who need a correct formula, script, or regex fast without memorizing syntax, and want to understand and learn from the explanation rather than just copy-paste a black box.
- Pricing
- Free ($0/mo, 5 generations/month, formulas/VBA/regex/Salesforce formulas); Pro $4.33/mo billed yearly (unlimited generations, AI chat with file upload, Data Wizard, Python, Salesforce Campaign Attribution); Analyzer $21.24/mo billed yearly (adds Website Content Analyzer, 10 sites/200 pages)
Core features
- • Excel & Google Sheets formula generator with explanations
- • VBA and Google Apps Script generator
- • Python code generator (20+ libraries)
- • Regex generator with breakdowns
- • Salesforce formulas, validation rules, workflow criteria
- • Salesforce Campaign Attribution analysis
- • Data Wizard: CSV upload, transform, natural-language SQL analysis
- • AI chat with CSV/Excel file upload and visualizations
- • Website Content Analyzer (sitemap crawl + AI scoring)
- • Multi-language support (English, Spanish, French, Turkish, Hindi)
Use cases
- 1. Turn a plain-English description into a working Excel or Google Sheets formula
- 2. Generate a VBA macro or Google Apps Script without knowing the syntax
- 3. Analyze a CSV file by asking questions in natural language
- 4. Debug or generate Python code across data science and web libraries
- 5. Run Salesforce campaign attribution analysis from exported reports
How to use
Describe what you need in plain English — a formula, script, regex pattern, or data question — and FormulasHQ generates the result with a step-by-step explanation, examples, and warnings; for data analysis, upload a CSV or Excel file first and ask questions in the chat.
Pricing plans
Free
$0/mo
- • 5 generations per month
- • Excel & Google Sheets formulas
- • VBA & Apps Script, regex generation
- • Salesforce formulas, 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)
Analyzer
$21.24/mo billed yearly
- • Everything in Pro
- • Content Analyzer (10 sites / 200 pages)
- • Sitemap crawling and entity extraction
- • Export to CSV, XLSX, JSON
Where it holds up
- Explains every formula/script with steps, examples, and warnings instead of just the raw output
- Covers 8 tools (formulas, VBA, Python, regex, Salesforce, data analysis) in one subscription
- Data Wizard and file analysis run in-browser — data never leaves the user's machine
- Free plan available with no credit card required
Where it falls short
- Free plan is capped at just 5 generations per month
- Advanced tools (Python, Data Wizard, Salesforce attribution) require the Pro tier
- Website Content Analyzer at scale requires the pricier Analyzer plan
This link may be an affiliate link — see our disclosure.