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.
- Applied straight to your sheet
- Recalculates against your data
- Free plan, no card
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.
Questions about formulas
Is the formula generator free?
Yes. Formula requests use AI credits and the free plan includes 3 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.