Excel formula generator

Bring your own key — your key and content are never stored or logged

🔑 Add your AI API key to begin

Your key is stored only in this browser (IndexedDB) and is sent only to your chosen provider through our server, which never logs or stores it. Manage all keys in Settings. BYOK & free — you pay the provider directly.

This tool sends your text and key to your chosen AI provider (through our server, which never logs or stores them). It is not on-device — turn to the offline tools for fully local processing.

AI Excel formula generator — describe it, get the formula

Describe a spreadsheet calculation in plain English and get a working Excel or Google Sheets formula with a short explanation. This is a bring-your-own-key AI tool: it works with your Anthropic (Claude) or OpenAI (GPT) API key, which is stored only in this browser and never sent to us to keep. Your text goes to your chosen provider through our server, which never logs or stores your key or your text. It is free — you pay the provider directly for what you use.

How to use it

  1. Add your Anthropic or OpenAI API key in the key bar (it is saved only in this browser).
  2. Paste your text and pick any options.
  3. Press the button — the result comes back from your chosen AI. Copy or Download it.

FAQ

How do I generate an Excel formula?

Describe what you want to calculate (for example, sum column B where column A equals Paid), choose Excel or Sheets and press Generate formula. The AI returns the formula and an explanation.

Is my description kept private?

Your API key lives only in this browser's local storage. Each request sends your text and key to your chosen AI provider through our server, which never logs or stores either. We keep no copy.

Does it work for Google Sheets too?

Yes — switch the target to Google Sheets and the AI adapts function names and syntax accordingly.

Where do I get an API key?

From your provider: Anthropic (console.anthropic.com) for Claude, or OpenAI (platform.openai.com) for GPT. Paste it into the key bar once and it is remembered on this device until you clear it.

Does it cost anything?

The tool is free. You pay your AI provider directly for the tokens each request uses — usually a fraction of a cent for short text.

Limits

Check the cell references match your sheet before relying on the formula. Unlike our offline tools, this one calls a cloud AI, so it needs a connection and your own key.

Related

Convert a table with the CSV tools, or clean data first with the CSV cleaner.

Your key stays in this browser. Clear it any time from the key bar.