> ## Content Index > Fetch the complete content index at: https://www.theaidirectory.com.au/llms.txt > Use this file to discover other available public pages before exploring further. # Formula Bot Review: AI Formula Generator for Excel and Google Sheets - URL: https://www.theaidirectory.com.au/review-formula-bot-australia-2026/ - Published: 2026-10-08T23:00:00.000Z - Updated: 2026-10-09T06:30:09.000Z - Description: Formula Bot converts plain English into Excel and Google Sheets formulas, SQL queries, and basic data analysis. It works — but AI-generated formulas still need checking before they go anywhere near a live report. - Author: Adam - Tags: Data Analysis & BI, AI Reviews, #review **14**/25 ★★★☆☆ Good Formula Bot (USA) Verified 9 Oct 2026 Value for Money**3**/5 Ease of Use**4**/5 Feature Depth**3**/5 Australian Fit**2**/5 Reliability & Support**2**/5 From **A$29**/mo · ex-GST · billed in USD History Edition 2\. Was [14/25, Jun 2026](https://www.theaidirectory.com.au/review-formula-bot-australia-2026-06/) **The gate:** Five stars need 21+ and Australian Fit of at least 4/5. [Skip to the verdict ](#verdict) *Pricing figures updated 6 September 2026: USD prices are converted at the current rate (1 USD ≈ 1.40 AUD, verified 5 September 2026) and shown ex-GST, replacing the retired 1.55 + GST basis. A GST-registered Australian business that supplies its ABN is not charged GST on an imported digital service; other buyers should allow \~10% on top (*[*Methodology*](https://www.theaidirectory.com.au/methodology/)*).* > **Verdict (TL;DR):** Formula Bot is a competent AI formula assistant that translates plain-English requests into spreadsheet formulas, SQL queries, and basic data analysis. It handles common formula tasks quickly and the free tier is enough to evaluate whether it's worth paying for. But AI-generated formulas can be subtly wrong — especially on nested logic or business-specific edge cases — and you should verify every output before it goes near a live financial report or compliance document. Your data is sent to OpenAI and processed in the United States. For Australian small business owners who spend time wrestling with VLOOKUP or SUMIFS, it's a useful time-saver with appropriate caution baked in. > > **Score: 14/25 — ⭐⭐⭐ Good** > > *Last reviewed: 26 June 2026 by Adam.* > > **Earlier editions of this review:** [26 Jun 2026 — 14/25](https://www.theaidirectory.com.au/review-formula-bot-australia-2026-06/). This is edition 2, dated 9 Oct 2026\. We keep every edition so you can see how the tool and our verdict have moved — [how and why](https://www.theaidirectory.com.au/review-timeline/). --- ## What Formula Bot is Formula Bot is an AI-powered formula and data analysis tool built for Microsoft Excel and Google Sheets. You describe what you want to do in plain English — "calculate the percentage change between column B and column C, ignoring blank cells" — and it returns the formula, explains what it does, and gives you a copy-paste version ready to drop into your spreadsheet. Beyond formula generation, Formula Bot has expanded into broader data analysis: you can upload a spreadsheet, ask questions about the data, generate charts, and automate repetitive tasks. The tool works both as a standalone web app and as an add-in for Excel and Google Sheets. The company is US-based. Formula Bot is available globally and marketed as a general productivity tool with no country-specific tier. No Australian entity or data residency. --- ## What it costs in Australia Formula Bot is priced in USD. No AUD billing. All prices converted at approximately AUD 1.40 per USD ex-GST, as applies to digital services sold to Australian consumers. | Plan (Better Analyst, as at 9 Oct 2026) | USD/month (annual rate in brackets) | AUD approx. ex-GST at 1.44 | Key limits | | ---------------------------------------------- | ---------------------------------------------------------------- | -------------------------- | ---------------------------------------------------------------------------- | | Free | $0 | Free | 10 messages/month, 25 AI Actions/month, 5MB uploads | | Starter | $20/month ($14 billed yearly, $168) | \~AUD $29 (\~$20) | 250 messages/month, 2,500 AI Actions, 200MB uploads, premium models | | Max | $40/seat/month ($28, $336 yearly) | \~AUD $58 (\~$40) | Unlimited messages, 5,000 AI Actions a seat, scheduled tasks, Slack agent | | Business | $80/seat/month ($56, $672 yearly) | \~AUD $115 (\~$81) | 15,000 AI Actions a seat, 1GB uploads, white-label embeds, dedicated support | | June / September 2026 editions, for the record | Starter $18; Pro / Max $29/seat; Enterprise $149/seat (estimate) | \~AUD $25 / $41 / $209 | — | Annual billing takes 30% off every paid plan (Starter US$14, Max US$28, Business US$56 a seat a month). Read from betteranalyst.com/docs/billing/pricing-plans on 9 October 2026 on an Australian connection (capture `Dossiers/captures/formula-bot-pricing-2026-10-09.txt`); the home page's pricing cards render only struck-through promotional figures to a scripted read, so the billing documentation is the source. Conversions at US$1 ≈ A$1.44 (ECB reference rate via Frankfurter, 8 October 2026), ex-GST — a GST-registered business that supplies its ABN is not charged GST on an imported digital service; other buyers add about 10%. **Free tier:** 10 messages and 25 AI Actions per month. This is genuinely usable for occasional formula help, though heavy users will hit the ceiling quickly. The add-in for Excel and Google Sheets is accessible on the free plan. --- ## How it works in practice The primary use case is simple: you type what you want your formula to do, and Formula Bot writes it. "Give me a formula that sums column D only where column A says 'Sydney'" returns `=SUMIF (A:A,"Sydney",D:D)` with an explanation of each argument. For standard formulas — SUMIF, VLOOKUP, INDEX/MATCH, COUNTIFS, basic date calculations — this works reliably and fast. It will also generate VBA macros for Excel, Google Apps Script for Sheets, and SQL queries if you paste in a table schema. The data analysis side is more recent. You upload a CSV or Excel file, ask questions in a chat interface, and the tool generates charts, calculates summaries, and provides written commentary. For clean, well-structured datasets, this produces useful results in seconds. Where it breaks down: - Complex nested formulas with multiple conditions across non-contiguous ranges - Business-specific logic that requires understanding your data model, not just your syntax - Edge cases where the AI interprets your prompt ambiguously and generates a formula that looks correct but handles exceptions incorrectly The tool's documentation acknowledges this directly: human review is recommended before using generated formulas in compliance-sensitive reports. That is honest, but it's also a real limitation that should inform how much you rely on it. --- ## What it does well **It handles the common cases well.** SUMIF, VLOOKUP equivalents, conditional formatting rules, basic pivot logic — Formula Bot gets these right the vast majority of the time. For the formulas that take most people the longest to remember, it delivers in seconds. **Explanations are genuinely helpful.** The tool doesn't just output a formula — it explains what each argument does. For someone learning Excel, this has real educational value. **SQL and script generation extend the value.** If you also work with SQL databases or want to automate repetitive Sheets tasks with Apps Script, the same tool covers those use cases. That's meaningful breadth for a single subscription. **The free tier is enough to test properly.** Ten messages a month is modest, but it's enough to run ten real formula requests and judge the output quality before committing to a paid plan. **Data is stored on AWS.** Formula Bot stores user data on Amazon Web Services infrastructure \[per Formula Bot's published security documentation\]. It is not an entirely opaque black box. --- ## What it doesn't do well **AI formulas can be subtly wrong.** This is the most important limitation and it applies across every AI formula tool, not just Formula Bot. The tool can generate a formula that looks correct, passes a quick visual check, and still handles an edge case incorrectly — a blank cell, a text value in a numeric column, a date formatted inconsistently. In a spreadsheet feeding a financial report or tax calculation, one wrong formula is a meaningful risk. Never push an AI-generated formula to production without testing it against your actual data, including edge cases. **Complex nested logic is unreliable.** The more conditions and exceptions you add to a formula request, the more likely Formula Bot is to miss one. For multi-condition, multi-range logic, experienced Excel users will often still write the formula faster themselves. **Usage caps are tight on lower tiers.** Ten free messages a month is not much. The Starter plan's 250 messages should cover moderate use, but a heavy user working on a large spreadsheet project will feel the ceiling. **Your data goes to OpenAI.** Formula Bot shares files and prompts with OpenAI for processing \[per Formula Bot's published privacy documentation\]. OpenAI processes data on US servers. Your uploaded spreadsheet data leaves Australia. This is a real consideration for anyone working with client data, personal information, or commercially sensitive figures. **No Australian billing or support.** Pricing is USD-only, no AUD invoicing, no AU-specific support. Tax invoices may not reflect GST correctly by default — check with your accountant. --- ## Australian fit Formula Bot is a US product with no local presence or Australian data residency. The free tier is functional and the Starter plan at AUD \~$29/month (US$20) is a reasonable price for a tool that saves meaningful spreadsheet time. The data privacy situation is material. Formula Bot's published documentation states that files and inputs are shared with OpenAI, Anthropic, and Google for processing, with agreements in place prohibiting use of that data for model training. Processing occurs on US servers. For Australian users, this means: - Data governed by the Privacy Act 1988 (customer personal information, health data) should not be uploaded - Client-confidential financial data warrants careful consideration before use - Non-sensitive business data (product catalogues, internal planning spreadsheets with no personal data) carries lower risk The tool does not appear to have documented compliance against the Australian Privacy Principles (APPs) in any publicly accessible form (unconfirmed). For small business owners building budget models, analysing marketing data, or handling product inventories — where the data is yours and non-sensitive — Formula Bot is a practical daily tool. For anything touching client data, proceed with caution. **Australian Fit score: 2/5** — USD pricing, data processed offshore, no AU residency, no local compliance documentation. --- ## Alternatives - [**Julius AI**](https://www.theaidirectory.com.au/julius-ai-review-australia-2026/) — conversational data analysis from uploaded files. Goes further than formula generation; better for exploring and querying your data. - [**Hex**](https://www.theaidirectory.com.au/review-hex-australia-2026/) — collaborative data notebook for teams with more technical requirements. Stronger for structured SQL-based analysis. - [**Rows**](https://www.theaidirectory.com.au/review-rows-australia-2026/) — a full AI-native spreadsheet with built-in data connections and automation, rather than an add-on to your existing tool. --- ## Bottom line Formula Bot does what it says — it writes formulas faster than you can. For everyday Excel and Sheets tasks, it reduces friction genuinely. The free tier is honest, the paid tiers are reasonably priced in USD terms, and the explanation feature adds real learning value. The honest caveat: AI-generated formulas need verification. Every time. A formula that looks right can still be wrong in ways that don't surface until you look at an edge case. Build that review step into your workflow before you treat any output as reliable. At AUD \~$29/month for the Starter plan (about A$20 on annual billing), it earns its subscription if it saves you 20 minutes a week on formula writing. Just don't send it your client's payroll data. --- ## Score | Criterion | Score | Notes | | --------------------- | --------- | ------------------------------------------------------------------------------------------------------------------------------------ | | Value for Money | 3/5 | Reasonable USD price (Starter US$20, 30% off yearly), functional free tier, but the seat-priced Max and Business tiers add up in AUD | | Ease of Use | 4/5 | Plain-English interface; explanations aid adoption | | Feature Depth | 3/5 | Strong on formulas and SQL; data analysis is useful but limited | | Australian Fit | 2/5 | USD pricing, data processed via OpenAI in US, no AU residency | | Reliability & Support | 2/5 | Core formula generation solid; complex logic unreliable; support is US-based | | **Total** | **14/25** | **⭐⭐⭐ Good** | --- Update history - **9 Oct 2026** — **New edition: Better Analyst's prices have moved again, and the table is now vendor-read.** Was: Starter US$18, Pro / Max US$29 a seat, Enterprise US$149 a seat (estimate). Now, from `betteranalyst.com/docs/billing/pricing-plans` read on an Australian connection: **Free US$0; Starter US$20 a month (US$14 yearly); Max US$40 a seat (US$28 yearly); Business US$80 a seat (US$56 yearly); annual billing 30% off; the Enterprise estimate withdrawn.** USD only; `aud_native: false` and the 14/25 score stand. Conversions at US$1 = A$1.44 (ECB, 8 Oct 2026), which retires the \~A$31 Starter figure from the old basis. Source: AUD queue #483; capture `Dossiers/captures/formula-bot-pricing-2026-10-09.txt`. The June edition is kept unchanged and linked above. - **26 Jun 2026** — First reviewed. - **21 Sep 2026 — ⚠️ Formula Bot is now** Better Analyst**, and every paid price in the table below has changed.** A citation-rot sweep found `formulabot.com/docs/subscription-plan-limits` returning HTTP 404\. The reason is bigger than the page: **`formulabot.com` now redirects wholesale to `betteranalyst.com`**, whose own page title reads “Better Analyst (formerly Formula Bot)”. This is a rebrand, not a page move — the same shape as the Thriday and Continue findings. The dead docs page has no successor at the new domain; its content now sits in `betteranalyst.com/docs/billing/pricing-plans`, which has been read live. **Checked against that live page, the free tier is unchanged — 10 messages and 25 AI Actions a month, exactly as stated below — but nothing above it is:** Starter is now **US$20/month** (review: US$18) with **2,500 AI Actions** rather than “100 tool credits”; “Pro / Max” is now **Max at US$40/seat/month** (review: US$29) with unlimited messages and 5,000 AI Actions per seat; and the **US$149/seat Enterprise tier in the table no longer exists** — the top published plan is **Business at US$80/seat/month** with 15,000 AI Actions. Annual billing is now advertised at US$14, US$28 and US$56 per month respectively. **The price table, the AUD column, the brand name in the title, the verdict and the meta description have not been touched here.** Rewriting a review around a rebrand and a full price ladder is a re-review, and the Value for Money score (3/5) rests on figures that have moved. Flagged for `aid-score-sync` and queued for a full re-review, including whether this should be listed as Better Analyst. **Also queued:** two other corpus files still name Formula Bot with no notice — `review-gptexcel-australia-2026-06-26.md` and `roundup-best-ai-data-analysis-bi-australia-2026-06-07.md`. No same-day capture — archive.org was returning “Temporarily Offline” and HTTP 429 on 21 September 2026. - **24 Sep 2026** — **1 Australian figure recut to the current basis.** It was converted at about **1.70** — the retired basis — inside a column headed ex-GST whose other rows were already at 1.4045\. Corrected to US$1 = A$1.4045 (Frankfurter/ECB, 18 September 2026): Enterprise \~AUD $253/seat/month inc. GST → \~AUD $209/seat/month inc. GST. **No USD price moved and no score changed.** `reviewed:` untouched per our dating rule. ## Frequently asked questions ### Is Formula Bot free to use in Australia? Formula Bot has a free plan that includes 10 messages and 25 AI Actions per month. This is enough to evaluate the tool and handle occasional formula help. Paid plans start at USD $20/month (approximately AUD $29/month ex-GST, or US$14 a month on annual billing), billed in US dollars; Max is US$40 and Business US$80 a seat a month. ### How accurate are Formula Bot's AI-generated formulas? Formula Bot handles standard formulas — SUMIF, VLOOKUP, COUNTIFS, and similar — reliably for most common requests. Complex nested logic with multiple conditions or business-specific edge cases is less reliable. The tool itself recommends human review before using generated formulas in compliance-sensitive reports, which is sound advice. Always test AI-generated formulas against your actual data before relying on them. ### Does Formula Bot send my spreadsheet data overseas? Yes. Formula Bot shares uploaded files and inputs with OpenAI and other AI providers for processing, under agreements that prohibit using this data for model training. Processing occurs on US servers. Australians handling personal information governed by the Privacy Act 1988 should not upload sensitive client data to the tool. --- ## Sources **Formula Bot is now Better Analyst and `formulabot.com` redirects to `betteranalyst.com` — see Update history, 21 September 2026\. The live links below are the vendor’s current pages under the new brand; the Wayback captures are the June 2026 record this review was written from.** - Product overview: [betteranalyst.com](https://betteranalyst.com/?ref=theaidirectory.com.au) (titled “Better Analyst (formerly Formula Bot)”), re-checked 21 September 2026 — June record, captured under the former domain `https://www.formulabot.com/`: [Wayback 24 June 2026](https://web.archive.org/web/20260624223743/https://www.formulabot.com/) - Pricing documentation: [betteranalyst.com/docs/billing/pricing-plans](https://betteranalyst.com/docs/billing/pricing-plans?ref=theaidirectory.com.au), re-read 9 October 2026 on an Australian connection and the table rebuilt from it (Wayback save queued 9 Oct 2026) — June record, captured under the former domain `https://www.formulabot.com/docs/billing/pricing-plans`: [Wayback 17 April 2026](https://web.archive.org/web/20260417121737/https://www.formulabot.com/docs/billing/pricing-plans) - Security and privacy overview: [betteranalyst.com/docs/security-privacy/overview](https://betteranalyst.com/docs/security-privacy/overview?ref=theaidirectory.com.au) — June record, captured under the former domain `https://www.formulabot.com/docs/security-privacy/overview`: [Wayback 27 July 2026](https://web.archive.org/web/20260727164506/https://www.formulabot.com/docs/security-privacy/overview) - Subscription plan limits: `formulabot.com/docs/subscription-plan-limits` — **HTTP 404 on 21 September 2026; the page does not exist at the new domain either.** Its content is now carried by the pricing-plans doc above. Nearest capture: [Wayback 12 August 2025](https://web.archive.org/web/20250812061733/https://www.formulabot.com/docs/subscription-plan-limits), **ten months before this review — context, not the check this review made.** - Third-party review summary (GetApp): [https://www.getapp.com/all-software/a/formula-bot/](https://www.getapp.com/all-software/a/formula-bot/?ref=theaidirectory.com.au) - AUD/USD conversion rate used: approximately 1.40 (September 2026). Figures are ex-GST: a GST-registered business that supplies its ABN is not charged GST on an imported digital service; other buyers add \~10%. - **Verification notes:** the Enterprise estimate the June edition carried is withdrawn; Business at US$80 a seat is the published top tier, and larger deployments are quoted. Confirm against betteranalyst.com before subscribing. Privacy/data processing claims sourced from Formula Bot's published documentation; confirm these have not changed before publication. --- *The AI Directory Australia is an independent editorial publication. We don't accept payment for positive reviews. Read our* [*Methodology*](https://www.theaidirectory.com.au/methodology/) *and* [*Affiliate Disclosure*](https://www.theaidirectory.com.au/affiliate-disclosure/)*.*