Excel formula generator
Excel formulas from plain English.
Describe the calculation. Copy US-English, Hungarian Excel, or Sheets syntax, or edit a workbook file.
How to generate a formula
01
Open the Excel generator
Stay on this page so the model writes Excel function names.
02
Describe the calculation
Name ranges, criteria, and the result you want in the cell.
03
Copy the formula
The result starts with =. Paste it into the formula bar.
04
Test a sample row
Confirm a match, a miss, and a blank before you copy down.
Built for Microsoft Excel, not a blend.
This generator uses US-English Excel: commas, XLOOKUP, dynamic arrays, and older functions when you say the file cannot use them. Google Sheets QUERY does not belong here.
Excel function names
XLOOKUP, SUMIFS, FILTER, and IFERROR in the dialect your workbook actually runs.
Copy or upload
Copy the formula, or sign in and attach an .xlsx file so formulas can be written into a download.
History when signed in
Free keeps the last 5. Pro keeps every formula.
Excel work, from lookup to spill.
- 01
Write Excel formulas from plain English
Describe your ranges, criteria, and expected result without memorizing function syntax.
- 02
Review the formula logic
Get a concise explanation, stated assumptions, and useful alternatives with the result.
- 03
Use Excel-aware syntax
Generate formulas for Microsoft Excel with US-English function names and comma separators.
Ask with Excel details.
Lookups and matching
Build XLOOKUP, VLOOKUP, or INDEX MATCH formulas around your real lookup and return ranges.
Conditional calculations
State every condition for IF, SUMIFS, COUNTIFS, date windows, blanks, and error fallbacks.
Dates and workdays
Use the date workshop for NETWORKDAYS, WORKDAY, EOMONTH, EDATE, DATEDIF, and YEARFRAC, then generate with AI for holiday calendars or weekend rules.
Modern Excel arrays
Describe whether the result should spill and mention a preferred function such as FILTER, SORT, or UNIQUE.
Excel Tables
Name the Table and columns, then use the structured-references helper for SUBTOTAL, COUNTIFS, and XLOOKUP in Table[Column] syntax.
When 10 free generations a day are not enough.
500 generations per month. Full formula history. Priority AI processing. Yearly is $59. Save about $37 versus paying monthly.
$59/year
See Pro plansLearn the Excel formulas you use most.
View all guidesXLOOKUP
How to Use XLOOKUP in Excel: Syntax and Examples
XLOOKUP searches one row or column and returns the value from the same position in another row or column. It is a clearer, more flexible replacement for many VLOOKUP and INDEX/MATCH formulas.
Read guideVLOOKUP
VLOOKUP searches the first column of a table and returns a value from another column in the same row. It remains useful in older workbooks, but exact matching should be specified explicitly for most business data.
IF
The IF function tests a condition and returns one value when it is true and another when it is false. It is the foundation for conditional spreadsheet logic.
SUMIF
SUMIF adds values that meet one condition. The condition can target text, a number, a date, a comparison, or a wildcard pattern.
Excel generator FAQ
What does the Excel formula generator output?
A Microsoft Excel formula plus a short explanation. The copy dialect toggle switches US-English (commas, XLOOKUP), Hungarian Excel (semicolons, FKERES / SZUMHA / HA), and Sheets. Common names are translated where the pair is unambiguous; it is not a complete dictionary.
What should I include in a request?
Sheet layout, ranges such as A2:D100, criteria, and the result cell. Example: Sum D2:D100 when B is Paid and C is in the current month.
Does it work with Excel 2016?
Say so in the prompt if you cannot use XLOOKUP or FILTER. The generator can prefer VLOOKUP, SUMIFS, or helper-column patterns.
Can it fix #N/A or #SPILL!?
For a known broken formula, use the formula fixer and paste the error. For a new formula, describe the error you want to avoid.
Is there a daily limit?
Free use is 10 generations per day, signed in or not. Upgrade to Pro for 500 per month.
Where are Excel function examples?
See the Excel formula guides for syntax, examples, and mistakes, then return here to adapt a formula to your columns.
How do I write formulas for an Excel Table?
Name the Table and columns in your prompt, or open the Table structured-references helper for paste-ready Sales[Amount] and [@Amount] formulas, then send a variant to this generator.