Task · Data analysis

Write an Excel or Sheets formula: our pick and two alternatives

The AI tool we’d start with for this job, two alternatives, and why each one fits.

Best pick

Formula Bot

Purpose-built formula generator and explainer.

Freemium · Writing Excel/Google Sheets formulas from plain English

Visit Formula Bot ↗ About Formula Bot

Alternative

Microsoft Copilot

Copilot works inside Excel.

Freemium · AI help inside Word, Excel, PowerPoint, Outlook and Teams

Visit Microsoft Copilot ↗ About Microsoft Copilot

Alternative

Google Gemini

Works inside Google Sheets.

Freemium · Everyday help if you live in Google Workspace (Gmail, Docs, Drive)

Visit Google Gemini ↗ About Google Gemini

Describe your own version of this task in the recommender. It also matches words like: formula, excel formula, vlookup, xlookup, google sheets, sheets, macro.

Pricing models are taken from each tool’s own website and dated on its tool page. Prices change: check before you buy.

Other data analysis tasks

All data analysis tools →

Analyse a spreadsheet or make charts Query a database / SQL

AI Tool Audit

Want a pick for every task in your business? List the jobs that eat your week and get a written report with a fit-for-purpose tool for each one. No calls.

See the AI Tool Audit