What is an AI Excel formula generator?

It's a tool that turns a plain-English description of a calculation into a working Excel formula, referencing your own columns, instead of you writing the syntax by hand.

Can it write XLOOKUP and SUMIFS formulas?

Yes. XLOOKUP, VLOOKUP, INDEX/MATCH, SUMIFS, COUNTIFS, nested IF, and date functions are all covered, including IFERROR handling.

Does it work with Google Sheets formulas too?

Yes. Most formulas are identical in both, and Sehnna adjusts the syntax when a function differs between Excel and Google Sheets.

Can it explain a formula I already have?

Yes. Paste any formula and Sehnna breaks it down part by part, and points out why it returns an error or the wrong value.

Do I need to sign up to generate a formula?

No — you can try it free without signing up. Sign in when you want to save projects and get higher monthly limits.

AI spreadsheet tools

AI Excel Formula Generator

Describe the calculation in plain English and get a working Excel formula — XLOOKUP, SUMIFS, nested IF, INDEX/MATCH — explained and tested in a live sheet.

Turn plain English into working Excel formulas

Write what you want to calculate — "sum sales for Germany in Q3", "look up the price by SKU", "flag rows where the margin is under 10%" — and Sehnna returns a correct Excel formula you can paste straight into your sheet, with a short explanation of how it works.

Formulas Sehnna writes for you

XLOOKUP and VLOOKUP for pulling values from another table.
SUMIFS, COUNTIFS, and AVERAGEIFS for multi-condition totals.
Nested IF and IFS for tiered rules, commissions, and grading.
INDEX/MATCH for two-way lookups older Excel versions support.
TEXT, LEFT/RIGHT/MID, and TEXTSPLIT for cleaning messy columns.
Date maths with EOMONTH, NETWORKDAYS, DATEDIF, and YEARFRAC.
IFERROR wrappers so your sheet never shows #N/A or #DIV/0!.

How the formula generator works

Sehnna reads your description together with your actual column headers, so the formula references the right cells instead of made-up ranges. It picks the right function for your Excel version, wraps risky lookups in IFERROR, and shows the formula next to a live spreadsheet where you can see the calculated result immediately.

Step by step

Open the chat and paste your headers, or upload the file.
Describe the calculation in one sentence, in English or German.
Get the formula plus a plain-language explanation of each part.
See the result computed live in the editable preview.
Ask for a fix — "make it ignore blanks", "handle text numbers" — and iterate.
Download the sheet as .xlsx with the formulas intact.

Why generate formulas instead of searching for them

Forum answers use someone else's columns — Sehnna uses yours.
Complex nesting is where mistakes hide; the result is tested in a real sheet.
You get the explanation too, so the next version you can write yourself.
Errors like #N/A, #VALUE!, and #DIV/0! are handled up front.
The same chat can build the whole spreadsheet around the formula.

Fix a formula that is already broken

Paste a formula that returns the wrong number or an error and Sehnna explains what is failing — a shifted range, text stored as numbers, a missing absolute reference — and hands back a corrected version.

Build it faster with Sehnna

AI spreadsheet generator

Describe what you need — get an editable spreadsheet in seconds.

Excel template generator

90+ ready-to-use Excel & Google Sheets templates for business.

Enhance an existing Excel file

Upload a spreadsheet and let AI clean, format, and improve it.

Frequently asked questions

Create your spreadsheet with AI

Generate a custom Excel or Google Sheets file from a single prompt — no formulas required.