Excel formula generator

Generate Excel formulas from plain English

Describe what a column should show and the assistant writes the formula straight into the cell of your own .xlsx. It runs in the browser, with nothing to install.

Try it on your sheet See an example

Applied straight to your sheet
Recalculates against your data
Free plan, no card

Simulated example. One request becomes a standard IF formula, applied to D2:D6 and calculated against the due dates already in the sheet. It sits in the formula bar like anything you would type, and stays a live formula in the exported file.

From a sentence to a working formula

Ask in your own words

A total per region, a margin column, a flag for overdue rows: say what you want and where it should go.

Get a real formula

The assistant applies a standard Excel formula to the range. It sits in the formula bar like anything you would type, so you can read it, tweak it or copy it.

See it recalculate

The result appears in the grid immediately and updates as your data changes, so you can tell whether it makes sense before you rely on it.

Keep it in the file

Standard formulas survive export and stay live in the .xlsx, so they keep recalculating when the file is opened in Excel.

When the formula is wrong

The assistant is a language model and can pick the wrong approach. Every formula it applies is logged with the exact range it touched, the result is right there in the grid to check, and a whole run can be reverted in one click. What revert restores, and known failure modes.

When there is no formula for it

Some column logic is judgment rather than arithmetic: categorizing free-text expenses, tidying names, pulling a city out of a messy address. For those there is =AI(), a worksheet function that takes a prompt and the cells to look at and returns one value per cell. Fill it down like any formula; a result stays put until its inputs change or you refresh it.

Unlike the standard formulas above, =AI() only exists in Kantaja. When you export, an =AI() cell is written as the value it last computed, not a live formula, so the file opens clean in Excel instead of breaking with an error.

All of it happens in a full online Excel editor, so you can always step in and edit by hand.

See the example above

Questions about formulas

Is the formula generator free?

Yes. Formula requests use AI credits and the free plan includes 4 a day with no card. The editor itself is unmetered, so checking and adjusting the result costs nothing. Compare plans.

Do I need to know Excel functions?

No. Describe the outcome and the assistant picks the function. The formula stays visible in the formula bar, so you can see exactly what it did and learn from it if you want.

Does it work on my existing spreadsheet?

Yes. Open your .xlsx, ask against the columns you already have, and export when you are done. The formulas stay live in the exported file.

What if it writes the wrong formula?

It can happen. The result shows in the grid immediately, the action log records the exact range that changed, and revert undoes the whole run in one click.

What is =AI()?

A worksheet function: give it a prompt and the cells to look at, and it returns one value per cell. Fill it down like any formula. A result stays put until its inputs change or you refresh it. On export, an =AI() cell is saved as the value it last computed, since Excel has no AI() function.

Try it on a file you already have

Start freeFree plan: 4 AI credits a day, 5 workbooks, no card.